SAP VDKOREF Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. Table
Overview
VDKOREF is a standard SAP S/4HANA table that stores Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. data. There are total 25 fields in the VDKOREF table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDKOREF 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 VDKOREF to other SAP tables and standard CDS views available based on VDKOREF table in S/4HANA 2020.
Techincal Settings of VDKOREF
Below are technical details of the table VDKOREF
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDKOREF Fields
The following table gives you an overview of the fields available in VDKOREF
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RANTYP | Contract Type | RANTYP | CHAR | 1 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RANL | Contract Number | RANL | CHAR | 13 | |
| RLDEPO | Securities Account | RLDEPO | CHAR | 10 | |
| DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | |
| NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
| 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 | |
| SANLF | Product Category | SANLF | TZAF | NUMC | 3 |
| GSART | Product Type | VVSART | TZPA | CHAR | 3 |
| DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| REFKONTA | Old acct assignment reference for balance sheet transfer | KOREF_ALT | T037S | CHAR | 8 |
| REFKONTN | New acct assignment reference for balance sheet transfer | KOREF_NEU | T037S | CHAR | 8 |
| JGEBUCHT | Indicator that bal.sheet transfer posting was carried out | VVJGEBUCHT | CHAR | 1 | |
| JMELDCH | ID whether changes for the bal.sheet posting arise from BAV | VVJMELDCH | CHAR | 1 | |
| RUMBU | Processor of transfer | RUMBU | CHAR | 12 | |
| DUMBU | Date of transfer | DUMBU | DATS | 8 | |
| TUMBU | Time of transfer | TUMBU | TIMS | 6 |
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 VDKOREF
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDKOREF | BUKRS | : | T001 |
| VDKOREF | GSART | : | TZPA |
| VDKOREF | MANDT | : | T000 |
| VDKOREF | REFKONTA | : | T037S |
| VDKOREF | REFKONTN | : | T037S |
| VDKOREF | SANLF | : | TZAF |