SAP ABAP Table VDCFWAREHOUSE (Cash Flow Management)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_REP (Package) Payoff

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDCFWAREHOUSE	Table Relationship Diagram
Short Description	Cash Flow Management

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	RBOKEY	☑	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
3	SCFTYP	☑	TB_SCFTYP	T_SCFTYP	CHAR	2	0	Cash Flow Category History
4	DTRANS	☑	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
5	TTRANS	☑	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
6	NTRANS	☑	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
8	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
9	RBO	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
10	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
11	.INCLUDE	☐				0	0	Include for Fields in Table TRDC_REC
12	SPLANIST	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
13	SREFBEW	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
14	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	*
15	SREFZITI	☐	VVSREFZITI	SBEWZITI	CHAR	4	0	Refer.flow category in accrual/deferral flow records	*
16	S_SSDREF	☐	VVS_SSDREF	SBEWZITI	CHAR	4	0	Reference flow category in borrower's note loan flow records	*
17	SREVALEXCL	☐	VVSREVALEXCL	XFELD	CHAR	1	0	Price gains w/o proportionate gains from deferral write-back
18	SWOHER	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
19	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
20	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
21	SVORGANG	☐	SVORFALL	SVORFALL	CHAR	4	0	Business Operation (Activity)
22	ACENV	☐	ACENV_LO	ACENV_LO	NUMC	4	0	Source in TR-LO posting area
23	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
24	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
25	SVORGKZ	☐	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
26	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
27	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*
28	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
29	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
30	STGMETH	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
31	STGBASIS	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
32	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
33	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
34	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
35	SBASIS	☐	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator	*
36	JSOFVERR	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
37	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
38	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
39	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
40	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
41	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
42	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
43	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
44	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
45	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
46	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
47	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
48	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
49	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
50	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
51	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
52	DVERRECH	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
53	SINCLVERR	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
54	SULTVERR	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
55	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
56	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	*
57	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
58	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
59	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
60	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	*
61	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
62	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
63	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
64	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
65	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
66	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
67	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
68	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
69	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
70	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
71	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
72	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
73	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
74	RPARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
75	SZEGEN	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	*
76	HDN_KUNNR	☐	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	*
77	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
78	JONLAEN	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
79	VORGTYP	☐	VORGTYP_LO	VORGTYP_LO	CHAR	4	0	Activity Category (Posting Area)
80	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
81	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
82	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
83	DFAELL_OLD_EXT	☐	TB_EXTENS_DFAELL_OLD	DATUM	DATS	8	0	Old Due Date
84	DDISPO_OLD_EXT	☐	TB_EXTENS_DDISPO_OLD	DATUM	DATS	8	0	Old Payment Date
85	RBO_EXT	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
86	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
87	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	*
88	.INCLUDE	☐				0	0	SEPA Remittance Information
89	REMIT_INFO	☐	TB_REMIT_INFO	T_REMIT_INFO	CHAR	140	0	SEPA Payment Notes Information
90	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient

History

Last changed by/on	SAP	20141121
SAP Release Created in