VDCFWAREHOUSE - Cash Flow Management

Cash Flow Management information is stored in SAP table VDCFWAREHOUSE.
It is part of development package FVVD_REP in software component FS-CML. This development package consists of objects that can be grouped under "Payoff".

Fields for table VDCFWAREHOUSE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
RBOKEY	Business Operation Number (Loans)	X	RBO	CHAR	30
SCFTYP	Cash Flow Category History	X	TB_SCFTYP	CHAR	4
DTRANS	Flow data key: System date	X	VVDTRANS	DATS	16
TTRANS	Transaction data key: system time	X	VVTTRANS	TIMS	12
NTRANS	Transaction data key: Consecutive number	X	VVNTRANS	NUMC	8
BUKRS	Company Code		BUKRS	CHAR	8
RANL	Contract Number		RANL	CHAR	26
RBO	Business Operation Number (Loans)		RBO	CHAR	30
SBEWART	Flow Type		SBEWART	CHAR	8
.INCLUDE				RTRDC_REC_FIELDS	0
SPLANIST	Plan/actual record/record to be released indicator		SPLANIST	CHAR	2
SREFBEW	Reference flow type		SREFBEW	CHAR	8	*
SBEWZITI	Flow category		SBEWZITI	CHAR	8	*
SREFZITI	Refer.flow category in accrual/deferral flow records		VVSREFZITI	CHAR	8	*
S_SSDREF	Reference flow category in borrower's note loan flow records		VVS_SSDREF	CHAR	8	*
SREVALEXCL	Price gains w/o proportionate gains from deferral write-back		VVSREVALEXCL	CHAR	2
SWOHER	Source of flow record		SWOHER	CHAR	2
DGUEL_KK	Date Condition Effective from		DGUEL	DATS	16
SKOART	Condition Type (Smallest Subdivision of Condition Records)		SKOART	NUMC	8	*
SVORGANG	Business Operation (Activity)		SVORFALL	CHAR	8
ACENV	Source in TR-LO posting area		ACENV_LO	NUMC	8
DGUEL_KP	Condition Item Effective From		DGUEL_KP	DATS	16
NSTUFE	Level number of condition item for recurring payments		NSTUFE	NUMC	4
SVORGKZ	Activity indicator for debit/credit control		VVSVORGKZ	NUMC	4
SSOLHAB	Debit/credit indicator		VVSSOLHAB	CHAR	2
SBERFIMA	Calculation category for cash flow calculator		SBEWFIMA	CHAR	8	*
SSTCKKZ	Accrued interest method		SSTCKKZ	CHAR	2
SZBMETH	Interest Calculation Method		SZBMETH	CHAR	2
STGMETH	Daily Method		VVSTGMETH	NUMC	2
STGBASIS	Base Days Method		VVSTGBASIS	CHAR	2
ABASTAGE	Number of base days in a calculation period		ABASTAGE	NUMC	12
PKOND	Percentage rate for condition items		PKOND	DEC	6
DPKOND	Fixing Date of Percentage Rate from Condition		VVDPKOND	DATS	16
SBASIS	Calculation Base Indicator		SBASIS	CHAR	8	*
JSOFVERR	Immediate settlement		JSOFVERR	CHAR	2
DVALUT	Calculation Date		DVALUT	DATS	16
SINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
SVULT	Month-End Indicator for Value Date		VVSVULT	CHAR	2
DBERVON	Start of Calculation Period		DBERVON	DATS	16
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period		VVSEXCLVON	NUMC	2
SULTVON	Month-End Indicator for Start of a Calculation Period		VVSULTVON	CHAR	2
DBERBIS	End of Calculation Period		DBERBIS	DATS	16
SINCLBIS	Inclusive Indicator for the End of a Calculation Period		VVSINCLBIS	NUMC	2
SULTBIS	Month-End Indicator for the End of a Calculation Period		VVSULTBIS	CHAR	2
ATAGE	Number of Days		VVATAGE	NUMC	12
DFAELL	Due date		DFAELL	DATS	16
DDISPO	Payment Date		DDISPO	DATS	16
DEPERIOD	Period End		VVDEPERIOD	DATS	16
SPEINCL	Inclusive Indicator for End Date of a Period		TFMSPEINCL	NUMC	2
SPEULT	Month-End Indicator for End of a Period		TFMSPEULT	CHAR	2
DVERRECH	Settlement date		VVDVERRECH	DATS	16
SINCLVERR	Inclusive Indicator for Clearing Date		VVSINCLVER	NUMC	2
SULTVERR	Month-End Indicator for Clearing Date		VVSULTVERR	CHAR	2
DBUDAT	Posting Date in the Document		BUDAT	DATS	16
SNWHR	Currency of nominal amount		SNWHR	CUKY	10	*
BNWHR	Nominal amount		BNWHR	CURR	7
SBWHR	Position Currency (Currency of Position Amount)		SBWHR	CUKY	10	*
BBWHR	Amount in position currency		BBWHR	CURR	7
SCWHR	Settlement Currency		SCWHR	CUKY	10	*
BCWHR	Settlement Amount		BCWHR	CURR	7
BHWHR	Amount in local currency		BHWHR	CURR	7
BBASIS	Calculation Base Amount		BBASIS	CURR	7
PEFFZINS	Effective Interest Rate		PEFFZINS	DEC	6
SEFFMETH	Effective Interest Method (Financial Mathematics)		SEFFMETH	NUMC	2
DBPERIOD	Period start		VVDBPERIOD	DATS	16
SGTXT	Item Text		SGTXT	CHAR	100
KOSTL	Cost Center		KOSTL	CHAR	20
KUNNR	Customer Number		KUNNR	CHAR	20
BVTYP	Partner bank type		BVTYP	CHAR	8
MABER	Dunning Area		MABER	CHAR	4
RPARTNR	Business Partner Number		BP_PARTNR_NEW	CHAR	20
SZEGEN	Generate Incoming Payment Immediately		SZEGEN	NUMC	4
HDN_KUNNR	Main Borrower Customer Number		HDN_KUNNR	CHAR	20
SZART	Payment Transaction		TB_SZART	CHAR	2
JONLAEN	Indicator for fixing a flow record		JONLAEN	CHAR	2
VORGTYP	Activity Category (Posting Area)		VORGTYP_LO	CHAR	8
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)		REBZJ	NUMC	8
REBZG	Document No. of the Invoice to Which the Transaction Belongs		REBZG	CHAR	20
REBZZ	Line Item in the Relevant Invoice		REBZZ	NUMC	6
DFAELL_OLD_EXT	Old Due Date		TB_EXTENS_DFAELL_OLD	DATS	16
DDISPO_OLD_EXT	Old Payment Date		TB_EXTENS_DDISPO_OLD	DATS	16
RBO_EXT	Business Operation Number (Loans)		RBO	CHAR	30
MANSP	Dunning Block		MANSP	CHAR	2
.INCLUDE				RSEPA_INFO	0
REMIT_INFO	Payment Notes Info		TB_REMIT_INFO	CHAR	280
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
.INCLUDE				FVD_FIMA_FIELDS_FLOWS	0
AAVGDAYS	No. of Days for Interest Calc. with Average Interest Rate		TFM_AAVGDAYS	INT4	4
PAVGINTEREST	Average Interest Rate		TFM_PAVGINTEREST	DEC	8
JAVGCAP	Use Upper Limit of Average Interest Rate		TFM_JAVGCAP	CHAR	2
PAVGCAP	Upper Limit of Average Interest Rate		TFM_PAVGCAP	DEC	8
JAVGFLOOR	Use Lower Limit of Average Interest Rate		TFM_JAVGFLOOR	CHAR	2
PAVGFLOOR	Lower Limit of Average Interest Rate		TFM_PAVGFLOOR	DEC	8
PAVGSPREAD	Average Interest Rate Spread		TFM_PAVGSPREAD	DEC	8
SROUNDAVGINTEREST	Rounding Category of Average Interest Rate		TFM_SROUNDAVGINTEREST	CHAR	2
ROUNDDECAVGINTEREST	Number of Rounding Decimal Places for Average Interest Rate		TFM_ROUNDDECAVGINTEREST	INT1	1
AAVGWEIGHT	Weighting of Interest Rate		TFM_AWEIGHT	INT4	4
AAVGWEIGHTSUM	Cumulative Weighting of Interest Rate		TFM_AWEIGHTSUM	INT4	4
JEXPOINTFACTOR	Exponential Interest Calculation with Factor		TFM_JEXPOINTFACTOR	CHAR	2
FLOWFACTOR	Flow Factor		TFM_FLOWFACTOR	D34R	16
BASEFACTOR	Base Factor		TFM_BASEFACTOR	D34R	16
SFACTORRESET	Event for Resetting Factor Calculation		TFM_SFACTORRESET	CHAR	2