VDKOREF SAP (Worklist File for Bal. Sheet Transfer / Acct Assignment Ref.) Table details
Dictionary Type: Table
Description: Worklist File for Bal. Sheet Transfer / Acct Assignment Ref.
Description: Worklist File for Bal. Sheet Transfer / Acct Assignment Ref.
Table field list including key, data, relationships and ABAP select examples
VDKOREF is a standard SAP Table which is used to store Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. data and is available within R/3 SAP systems depending on the version and release level.
The VDKOREF table consists of various fields, each holding specific information or linking keys about Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. data available in SAP. These include RANTYP (Contract Type), BUKRS (Company Code), RANL (Contract Number), RLDEPO (Securities Account).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VDKOREF table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RLDEPO | Securities Account | RLDEPO | CHAR | 10 | Assigned to domain | RLDEPO | DEP | ACC_CCD_CORE | |
DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | DATUM | ||||
NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | NUMC4 | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
REFKONTA | Old acct assignment reference for balance sheet transfer | KOREF_ALT | CHAR | 8 | T037S | USTRU | |||
REFKONTN | New acct assignment reference for balance sheet transfer | KOREF_NEU | CHAR | 8 | T037S | USTRU | KRE | ||
JGEBUCHT | Indicator that bal.sheet transfer posting was carried out | VVJGEBUCHT | CHAR | 1 | XFELD | ||||
JMELDCH | ID whether changes for the bal.sheet posting arise from BAV | VVJMELDCH | CHAR | 1 | XFELD | ||||
RUMBU | Processor of transfer | RUMBU | CHAR | 12 | SYCHAR12 | ||||
DUMBU | Date of transfer | DUMBU | DATS | 8 | DATUM | ||||
TUMBU | Time of transfer | TUMBU | TIMS | 6 | TIMES |
Key field | Non-key field |
How do I retrieve data from SAP table VDKOREF using ABAP code
The following ABAP code Example will allow you to do a basic selection on VDKOREF to SELECT all data from the tableDATA: WA_VDKOREF TYPE VDKOREF.
SELECT SINGLE *
FROM VDKOREF
INTO CORRESPONDING FIELDS OF WA_VDKOREF
WHERE...
How to access SAP table VDKOREF
Within an ECC or HANA version of SAP you can also view further information about VDKOREF and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects