SAP ABAP Table VDSTATE (Loans: Non-Cumulative Values for Drilldown Reporting)

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	VDSTATE	Table Relationship Diagram
Short Description	Loans: Non-Cumulative Values for Drilldown Reporting

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	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
2	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
3	.INCLUDE	☐				0	0	Loans: Non-Cumulative/Cumulative Values
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	RANLVD	☐	RANL	RANL	CHAR	13	0	Contract Number
7	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
8	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
9	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
10	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
11	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
12	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
13	SHWHR	☐	SHWHR	WAERS	CUKY	5	0	Local currency	TCURC
14	RDARNEHM	☐	TB_RDARNEHM	BU_PARTNER	CHAR	10	0	Loan partner	BUT000
15	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
16	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
17	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
18	DBFSZ	☐	VVDBFSZ	DATUM	DATS	8	0	Date of start of fixed period
19	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
20	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
21	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
22	SDTYP	☐	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	TD02
23	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	TD03
24	SFRIST	☐	SFRIST	SFRIST	NUMC	2	0	Loan Term	TD09
25	SSICHER	☐	SSICHER	SSICH	CHAR	4	0	Primary collateral	TD01
26	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	TD07
27	DBEWI	☐	VVDBEWI	DATUM	DATS	8	0	Approval date
28	SBEA	☐	VVSBEA	VVSBEA	NUMC	2	0	Loan Processing Indicator
29	SSOLIST	☐	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
30	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
31	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
32	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
33	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
34	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
35	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	TDMAHNS_MAN
36	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
37	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
38	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
39	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	TD10
40	SB_VERTRAG	☐	SB_VERTRAG_NEW	BU_PARTNER	CHAR	10	0	Contract clerk	*
41	SB_BUCHH	☐	SB_BUCHH_NEW	BU_PARTNER	CHAR	10	0	Accounting clerks	*
42	SB_PROLO	☐	SB_PROLO_NEW	BU_PARTNER	CHAR	10	0	Rollover clerk	*
43	SFIWO	☐	SFIWO	SFIWO	CHAR	2	0	Indicator: Type of Residential Object Financing	TD15
44	SOBJART	☐	SOBJART	SOBJART	NUMC	2	0	Object type	TIV5A
45	SNUTZART	☐	VVSNUTZ	SNUNR	NUMC	4	0	Main usage type of object	TIV01
46	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
47	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
48	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	TDDG1
49	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	TDDG2
50	SGRP3	☐	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	TDDG3
51	SGRP4	☐	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	TDDG4
52	SAKTPAS	☐	VVSAKTPAS	VVSAKTPAS	CHAR	1	0	Indicator: Asset/Liability Transaction
53	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	TW08
54	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	TD18
55	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
56	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
57	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
58	LC_CAPITALS	☐	TB_LC_CHARAC_CAPITALS	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Capital Amounts	*
59	LC_DISBURSEMENT	☐	TB_LC_CHARAC_DISBURSEMENT	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Disbursement Status	*
60	GUARANTOR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
61	NAVAL	☐	VVNAVAL	CHAR15	CHAR	15	0	Guarantee number
62	NLFD_ANG	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
63	GPARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
64	ROLETYP	☐	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role	TB003
65	ROLE	☐	TB_ROLE_CORR	T_ROLE_CORR	CHAR	4	0	CML Correspondence Role Type of Recipient	TDPZ6
66	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
67	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
68	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
69	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
70	KZAHLUNG	☐	KZAHLUNG	DEC3_7	DEC	10	7	Pay-in/disbursement rate
71	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
72	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
73	SANTWHR	☐	SWHR	WAERS	CUKY	5	0	Currency	TCURC
74	SREPAYMENT	☐	SREPAYMENT	SREPAYMENT	CHAR	1	0	Repayment Status of Loan on Key Date
75	ZINSEN	☐	TB_BZINS_A	WERTV8_TR	CURR	15	2	Interest Payments in Arrears (Asset)
76	ZINSEN_P	☐	TB_BZINS_P	WERTV8_TR	CURR	15	2	Interest Payments in Arrears (Liability)
77	TILGUNG	☐	TB_BTILGUNG_A	WERTV8_TR	CURR	15	2	Repayments in Arrears (Assets)
78	TILGUNG_P	☐	TB_BTILGUNG_P	WERTV8_TR	CURR	15	2	Repayments in Arrears (Liability)
79	UEBERZ	☐	VVUEBERZ	WERTV8_TR	CURR	15	2	Total overpayments for contract
80	VERSCH	☐	VVVERSCH	WERTV8_TR	CURR	15	2	Total Remaining Postings Outstanding
81	BZINSANWR	☐	BZINSANWR_A	WERTV8_TR	CURR	15	2	Asset: Accrued interest claim in position currency
82	BZINSANHW	☐	BZINSANHW_A	WERTV8_TR	CURR	15	2	Asset: Accrued interest claim in local currency
83	BZINSANWR_P	☐	BZINSANWR_P	WERTV8_TR	CURR	15	2	Liability: Accrued interest claim in position currency
84	BZINSANHW_P	☐	BZINSANHW_P	WERTV8_TR	CURR	15	2	Liability: Accrued interest claim in local currency
85	BANTRAG	☐	TB_BANTRAG_A	BWHR	CURR	13	2	Asset: Application capital in position currency
86	BANTRAG_P	☐	TB_BANTRAG_P	BWHR	CURR	13	2	Liability: Application capital in position currency
87	BRPWR	☐	TB_BRPWR_A	WERTV8_TR	CURR	15	2	Asset: Remaining capital acc.to debit pos. in position curr.
88	BRPHW	☐	TB_BRPHW_A	WERTV8_TR	CURR	15	2	Asset: Remaining capital acc.to debit pos. in local currency
89	BRPWR_P	☐	TB_BRPWR_P	WERTV8_TR	CURR	15	2	Liab.: Remaining capital acc.to debit pos. in position curr.
90	BRPHW_P	☐	TB_BRPHW_P	WERTV8_TR	CURR	15	2	Liab.: Remaining capital acc.to debit pos. in local currency
91	BRPNWR	☐	TB_BRPNWR_A	WERTV8_TR	CURR	15	2	Asset: Nominal remaining capital in position currency
92	BRPNWR_P	☐	TB_BRPNWR_P	WERTV8_TR	CURR	15	2	Liability: Nominal remaining capital in position currency
93	BRIWR	☐	TB_BRIWR_A	WERTV8_TR	CURR	15	2	Asset: Effective capital (rem.cap. acc.to IP) in pos. curr.
94	BRIHW	☐	TB_BRIHW_A	WERTV8_TR	CURR	15	2	Asset: Effective capital (rem.cap. acc.to IP) in local curr.
95	BRIWR_P	☐	TB_BRIWR_P	WERTV8_TR	CURR	15	2	Liab.: Effective capital (rem.cap. acc.to IP) in pos. curr.
96	BRIHW_P	☐	TB_BRIHW_P	WERTV8_TR	CURR	15	2	Liab.: Effective capital (rem.cap. acc.to IP) in local curr.
97	BRINWR	☐	TB_BRINWR_A	WERTV8_TR	CURR	15	2	Asset: Nominal effective capital in position currency
98	BRINWR_P	☐	TB_BRINWR_P	WERTV8_TR	CURR	15	2	Liability: Nominal effective capital in position currency
99	BVAWR	☐	TB_BVAWR_A	WERTV8_TR	CURR	15	2	Asset: Value-dated capital in position currency
100	BVAWR_P	☐	TB_BVAWR_P	WERTV8_TR	CURR	15	2	Liability: Value-dated capital in position currency
101	BAVWR	☐	TB_BAVWR_A	WERTV8_TR	CURR	15	2	Asset: Disbursement obligation in position currency
102	BAVWR_P	☐	TB_BAVWR_P	WERTV8_TR	CURR	15	2	Liability: Disbursement obligation in position currency
103	BVKWR	☐	TB_BVKWR_A	WERTV8_TR	CURR	15	2	Asset: Contract capital in position currency
104	BVKWR_P	☐	TB_BVKWR_P	WERTV8_TR	CURR	15	2	Liability: Contract capital in position currency
105	BVZWR	☐	TB_BVZWR_A	WERTV8_TR	CURR	15	2	Asset: Current Contract Capital in Position Currency
106	BVZWR_P	☐	TB_BVZWR_P	WERTV8_TR	CURR	15	2	Liability: Current Contract Capital in Position Currency
107	BKKWR	☐	TB_BKKWR_A	WERTV8	CURR	15	2	Asset: Commitment capital in position currency
108	BKKWR_P	☐	TB_BKKWR_P	WERTV8	CURR	15	2	Liability: Commitment capital in position currency
109	BZUSAGE	☐	TB_BZKWR_A	WERTV8	CURR	15	2	Asset: Current commitment capital in position currency
110	BZUSAGE_P	☐	TB_BZKWR_P	WERTV8	CURR	15	2	Liability: Current commitment capital in position currency
111	BNBUERG	☐	TB_BNBUERG	WERTV7	CURR	13	2	Initial capital not guaranteed in position currency
112	BBUCHWR_A	☐	TB_BBUCHWR_A	WERTV8_TR	CURR	15	2	Asset: Book value in position currency
113	BBUCHHW_A	☐	TB_BBUCHHW_A	WERTV8_TR	CURR	15	2	Asset: Book value in local currency
114	BBUCHWR_P	☐	TB_BBUCHWR_P	WERTV8_TR	CURR	15	2	Liability: Book value in position currency
115	BBUCHHW_P	☐	TB_BBUCHHW_P	WERTV8_TR	CURR	15	2	Liability: Book value in local currency
116	BKAUFWR_A	☐	TB_BKAUFWR_A	WERTV8_TR	CURR	15	2	Asset: Acquisition value in position currency
117	BKAUFHW_A	☐	TB_BKAUFHW_A	WERTV8_TR	CURR	15	2	Asset: Acquisition value in local currency
118	BKAUFWR_P	☐	TB_BKAUFWR_P	WERTV8_TR	CURR	15	2	Liability: Acquisition value in position currency
119	BKAUFHW_P	☐	TB_BKAUFHW_P	WERTV8_TR	CURR	15	2	Liability: Acquisition value in local currency
120	BNOMWR_A	☐	TB_BNOMWR_A	WERTV8_TR	CURR	15	2	Asset: Nominal value in position currency
121	BNOMWR_P	☐	TB_BNOMWR_P	WERTV8_TR	CURR	15	2	Liability: Nominal value in position currency
122	NOMZINS	☐	TB_NOMINAL_INTEREST	DECV3_7	DEC	10	7	Nominal Interest Rate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDSTATE	BUKRS	T001	BUKRS		C	CN
2	VDSTATE	GPARTNR	BUT000	PARTNER
3	VDSTATE	GSART	TZPA	GSART
4	VDSTATE	GSBER	TGSB	GSBER
5	VDSTATE	MABER	T047M	MABER
6	VDSTATE	MANDT	T000	MANDT
7	VDSTATE	RDARNEHM	BUT000	PARTNER
8	VDSTATE	ROLE	TDPZ6	ROLE	KEY
9	VDSTATE	ROLETYP	TB003	ROLE
10	VDSTATE	RPORTB	TWPOB	RPORTB
11	VDSTATE	RREFKONT	T037S	RREFKONT	KEY	1	CN
12	VDSTATE	SANLF	TZAF	SANLF
13	VDSTATE	SANTWHR	TCURC	WAERS
14	VDSTATE	SBILK	TW11	SBILK
15	VDSTATE	SDTYP	TD02	SDTYP
16	VDSTATE	SFIBG	TW08	SFIBG
17	VDSTATE	SFIWO	TD15	SFIWO
18	VDSTATE	SFRIST	TD09	SFRIST
19	VDSTATE	SGESST	TD17	SGESST
20	VDSTATE	SGLZB	TW07	SGLZB	KEY	1	1
21	VDSTATE	SGR1	TDDG1	SGRP1
22	VDSTATE	SGR2	TDDG2	SGRP2
23	VDSTATE	SGRP3	TDDG3	SGRP3
24	VDSTATE	SGRP4	TDDG4	SGRP4
25	VDSTATE	SHWHR	TCURC	WAERS
26	VDSTATE	SMAHNM	TDMAHNS_MAN	SMAHNM
27	VDSTATE	SNUTZART	TIV01	SNUNR
28	VDSTATE	SOBJART	TIV5A	SOBJART
29	VDSTATE	SREGION	TD18	SREGION	KEY
30	VDSTATE	SSICHER	TD01	SSICH
31	VDSTATE	SSONDER	TD10	SSONDER
32	VDSTATE	SSTATI	TZC37	STATU
33	VDSTATE	STITEL	TD03	STITEL	KEY	1	CN
34	VDSTATE	SVZWECK	TD07	SVZWECK

History

Last changed by/on	SAP	20110901
SAP Release Created in