SAP ABAP Table VDGLOBAL (Loans: Non-Cumulative/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	VDGLOBAL	Table Relationship Diagram
Short Description	Loans: Non-Cumulative/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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RANLVD	☐	RANL	RANL	CHAR	13	0	Contract Number
4	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
5	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
6	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
7	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
8	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
9	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
10	SHWHR	☐	SHWHR	WAERS	CUKY	5	0	Local currency	TCURC
11	RDARNEHM	☐	TB_RDARNEHM	BU_PARTNER	CHAR	10	0	Loan partner	BUT000
12	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
13	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
14	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
15	DBFSZ	☐	VVDBFSZ	DATUM	DATS	8	0	Date of start of fixed period
16	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
17	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
18	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
19	SDTYP	☐	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	TD02
20	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	TD03
21	SFRIST	☐	SFRIST	SFRIST	NUMC	2	0	Loan Term	TD09
22	SSICHER	☐	SSICHER	SSICH	CHAR	4	0	Primary collateral	TD01
23	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	TD07
24	DBEWI	☐	VVDBEWI	DATUM	DATS	8	0	Approval date
25	SBEA	☐	VVSBEA	VVSBEA	NUMC	2	0	Loan Processing Indicator
26	SSOLIST	☐	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
27	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
28	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
29	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
30	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
31	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
32	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	TDMAHNS_MAN
33	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
34	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
35	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
36	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	TD10
37	SB_VERTRAG	☐	SB_VERTRAG_NEW	BU_PARTNER	CHAR	10	0	Contract clerk	*
38	SB_BUCHH	☐	SB_BUCHH_NEW	BU_PARTNER	CHAR	10	0	Accounting clerks	*
39	SB_PROLO	☐	SB_PROLO_NEW	BU_PARTNER	CHAR	10	0	Rollover clerk	*
40	SFIWO	☐	SFIWO	SFIWO	CHAR	2	0	Indicator: Type of Residential Object Financing	TD15
41	SOBJART	☐	SOBJART	SOBJART	NUMC	2	0	Object type	TIV5A
42	SNUTZART	☐	VVSNUTZ	SNUNR	NUMC	4	0	Main usage type of object	TIV01
43	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
44	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
45	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	TDDG1
46	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	TDDG2
47	SGRP3	☐	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	TDDG3
48	SGRP4	☐	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	TDDG4
49	SAKTPAS	☐	VVSAKTPAS	VVSAKTPAS	CHAR	1	0	Indicator: Asset/Liability Transaction
50	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	TW08
51	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	TD18
52	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
53	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
54	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
55	LC_CAPITALS	☐	TB_LC_CHARAC_CAPITALS	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Capital Amounts	*
56	LC_DISBURSEMENT	☐	TB_LC_CHARAC_DISBURSEMENT	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Disbursement Status	*
57	GUARANTOR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
58	NAVAL	☐	VVNAVAL	CHAR15	CHAR	15	0	Guarantee number

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in