SAP VDKOREF Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. Table data and field list

VDKOREF is a standard SAP Table which is used to store Worklist File for Bal. Sheet Transfer / Acct Assignment Ref. data in SAP systems, such as SAP R/3, S/4HANA, 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. .

VDKOREF table Technical Details:

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VDKOREF table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

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

< VDKOPO_EU - Condition Item Data Before EURO Conversion (Loans) VDKOREF_ADD - VDKOREF with Necessary Posting Fields Added >

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).