SAP ABAP Table VDFLOW (Loans: Cumulative Values)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	VDFLOW	Table Relationship Diagram
Short Description	Loans: Cumulative Values

Delivery and Maintenance

Pool/cluster
Delivery Class
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	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
2	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
3	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
4	.INCLUDE	☐				0	0	Loans: Non-Cumulative/Cumulative Values
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	RANLVD	☐	RANL	RANL	CHAR	13	0	Contract Number
8	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
9	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
10	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
11	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
12	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
13	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
14	SHWHR	☐	SHWHR	WAERS	CUKY	5	0	Local currency	TCURC
15	RDARNEHM	☐	TB_RDARNEHM	BU_PARTNER	CHAR	10	0	Loan partner	BUT000
16	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
17	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
18	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
19	DBFSZ	☐	VVDBFSZ	DATUM	DATS	8	0	Date of start of fixed period
20	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
21	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
22	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
23	SDTYP	☐	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	TD02
24	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	TD03
25	SFRIST	☐	SFRIST	SFRIST	NUMC	2	0	Loan Term	TD09
26	SSICHER	☐	SSICHER	SSICH	CHAR	4	0	Primary collateral	TD01
27	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	TD07
28	DBEWI	☐	VVDBEWI	DATUM	DATS	8	0	Approval date
29	SBEA	☐	VVSBEA	VVSBEA	NUMC	2	0	Loan Processing Indicator
30	SSOLIST	☐	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
31	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
32	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
33	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
34	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
35	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
36	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	TDMAHNS_MAN
37	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
38	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
39	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
40	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	TD10
41	SB_VERTRAG	☐	SB_VERTRAG_NEW	BU_PARTNER	CHAR	10	0	Contract clerk	*
42	SB_BUCHH	☐	SB_BUCHH_NEW	BU_PARTNER	CHAR	10	0	Accounting clerks	*
43	SB_PROLO	☐	SB_PROLO_NEW	BU_PARTNER	CHAR	10	0	Rollover clerk	*
44	SFIWO	☐	SFIWO	SFIWO	CHAR	2	0	Indicator: Type of Residential Object Financing	TD15
45	SOBJART	☐	SOBJART	SOBJART	NUMC	2	0	Object type	TIV5A
46	SNUTZART	☐	VVSNUTZ	SNUNR	NUMC	4	0	Main usage type of object	TIV01
47	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
48	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
49	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	TDDG1
50	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	TDDG2
51	SGRP3	☐	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	TDDG3
52	SGRP4	☐	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	TDDG4
53	SAKTPAS	☐	VVSAKTPAS	VVSAKTPAS	CHAR	1	0	Indicator: Asset/Liability Transaction
54	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	TW08
55	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	TD18
56	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
57	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
58	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
59	LC_CAPITALS	☐	TB_LC_CHARAC_CAPITALS	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Capital Amounts	*
60	LC_DISBURSEMENT	☐	TB_LC_CHARAC_DISBURSEMENT	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Disbursement Status	*
61	GUARANTOR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
62	NAVAL	☐	VVNAVAL	CHAR15	CHAR	15	0	Guarantee number
63	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
64	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
65	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
66	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
67	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
68	BUCHST_DL	☐	BUCHST_DL	BUCHST_DL	CHAR	1	0	Posting status of flow for loans
69	SVORGKZ	☐	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
70	SSTORNO	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
71	SSTOGRD	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	*
72	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	SKB1
73	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	SKB1
74	RVZBLG	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
75	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
76	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
77	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
78	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
79	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
80	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
81	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
82	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
83	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
84	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
85	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
86	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
87	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
88	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
89	BZBETR	☐	TB_BZWR_A	WERTV8	CURR	15	2	Payment Amount in Payment Currency
90	BHWBETR	☐	TB_BZHW_A	WERTV8	CURR	15	2	Payment amount in local currency
91	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
92	BBWHR	☐	TB_BBWR_A	WERTV8	CURR	15	2	Flow Amount in Position Currency
93	BHWHR	☐	TB_BBHW_A	WERTV8	CURR	15	2	Flow Amount in Local Currency
94	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
95	D_BNBW_A	☐	D_BNOMBW_A	WERTV8_TR	CURR	15	2	Asset: Change in nominal value in position currency
96	D_BNBW_P	☐	D_BNOMBW_P	WERTV8_TR	CURR	15	2	Liability: Change in nominal value in position currency
97	D_AWBW_A	☐	D_AWBW_A	WERTV8_TR	CURR	15	2	Change in acquisition value in position currency (asset)
98	D_AWHW_A	☐	D_AWHW_A	WERTV8_TR	CURR	15	2	Change in acquisition value in local currency (asset)
99	D_AWBW_P	☐	D_AWBW_P	WERTV8_TR	CURR	15	2	Change in acquisition value in position currency (liability)
100	D_AWHW_P	☐	D_AWHW_P	WERTV8_TR	CURR	15	2	Change in acquisition value in local currency (liability)
101	D_BWBW_A	☐	D_BWBW_A	WERTV8_TR	CURR	15	2	Change in book value in position currency (asset)
102	D_BWHW_A	☐	D_BWHW_A	WERTV8_TR	CURR	15	2	Change in book value in local currency (asset)
103	D_BWBW_P	☐	D_BWBW_P	WERTV8_TR	CURR	15	2	Change in book value in position currency (liability)
104	D_BWHW_P	☐	D_BWHW_P	WERTV8_TR	CURR	15	2	Change in book value in local currency (liability)
105	EEBETR	☐	EEBETR	WERTV7	CURR	13	2	Profit/loss amount in profit/loss currency
106	EHBETR	☐	EHBETR	WERTV7	CURR	13	2	Profit/loss amount in local currency
107	SPLWHR	☐	SPLWHR	WAERS	CUKY	5	0	Profit/loss currency	TCURC
108	PABGERFPL	☐	PABGERFPLW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in Profit/Loss Currency
109	PABGERFHW	☐	PABGERFHW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in Local Currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDFLOW	BUKRS	T001	BUKRS		C	CN
2	VDFLOW	GL_ACCOUNT_C	SKB1	SAKNR
3	VDFLOW	GL_ACCOUNT_D	SKB1	SAKNR
4	VDFLOW	GSART	TZPA	GSART
5	VDFLOW	GSBER	TGSB	GSBER
6	VDFLOW	LAND1	T005	LAND1
7	VDFLOW	MABER	T047M	MABER
8	VDFLOW	MANDT	T000	MANDT
9	VDFLOW	RDARNEHM	BUT000	PARTNER
10	VDFLOW	RPORTB	TWPOB	RPORTB
11	VDFLOW	RPZAHL	BUT000	PARTNER		1	CN
12	VDFLOW	RREFKONT	T037S	RREFKONT
13	VDFLOW	SANLF	TZAF	SANLF
14	VDFLOW	SBEWART	TZB0A	SBEWART		1	CN
15	VDFLOW	SBEWZITI	TZB03	SBEWZITI	KEY	1	CN
16	VDFLOW	SBILK	TW11	SBILK
17	VDFLOW	SBWHR	TCURC	WAERS		1	CN
18	VDFLOW	SDTYP	TD02	SDTYP
19	VDFLOW	SFIBG	TW08	SFIBG
20	VDFLOW	SFIWO	TD15	SFIWO
21	VDFLOW	SFRIST	TD09	SFRIST
22	VDFLOW	SGESST	TD17	SGESST
23	VDFLOW	SGLZB	TW07	SGLZB	KEY	1	1
24	VDFLOW	SGR1	TDDG1	SGRP1
25	VDFLOW	SGR2	TDDG2	SGRP2
26	VDFLOW	SGRP3	TDDG3	SGRP3
27	VDFLOW	SGRP4	TDDG4	SGRP4
28	VDFLOW	SHWHR	TCURC	WAERS
29	VDFLOW	SMAHNM	TDMAHNS_MAN	SMAHNM
30	VDFLOW	SNUTZART	TIV01	SNUNR
31	VDFLOW	SOBJART	TIV5A	SOBJART
32	VDFLOW	SPLWHR	TCURC	WAERS
33	VDFLOW	SREGION	TD18	SREGION	KEY
34	VDFLOW	SSICHER	TD01	SSICH
35	VDFLOW	SSONDER	TD10	SSONDER
36	VDFLOW	SSTATI	TZC37	STATU
37	VDFLOW	STITEL	TD03	STITEL	KEY	1	CN
38	VDFLOW	SVZWECK	TD07	SVZWECK
39	VDFLOW	WZBETR	TCURC	WAERS
40	VDFLOW	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20110901
SAP Release Created in