VDCFWAREHOUSE SAP (Cash Flow Management) Table details

Dictionary Type: Table
Description: Cash Flow Management




ABAP Code to SELECT data from VDCFWAREHOUSE
Related tables to VDCFWAREHOUSE
Access table VDCFWAREHOUSE




Table field list including key, data, relationships and ABAP select examples

VDCFWAREHOUSE is a standard SAP Table which is used to store Cash Flow Management data and is available within R/3 SAP systems 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. .

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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
RBOKEYBusiness Operation Number (Loans) RBOCHAR15RBO
SCFTYPCash Flow Category History TB_SCFTYPCHAR2T_SCFTYP
DTRANSFlow data key: System date VVDTRANSDATS8DATUM
TTRANSTransaction data key: system time VVTTRANSTIMS6UZEIT
NTRANSTransaction data key: Consecutive number VVNTRANSNUMC4NUMC4
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
RANLContract Number RANLCHAR13ALPHARANLRAN
RBOBusiness Operation Number (Loans) RBOCHAR15RBO
SBEWARTFlow Type SBEWARTCHAR4Assigned to domainSBEWART
SPLANISTPlan/actual record/record to be released indicator SPLANISTCHAR1SPLANIST
SREFBEWReference flow type SREFBEWCHAR4Assigned to domainSBEWART
SBEWZITIFlow category SBEWZITICHAR4Assigned to domainSBEWZITI
SREFZITIRefer.flow category in accrual/deferral flow records VVSREFZITICHAR4Assigned to domainSBEWZITI
S_SSDREFReference flow category in borrower's note loan flow records VVS_SSDREFCHAR4Assigned to domainSBEWZITI
SREVALEXCLPrice gains w/o proportionate gains from deferral write-back VVSREVALEXCLCHAR1XFELD
SWOHERSource of flow record SWOHERCHAR1CHAR1
DGUEL_KKDate Condition Effective from DGUELDATS8DATUM
SKOARTCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4Assigned to domainSKOART
SVORGANGBusiness Operation (Activity) SVORFALLCHAR4SVORFALL
ACENVSource in TR-LO posting area ACENV_LONUMC4ACENV_LO
DGUEL_KPCondition Item Valid From DGUEL_KPDATS8DATUM
NSTUFELevel number of condition item for recurring payments NSTUFENUMC2NUMC2
SVORGKZActivity indicator for debit/credit control VVSVORGKZNUMC2VVSVORGKZ
SSOLHABDebit/credit indicator VVSSOLHABCHAR1VVSSOLHAB
SBERFIMACalculation category for cash flow calculator SBEWFIMACHAR4Assigned to domainSBEWFIMA
SSTCKKZAccrued interest method SSTCKKZCHAR1SSTCKKZ
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
STGMETHDaily Method VVSTGMETHNUMC1VVSTGMETH
STGBASISBase Days Method VVSTGBASISNUMC1VVSTGBASIS
ABASTAGENumber of base days in a calculation period ABASTAGENUMC6INT6
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
DPKONDDetermination date for percentage rate of condition items VVDPKONDDATS8DATUM
SBASISCalculation base indicator SBASISCHAR4Assigned to domainVVSBASIS
JSOFVERRImmediate settlement JSOFVERRCHAR1TFMSOFVERR
DVALUTCalculation Date DVALUTDATS8DATUM
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
SVULTMonth-End Indicator for Value Date VVSVULTCHAR1VVSULT
DBERVONStart of Calculation Period DBERVONDATS8DATUM
SEXCLVONExclusive Indicator for the Start of a Calculation Period VVSEXCLVONNUMC1VVSEXCLVON
SULTVONMonth-End Indicator for Start of a Calculation Period VVSULTVONCHAR1VVSULT
DBERBISEnd of Calculation Period DBERBISDATS8DATUM
SINCLBISInclusive Indicator for the End of a Calculation Period VVSINCLBISNUMC1VVSINCLBIS
SULTBISMonth-End Indicator for the End of a Calculation Period VVSULTBISCHAR1VVSULT
ATAGENumber of days VVATAGENUMC6INT6
DFAELLDue date DFAELLDATS8DATUM
DDISPOPayment Date DDISPODATS8DATUM
DEPERIODPeriod End VVDEPERIODDATS8DATUM
SPEINCLInclusive Indicator for End Date of a Period TFMSPEINCLNUMC1TFMSPEINCL
SPEULTMonth-End Indicator for End of a Period TFMSPEULTCHAR1VVSULT
DVERRECHSettlement date VVDVERRECHDATS8DATUM
SINCLVERRInclusive Indicator for Clearing Date VVSINCLVERNUMC1VVSINCLVER
SULTVERRMonth-End Indicator for Clearing Date VVSULTVERRCHAR1VVSULT
DBUDATPosting Date in the Document BUDATDATS8DATUM
SNWHRCurrency of nominal amount SNWHRCUKY5Assigned to domainWAERS
BNWHRNominal amount BNWHRCURR13(2) WERTV7
SBWHRPosition Currency (Currency of Position Amount) SBWHRCUKY5Assigned to domainWAERS
BBWHRAmount in position currency BBWHRCURR13(2) WERTV7
SCWHRSettlement Currency SCWHRCUKY5Assigned to domainWAERS
BCWHRSettlement Amount BCWHRCURR13(2) WERTV7
BHWHRAmount in local currency BHWHRCURR13(2) WERTV7
BBASISCalculation base amount BBASISCURR13(2) WERTV7
PEFFZINSEffective Interest Rate PEFFZINSDEC10(7) DEC3_7
SEFFMETHEffective Interest Method (Financial Mathematics) SEFFMETHNUMC1SEFFMETH
DBPERIODPeriod start VVDBPERIODDATS8DATUM
ZUONRAssignment Number DZUONRCHAR18ZUONR
SGTXTItem Text SGTXTCHAR50TEXT50
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
MABERDunning Area MABERCHAR2Assigned to domainMABER
RPARTNRBusiness Partner Number BP_PARTNR_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SZEGENGenerate incoming payment immediately SZEGENNUMC2Assigned to domainSZEGEN
HDN_KUNNRMain Borrower Customer Number HDN_KUNNRCHAR10Assigned to domainALPHAKUNNR
SZARTPayment transaction TB_SZARTCHAR1XFELD
JONLAENIndicator for fixing a flow record JONLAENCHAR1VVSONLAEN
VORGTYPActivity Category (Posting Area) VORGTYP_LOCHAR4VORGTYP_LO
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
DFAELL_OLD_EXTOld Due Date TB_EXTENS_DFAELL_OLDDATS8DATUM
DDISPO_OLD_EXTOld Payment Date TB_EXTENS_DDISPO_OLDDATS8DATUM
RBO_EXTBusiness Operation Number (Loans) RBOCHAR15RBO
MANSPDunning block MANSPCHAR1Assigned to domainMANSP
ZAHLSBlock Key for Payment DZAHLSCHAR1Assigned to domainZAHLS
REMIT_INFOPayment Notes Info TB_REMIT_INFOCHAR140T_REMIT_INFO
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035

Key field Non-key field



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).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!