SAP VWBEPI Treasury Securities: Actual Flows - Item Table
Overview
VWBEPI is a standard SAP S/4HANA table that stores Treasury Securities: Actual Flows - Item data. There are total 114 fields in the VWBEPI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VWBEPI belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package Treasury Management: Securities (FVVW).
In addition, following links provide an overview of foreign key relationships, if any, that link VWBEPI to other SAP tables and standard CDS views available based on VWBEPI table in S/4HANA 2020.
Techincal Settings of VWBEPI
Below are technical details of the table VWBEPI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VWBEPI Fields
The following table gives you an overview of the fields available in VWBEPI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RBELNR | Number of flow header | RBELKPF | VWBEKI | CHAR | 10 |
| RPOSNR | Activity number | NVORGANG | CHAR | 3 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| SBEWART | Flow Type | SBEWART | TZB0A | CHAR | 4 |
| SBEWZITI | Flow category | SBEWZITI | TZB03 | CHAR | 4 |
| SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | |
| SNWHR | Currency of nominal amount | SNWHR | TCURC | CUKY | 5 |
| SBWHR | Position Currency (Currency of Position Amount) | SBWHR | TCURC | CUKY | 5 |
| SCWHR | Settlement Currency | SCWHR | TCURC | CUKY | 5 |
| ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15 | |
| BWKURS | Security price for unit quotation | BWKURS | CURR | 13 | |
| BNWHR | Nominal amount | BNWHR | CURR | 13 | |
| PWKURS | Security price for percentage quotation | PWKURS | DEC | 10 | |
| BBWHR | Amount in position currency | BBWHR | CURR | 13 | |
| BCWHR | Settlement Amount | BCWHR | CURR | 13 | |
| BHWHR | Amount in local currency | BHWHR | CURR | 13 | |
| KURS1 | Exchange rate | KURSF | DEC | 9 | |
| KURS2 | Exchange rate | KURSF | DEC | 9 | |
| DVALUT | Interest Value Date/Calculation Date | VVDZINVAL | DATS | 8 | |
| DDISPO | Value Date / Planning Day | VVDWERTST | DATS | 8 | |
| DBESTAND | Position value date | DBESTAND | DATS | 8 | |
| DBEST6B | Date for §6b EstG relevant postings | DBEST6B | DATS | 8 | |
| RSOLL | Account for debit posting | RSOLL | SKA1 | CHAR | 10 |
| SBSLSOLL | Posting Key | BSCHL | CHAR | 2 | |
| RZKSOLL | Debit interim account | RZKSOLL | SKA1 | CHAR | 10 |
| SBSLZKSO | Posting Key | BSCHL | CHAR | 2 | |
| RZKHABE | Credit interim account | RZKHABE | SKA1 | CHAR | 10 |
| SBSLZKHA | Posting Key | BSCHL | CHAR | 2 | |
| RHABEN | Account for credit posting | RHABEN | SKA1 | CHAR | 10 |
| SBSLHABEN | Posting Key | BSCHL | CHAR | 2 | |
| SWHRT | Currency swap indicator | SWHRT | CHAR | 1 | |
| JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | |
| JZINSBAS | Flow in interest base | JZINSBAS | CHAR | 1 | |
| JZINSZPT | Interest date | JZINSZPT | CHAR | 1 | |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | |
| DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | |
| ATAGE | Number of Days | VVATAGE | NUMC | 6 | |
| ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | |
| JEXPOZINS | Type of Compound Interest Calculation | TFM_SINTCOMP | CHAR | 1 | |
| SWOHER | Treasury: Source of Flow | TB_SWOHER | CHAR | 1 | |
| JSTOCK | Premium reserve fund-relevant indicator | VVJSTOCK | CHAR | 1 | |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | TZK01 | NUMC | 4 |
| SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | |
| SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | |
| SINCLVON | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | |
| SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | |
| DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | |
| DPKOND | Fixing Date of Percentage Rate from Condition | VVDPKOND | DATS | 8 | |
| SREFZITI | Refer.flow category in accrual/deferral flow records | VVSREFZITI | CHAR | 4 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | |
| APERTAGE | No. of days of a (calculation) period in cash flow | VVAPERTAGE | NUMC | 6 | |
| STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | |
| STGBASIS | Base Days Method | VVSTGBASIS | CHAR | 1 | |
| DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | |
| SPAEXCL | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | NUMC | 1 | |
| SPAULT | Month-End Indicator for Start Date of a Period | TFMSPAULT | CHAR | 1 | |
| DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | |
| SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | |
| SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | |
| SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | |
| SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | |
| DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | |
| NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | |
| DCOUPON | Coupon date of next delivered coupon | VVDCOUPON | DATS | 8 | |
| SCOUPON | Coupon ID for interest and accrued interest calculation | VVSCOUPON | CHAR | 1 | |
| SFLAT | Indicator 'Traded flat'i.e.no accrued interest calculation | VVSFLAT | CHAR | 1 | |
| SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | AT40 | CHAR | 4 |
| SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 2 | |
| SREFBEW | Reference flow type | SREFBEW | CHAR | 4 | |
| SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | |
| SSWHR | Stock price currency | VVSSWHR | TCURC | CUKY | 5 |
| BSWHR | Market value | VVBSWHR | CURR | 13 | |
| SRUNIT | Currency unit | VVSRUNIT | TZUNI | CHAR | 5 |
| KWKURS | Security price | VVKWKURS | DEC | 15 | |
| DSCHLUSS | Date of business closing | VVDSCHLUSS | DATS | 8 | |
| TSCHLUSS | Time of business closing | VVTSCHLUSS | TIMS | 6 | |
| SBUCHA | Indicator for postings to accruals/deferrals accounts | VVSBUCHA | CHAR | 1 | |
| RAHABKI | Short Key for Own House Bank | TB_RHABKI | CHAR | 5 | |
| RAHKTID | Short Key for House Bank Account | TB_RHKTID | CHAR | 5 | |
| RPBANK | Partner Bank Details | TB_RPBANK | CHAR | 4 | |
| ZLSCH | Payment Method | DZLSCH | CHAR | 1 | |
| SZART | Payment Transaction | TB_SZART | CHAR | 1 | |
| KGV_FLAG | Manages status of the related price gains/losses flows | TKGV | CHAR | 1 | |
| DZFEST | Interest rate fixing date | TB_DZFEST | DATS | 8 | |
| KMNR | Corporate Action Number | KMNR | CHAR | 13 | |
| ERNR | ID number of exercised right | TER_HEADNUMBER | CHAR | 13 | |
| SPAYRQ | Generate Payment Request | TB_SPAYRQK | CHAR | 1 | |
| SPRSNG | Individual Payment | TB_SPRSNGK | CHAR | 1 | |
| PRKEY | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | |
| RPZAHL | Payer/Payee | TB_RPZAHL_NEW | CHAR | 10 | |
| INDEX_VALUE | Index Value (Independent of Basis) | TIDX_INDEX_VALUE_NO_RATIO | DEC | 18 | |
| PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11 | |
| BBWHR_IDX_CLEAN | Amount in position currency | BBWHR | CURR | 13 | |
| BUSTRANSID | Identifier of the Distributor Business Transaction | TPM_BUSTRANSID | RAW | 16 | |
| BUSTRANSCAT | Business Transaction Category | TPM_BUSTRANSCAT | TRDTS_BT_CAT | NUMC | 4 |
| LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | |
| MIGR_CFM10 | Status of Flow Related to Migration to CFM 1.0 | TPM_MIGR_CFM10 | CHAR | 1 | |
| MIGR_ERP20 | Status of Flow Related to Migration to ERP2.0 | TPM_MIGR_ERP20 | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VWBEPI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VWBEPI | BUKRS | 1: CN | T001 |
| VWBEPI | BUSTRANSCAT | C: CN | TRDTS_BT_CAT |
| VWBEPI | KUNNR | 1: CN | KNA1 |
| VWBEPI | MANDT | 1: CN | T000 |
| VWBEPI | RBELNR | 1: CN | VWBEKI |
| VWBEPI | RHABEN | 1: 1 | SKA1 |
| VWBEPI | RSOLL | 1: 1 | SKA1 |
| VWBEPI | RZKHABE | 1: 1 | SKA1 |
| VWBEPI | RZKSOLL | 1: 1 | SKA1 |
| VWBEPI | SBERFIMA | : | AT40 |
| VWBEPI | SBEWART | : | TZB0A |
| VWBEPI | SBEWZITI | : | TZB03 |
| VWBEPI | SBWHR | 1: 1 | TCURC |
| VWBEPI | SCWHR | 1: 1 | TCURC |
| VWBEPI | SKOART | C: CN | TZK01 |
| VWBEPI | SNWHR | 1: 1 | TCURC |
| VWBEPI | SRUNIT | 1: CN | TZUNI |
| VWBEPI | SSWHR | 1: CN | TCURC |