SAP VDBEKI Flow Data: Document Header for Actual Record Table
Overview
VDBEKI is a standard SAP S/4HANA table that stores Flow Data: Document Header for Actual Record data. There are total 50 fields in the VDBEKI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDBEKI belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).
In addition, following links provide an overview of foreign key relationships, if any, that link VDBEKI to other SAP tables and standard CDS views available based on VDBEKI table in S/4HANA 2020.
Techincal Settings of VDBEKI
Below are technical details of the table VDBEKI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDBEKI Fields
The following table gives you an overview of the fields available in VDBEKI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RBELKPFD | Document Number of Document Header (Loan) | RBELKPFD | CHAR | 10 | |
| SANLF | Product Category | SANLF | * | NUMC | 3 |
| RANL | Contract Number | RANL | CHAR | 13 | |
| DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | |
| NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | |
| RKLAMMER | Classification Number for Finance Projects | RKLAMMER | CHAR | 13 | |
| DVORGANG | Activity date | DVORGANG | DATS | 8 | |
| SVORGANG | Business Operation (Activity) | SVORFALL | CHAR | 4 | |
| NVORGANG | Activity number | NVORGANG | CHAR | 3 | |
| SSTATI | Status of data record | SSTATI | * | NUMC | 2 |
| RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | * | CHAR | 8 |
| HKONT | General Ledger Account | HKONT | SKB1 | CHAR | 10 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| 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 | |
| SSTORNO | Reversal indicator | SSTORNO | CHAR | 1 | |
| SSTOGRD | Reason for Reversal | SSTOGRD | TZST | CHAR | 2 |
| ZUONR | Assignment number | DZUONR | CHAR | 18 | |
| RSTBLG | Reverse Document Number | STBLG | CHAR | 10 | |
| RZEBEL | Doc.no. of debit pos. doc.header (only for inc.pmnt records) | RZEBEL | CHAR | 10 | |
| 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 | Order Number | NORDER | NUMC | 8 | |
| RBANKK | Bank account | RBANKK | SKB1 | CHAR | 10 |
| 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 | |
| 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 | |
| DSTOCK | Premium reserve fund date | VVDSTOCK | DATS | 8 | |
| RPNNR | Daybook no. | VVRPNNR | CHAR | 10 | |
| RVZBLG | Accounting Document Number | BELNR_D | CHAR | 10 | |
| RPNSUP | Super prima nota for grouping in autom.deb.pos. | VVRPNSUP | CHAR | 10 | |
| RUMBLG | Reference transfer document number | UMBLG | CHAR | 10 | |
| SEVALPOST | PEC for flow executed indicator yes/no | SEVALPOST | CHAR | 1 | |
| RUZBEL | Accounting Document Number | BELNR_D | CHAR | 10 | |
| ACENV | Source in TR-LO posting area | ACENV_LO | NUMC | 4 | |
| S_COMPR | Summarization indicator for summarization of loan doc. data | S_COMPR | CHAR | 1 | |
| CD_POST | Flag: Post to Collections & Disbursements | FVD_CD_POST | 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 VDBEKI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDBEKI | BUKRS | 1: CN | T001 |
| VDBEKI | GSBER | 1: CN | TGSB |
| VDBEKI | HKONT | 1: CN | SKB1 |
| VDBEKI | MANDT | 1: CN | T000 |
| VDBEKI | RBANKK | 1: CN | SKB1 |
| VDBEKI | SBLART | 1: CN | T003 |
| VDBEKI | SSTOGRD | 1: 1 | TZST |