SAP VWBEKI Treasury Securities: Actual Flows - Header Table
Overview
VWBEKI is a standard SAP S/4HANA table that stores Treasury Securities: Actual Flows - Header data. There are total 60 fields in the VWBEKI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VWBEKI 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 VWBEKI to other SAP tables and standard CDS views available based on VWBEKI table in S/4HANA 2020.
Techincal Settings of VWBEKI
Below are technical details of the table VWBEKI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VWBEKI Fields
The following table gives you an overview of the fields available in VWBEKI
| 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 | CHAR | 10 | |
| RANL | Security Class ID Number | VVRANLW | VWPANLA | CHAR | 13 |
| RLDEPO | Securities Account | RLDEPO | TWD01 | CHAR | 10 |
| DVORGANG | Activity date | DVORGANG | DATS | 8 | |
| SVORGANG | Securities-Activity | RVORGANG | CHAR | 8 | |
| SSTATI | Status of data record | SSTATI | * | NUMC | 2 |
| INTEB | Financial Assets Management internal level | VVSINTEB | * | NUMC | 2 |
| RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | * | CHAR | 8 |
| HKONT | General Ledger Account | HKONT | * | CHAR | 10 |
| RBELNRFI | Accounting Document Number | BELNR_D | CHAR | 10 | |
| RBELNRFI2 | Accounting Document Number | BELNR_D | CHAR | 10 | |
| SBLART | Document Type | BLART | T003 | CHAR | 2 |
| DBLDAT | Document Date in Document | BLDAT | DATS | 8 | |
| DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| DGJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| DMONAT | Fiscal period | MONAT | NUMC | 2 | |
| RSTBLG | Reverse Document Number | STBLG | CHAR | 10 | |
| SSTORNO | Reversal indicator | SSTORNO | CHAR | 1 | |
| SSTOGRD | Reason for Reversal | SSTOGRD | TZST | CHAR | 2 |
| DORDER | Order day | DORDER | DATS | 8 | |
| DANJRNL | Date of transferal to journal | DANJRNL | DATS | 8 | |
| DANFIBU | Date of transferal to FiAc | DANFIBU | DATS | 8 | |
| UANFIBU | Time of transfer to financial accounting | UANFIBU | TIMS | 6 | |
| SSPESEN | Expenses key | SSPESEN | CHAR | 1 | |
| NORDER | Position number | SECPOSITIONNUMBER | NUMC | 8 | |
| NORDEXT | External order number | NORDEXT | CHAR | 20 | |
| RBANKK | Bank account | RBANKK | SKA1 | CHAR | 10 |
| RKONTRA | Reference to Counterparty | RKONTRA_NEW | * | CHAR | 10 |
| SROLEXTKO | Dummy function | DUMMY_3 | CHAR | 3 | |
| RDEALER | Trader | RDEALER | * | CHAR | 12 |
| XZUSATZ | Assignment | XZUSATZ | CHAR | 18 | |
| SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 1 | |
| SSTCKTG | Accrued interest: Daily method | SSTCKTG | CHAR | 1 | |
| PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10 | |
| SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| KOSTL | Cost Center | KOSTL | * | CHAR | 10 |
| SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | |
| RZBANK | Paying Bank | VVRZBANK_NEW | BUT000 | CHAR | 10 |
| SROLEXTZB | Dummy function | DUMMY_3 | CHAR | 3 | |
| DSTOCK | Premium reserve fund date | VVDSTOCK | DATS | 8 | |
| RPNNR | Daybook no. | VVRPNNR | CHAR | 10 | |
| RHANDPL | Exchange | VVRHANDPL | TWH01 | CHAR | 10 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| SEVALPOST | PEC for flow executed indicator yes/no | SEVALPOST | CHAR | 1 | |
| REFRLDEPO | Reference sec.acct for sec.acct transfer (inflow/outflow) | VVREFRLDEP | * | CHAR | 10 |
| PEFFZCALL | Effective Interest Rate | PEFFZINS | DEC | 10 | |
| JVERK6B | Sale in Acc. with Tax Credit Method | VVJVERK6B | CHAR | 1 | |
| TRSEDOCNR1 | Document number of security posting document | TRSEDOCNR | VWPOSTDOC | CHAR | 10 |
| TRSEGJAHR1 | Fiscal Year | GJAHR | NUMC | 4 | |
| TRSEDOCNR2 | Document number of security posting document | TRSEDOCNR | VWPOSTDOC | CHAR | 10 |
| TRSEGJAHR2 | Fiscal Year | GJAHR | NUMC | 4 | |
| DEVALPOST | Date of period-end closing | DEVALPOST | DATS | 8 | |
| SHERKUNFT | Origin indicator: 'From planned record/actual record' | VVSHERK | CHAR | 1 | |
| ZUOND | Assignment | TB_ZUOND | CHAR | 18 | |
| REFER | Internal Reference | TB_REFER | CHAR | 16 | |
| MERKM | Characteristics | TB_MERKM | CHAR | 25 | |
| RFHA | Financial Transaction | TB_RFHA | * | CHAR | 13 |
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 VWBEKI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VWBEKI | BUKRS | 1: CN | T001 |
| VWBEKI | GSBER | 1: CN | TGSB |
| VWBEKI | MANDT | 1: CN | T000 |
| VWBEKI | OBJNR | 1: 1 | ONR00 |
| VWBEKI | RANL | 1: CN | VWPANLA |
| VWBEKI | RBANKK | 1: 1 | SKA1 |
| VWBEKI | RHANDPL | C: CN | TWH01 |
| VWBEKI | RLDEPO | 1: CN | TWD01 |
| VWBEKI | RZBANK | C: CN | BUT000 |
| VWBEKI | SBLART | 1: 1 | T003 |
| VWBEKI | SSTOGRD | 1: 1 | TZST |
| VWBEKI | TRSEDOCNR1 | C: N | VWPOSTDOC |
| VWBEKI | TRSEDOCNR2 | C: N | VWPOSTDOC |