SAP VDCFWAREHOUSE Cash Flow Management Table data and field list

VDCFWAREHOUSE is a standard SAP Table which is used to store Cash Flow Management data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDCFWAREHOUSE table consists of various fields, each holding specific information or linking keys about Cash Flow Management data available in SAP. These include RBOKEY (Business Operation Number (Loans)), SCFTYP (Cash Flow Category History), DTRANS (Flow data key: System date), TTRANS (Transaction data key: system time)... 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. .

VDCFWAREHOUSE 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 VDCFWAREHOUSE 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 VDCFWAREHOUSE 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	Assigned to domain		MANDT
RBOKEY	Business Operation Number (Loans)	RBO	CHAR	15			RBO
SCFTYP	Cash Flow Category History	TB_SCFTYP	CHAR	2			T_SCFTYP
DTRANS	Flow data key: System date	VVDTRANS	DATS	8			DATUM
TTRANS	Transaction data key: system time	VVTTRANS	TIMS	6			UZEIT
NTRANS	Transaction data key: Consecutive number	VVNTRANS	NUMC	4			NUMC4
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
RANL	Contract Number	RANL	CHAR	13		ALPHA	RANL	RAN
RBO	Business Operation Number (Loans)	RBO	CHAR	15			RBO
SBEWART	Flow Type	SBEWART	CHAR	4	Assigned to domain		SBEWART
SPLANIST	Plan/actual record/record to be released indicator	SPLANIST	CHAR	1			SPLANIST
SREFBEW	Reference flow type	SREFBEW	CHAR	4	Assigned to domain		SBEWART
SBEWZITI	Flow category	SBEWZITI	CHAR	4	Assigned to domain		SBEWZITI
SREFZITI	Refer.flow category in accrual/deferral flow records	VVSREFZITI	CHAR	4	Assigned to domain		SBEWZITI
S_SSDREF	Reference flow category in borrower's note loan flow records	VVS_SSDREF	CHAR	4	Assigned to domain		SBEWZITI
SREVALEXCL	Price gains w/o proportionate gains from deferral write-back	VVSREVALEXCL	CHAR	1			XFELD
SWOHER	Source of flow record	SWOHER	CHAR	1			CHAR1
DGUEL_KK	Date Condition Effective from	DGUEL	DATS	8			DATUM
SKOART	Condition Type (Smallest Subdivision of Condition Records)	SKOART	NUMC	4	Assigned to domain		SKOART
SVORGANG	Business Operation (Activity)	SVORFALL	CHAR	4			SVORFALL
ACENV	Source in TR-LO posting area	ACENV_LO	NUMC	4			ACENV_LO
DGUEL_KP	Condition Item Valid From	DGUEL_KP	DATS	8			DATUM
NSTUFE	Level number of condition item for recurring payments	NSTUFE	NUMC	2			NUMC2
SVORGKZ	Activity indicator for debit/credit control	VVSVORGKZ	NUMC	2			VVSVORGKZ
SSOLHAB	Debit/credit indicator	VVSSOLHAB	CHAR	1			VVSSOLHAB
SBERFIMA	Calculation category for cash flow calculator	SBEWFIMA	CHAR	4	Assigned to domain		SBEWFIMA
SSTCKKZ	Accrued interest method	SSTCKKZ	CHAR	1			SSTCKKZ
SZBMETH	Interest Calculation Method	SZBMETH	CHAR	1			SZBMETH
STGMETH	Daily Method	VVSTGMETH	NUMC	1			VVSTGMETH
STGBASIS	Base Days Method	VVSTGBASIS	NUMC	1			VVSTGBASIS
ABASTAGE	Number of base days in a calculation period	ABASTAGE	NUMC	6			INT6
PKOND	Percentage rate for condition items	PKOND	DEC	10(7)			DECV3_7
DPKOND	Determination date for percentage rate of condition items	VVDPKOND	DATS	8			DATUM
SBASIS	Calculation base indicator	SBASIS	CHAR	4	Assigned to domain		VVSBASIS
JSOFVERR	Immediate settlement	JSOFVERR	CHAR	1			TFMSOFVERR
DVALUT	Calculation Date	DVALUT	DATS	8			DATUM
SINCL	Inclusive indicator for beginning and end of a period	VVSINCL	NUMC	1			VVSINCL
SVULT	Month-End Indicator for Value Date	VVSVULT	CHAR	1			VVSULT
DBERVON	Start of Calculation Period	DBERVON	DATS	8			DATUM
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	VVSEXCLVON	NUMC	1			VVSEXCLVON
SULTVON	Month-End Indicator for Start of a Calculation Period	VVSULTVON	CHAR	1			VVSULT
DBERBIS	End of Calculation Period	DBERBIS	DATS	8			DATUM
SINCLBIS	Inclusive Indicator for the End of a Calculation Period	VVSINCLBIS	NUMC	1			VVSINCLBIS
SULTBIS	Month-End Indicator for the End of a Calculation Period	VVSULTBIS	CHAR	1			VVSULT
ATAGE	Number of days	VVATAGE	NUMC	6			INT6
DFAELL	Due date	DFAELL	DATS	8			DATUM
DDISPO	Payment Date	DDISPO	DATS	8			DATUM
DEPERIOD	Period End	VVDEPERIOD	DATS	8			DATUM
SPEINCL	Inclusive Indicator for End Date of a Period	TFMSPEINCL	NUMC	1			TFMSPEINCL
SPEULT	Month-End Indicator for End of a Period	TFMSPEULT	CHAR	1			VVSULT
DVERRECH	Settlement date	VVDVERRECH	DATS	8			DATUM
SINCLVERR	Inclusive Indicator for Clearing Date	VVSINCLVER	NUMC	1			VVSINCLVER
SULTVERR	Month-End Indicator for Clearing Date	VVSULTVERR	CHAR	1			VVSULT
DBUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
SNWHR	Currency of nominal amount	SNWHR	CUKY	5	Assigned to domain		WAERS
BNWHR	Nominal amount	BNWHR	CURR	13(2)			WERTV7
SBWHR	Position Currency (Currency of Position Amount)	SBWHR	CUKY	5	Assigned to domain		WAERS
BBWHR	Amount in position currency	BBWHR	CURR	13(2)			WERTV7
SCWHR	Settlement Currency	SCWHR	CUKY	5	Assigned to domain		WAERS
BCWHR	Settlement Amount	BCWHR	CURR	13(2)			WERTV7
BHWHR	Amount in local currency	BHWHR	CURR	13(2)			WERTV7
BBASIS	Calculation base amount	BBASIS	CURR	13(2)			WERTV7
PEFFZINS	Effective Interest Rate	PEFFZINS	DEC	10(7)			DEC3_7
SEFFMETH	Effective Interest Method (Financial Mathematics)	SEFFMETH	NUMC	1			SEFFMETH
DBPERIOD	Period start	VVDBPERIOD	DATS	8			DATUM
ZUONR	Assignment Number	DZUONR	CHAR	18			ZUONR
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
BVTYP	Partner Bank Type	BVTYP	CHAR	4			BVTYP
ZLSCH	Payment Method	DZLSCH	CHAR	1	Assigned to domain		ZLSCH
MABER	Dunning Area	MABER	CHAR	2	Assigned to domain		MABER
RPARTNR	Business Partner Number	BP_PARTNR_NEW	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
SZEGEN	Generate incoming payment immediately	SZEGEN	NUMC	2	Assigned to domain		SZEGEN
HDN_KUNNR	Main Borrower Customer Number	HDN_KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR
SZART	Payment transaction	TB_SZART	CHAR	1			XFELD
JONLAEN	Indicator for fixing a flow record	JONLAEN	CHAR	1			VVSONLAEN
VORGTYP	Activity Category (Posting Area)	VORGTYP_LO	CHAR	4			VORGTYP_LO
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ	NUMC	4		GJAHR	GJAHR
REBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
REBZZ	Line Item in the Relevant Invoice	REBZZ	NUMC	3			BUZEI
DFAELL_OLD_EXT	Old Due Date	TB_EXTENS_DFAELL_OLD	DATS	8			DATUM
DDISPO_OLD_EXT	Old Payment Date	TB_EXTENS_DDISPO_OLD	DATS	8			DATUM
RBO_EXT	Business Operation Number (Loans)	RBO	CHAR	15			RBO
MANSP	Dunning block	MANSP	CHAR	1	Assigned to domain		MANSP
ZAHLS	Block Key for Payment	DZAHLS	CHAR	1	Assigned to domain		ZAHLS
REMIT_INFO	Payment Notes Info	TB_REMIT_INFO	CHAR	140			T_REMIT_INFO
MNDID	Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35			ID035

Key field

Non-key field

< VDCBR_RES_PART - Partner Data Reported to Credit Bureau (Pro Loan) VDCHARACDOC - Processing Characteristics: Change Documents >

How do I retrieve data from SAP table VDCFWAREHOUSE using ABAP code

The following ABAP code Example will allow you to do a basic selection on VDCFWAREHOUSE to SELECT all data from the table
DATA: WA_VDCFWAREHOUSE TYPE VDCFWAREHOUSE.

SELECT SINGLE *
FROM VDCFWAREHOUSE
INTO CORRESPONDING FIELDS OF WA_VDCFWAREHOUSE
WHERE...

How to access SAP table VDCFWAREHOUSE

Within an ECC or HANA version of SAP you can also view further information about VDCFWAREHOUSE and the data within it using relevant transactions such as

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