SAP ABAP Table VTVBARM_DL (Treasury: Non-Cumulative Values Loans: Charact. Trans./Act.)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI (Package) Application development R/3 Treasury information system

Basic Data

Table Category	INTTAB	Structure
Structure	VTVBARM_DL	Table Relationship Diagram
Short Description	Treasury: Non-Cumulative Values Loans: Charact. Trans./Act.

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	.INCLUDE	☐				0	0	Fixed characteristics in Treasury
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
5	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
6	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
7	SARCHIV	☐	SARCHIV	SARCHIV	CHAR	1	0	Archiving Category Indicator
8	RANLVD	☐	RANLD	RANL	CHAR	13	0	Loan number	VDARL
9	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
10	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
11	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
12	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
13	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
14	DBFSZ	☐	VVDBFSZ	DATUM	DATS	8	0	Date of start of fixed period
15	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
16	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
17	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
18	SDTYP	☐	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	TD02
19	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	TD03A
20	SFRIST	☐	SFRIST	SFRIST	NUMC	2	0	Loan Term	TD09
21	SSICHER	☐	SSICHER	SSICH	CHAR	4	0	Primary collateral	TD01
22	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	TD07
23	DBEWI	☐	VVDBEWI	DATUM	DATS	8	0	Approval date
24	SBEA	☐	VVSBEA	VVSBEA	NUMC	2	0	Loan Processing Indicator
25	SSOLIST	☐	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
26	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
27	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
28	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
29	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
30	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
31	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
32	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
33	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	TDMAHNS_MAN
34	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
35	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
36	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
37	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	TD10
38	SB_VERTRAG	☐	SB_VERTRAG_NEW	BU_PARTNER	CHAR	10	0	Contract clerk	BUT000
39	SB_BUCHH	☐	SB_BUCHH_NEW	BU_PARTNER	CHAR	10	0	Accounting clerks	BUT000
40	SB_PROLO	☐	SB_PROLO_NEW	BU_PARTNER	CHAR	10	0	Rollover clerk	BUT000
41	SFIWO	☐	SFIWO	SFIWO	CHAR	2	0	Indicator: Type of Residential Object Financing	TD15
42	SOBJART	☐	SOBJART	SOBJART	NUMC	2	0	Object type	TIV5A
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	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
51	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
52	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
53	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
54	SNUTZART	☐	VVSNUTZ	SNUNR	NUMC	4	0	Main usage type of object	TIV01
55	SREPAYMENT	☐	SREPAYMENT	SREPAYMENT	CHAR	1	0	Repayment Status of Loan on Key Date
56	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	TW08
57	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	TD18
58	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
59	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
60	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
61	LC_CAPITALS	☐	TB_LC_CHARAC_CAPITALS	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Capital Amounts	*
62	LC_DISBURSEMENT	☐	TB_LC_CHARAC_DISBURSEMENT	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Disbursement Status	*

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in