SAP ABAP Table VTVBARW_DL (Operative Loans: For a Given Date)

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	VTVBARW_DL	Table Relationship Diagram
Short Description	Operative Loans: For a Given Date

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	Treasury: Non-Cumulative Values Loans: Charact. Trans./Act.
2	.INCLUDE	☐				0	0	Fixed characteristics in Treasury
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
6	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
7	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
8	SARCHIV	☐	SARCHIV	SARCHIV	CHAR	1	0	Archiving Category Indicator
9	RANLVD	☐	RANLD	RANL	CHAR	13	0	Loan number	VDARL
10	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
11	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
12	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
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	TD03A
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	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
28	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
29	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
30	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
31	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
32	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
33	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
34	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	TDMAHNS_MAN
35	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
36	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
37	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
38	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	TD10
39	SB_VERTRAG	☐	SB_VERTRAG_NEW	BU_PARTNER	CHAR	10	0	Contract clerk	BUT000
40	SB_BUCHH	☐	SB_BUCHH_NEW	BU_PARTNER	CHAR	10	0	Accounting clerks	BUT000
41	SB_PROLO	☐	SB_PROLO_NEW	BU_PARTNER	CHAR	10	0	Rollover clerk	BUT000
42	SFIWO	☐	SFIWO	SFIWO	CHAR	2	0	Indicator: Type of Residential Object Financing	TD15
43	SOBJART	☐	SOBJART	SOBJART	NUMC	2	0	Object type	TIV5A
44	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
45	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
46	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	TDDG1
47	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	TDDG2
48	SGRP3	☐	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	TDDG3
49	SGRP4	☐	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	TDDG4
50	SAKTPAS	☐	VVSAKTPAS	VVSAKTPAS	CHAR	1	0	Indicator: Asset/Liability Transaction
51	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
52	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
53	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
54	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
55	SNUTZART	☐	VVSNUTZ	SNUNR	NUMC	4	0	Main usage type of object	TIV01
56	SREPAYMENT	☐	SREPAYMENT	SREPAYMENT	CHAR	1	0	Repayment Status of Loan on Key Date
57	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	TW08
58	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	TD18
59	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
60	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
61	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
62	LC_CAPITALS	☐	TB_LC_CHARAC_CAPITALS	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Capital Amounts	*
63	LC_DISBURSEMENT	☐	TB_LC_CHARAC_DISBURSEMENT	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Disbursement Status	*
64	.INCLUDE	☐				0	0	Treasury: Commitment Partner
65	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
66	.INCLUDE	☐				0	0	Treasury: Partner Attributes
67	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
68	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
69	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
70	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
71	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
72	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
73	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
74	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
75	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
76	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
77	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
78	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
79	.INCLUDE	☐				0	0	Business partner credit standing data
80	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
81	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
82	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
83	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
84	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
85	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
86	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
87	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
88	PEFFZINS	☐	FTI_PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate on Key Date
89	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
90	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
91	CALC_CCY	☐	AFW_EVAL_CURRENCY	WAERS	CUKY	5	0	Evaluation Currency	TCURC
92	RLZTG	☐	FTI_RLZTG	NUMC5	NUMC	5	0	Remaining Term in Days
93	RLZMO	☐	FTI_RLZMO	NUMC4	NUMC	4	0	Remaining Term in Months
94	RLZJA	☐	FTI_RLZJA	NUMC3	NUMC	3	0	Remaining Term in Years
95	UEBTG	☐	FTI_UEBTG	NUMC5	NUMC	5	0	Overdue Period in Days
96	UEBMO	☐	FTI_UEBMO	NUMC3	NUMC	3	0	Overdue Period in Months
97	UEBJA	☐	FTI_UEBJA	NUMC2	NUMC	2	0	Overdue Period in Years
98	MNOMZINS	☐	FTI_MNOMZINS	FTI_NUMC3	NUMC	3	0	Nominal Interest (Drilldown Reporting Characteristic)
99	BANTRAG	☐	TB_BANTRAG_A	BWHR	CURR	13	2	Asset: Application capital in position currency
100	BANTRAG_P	☐	TB_BANTRAG_P	BWHR	CURR	13	2	Liability: Application capital in position currency
101	BZUSAGE	☐	TB_BZKWR_A	WERTV8	CURR	15	2	Asset: Current commitment capital in position currency
102	BZUSAGE_P	☐	TB_BZKWR_P	WERTV8	CURR	15	2	Liability: Current commitment capital in position currency
103	BNBUERG	☐	TB_BNBUERG	WERTV7	CURR	13	2	Initial capital not guaranteed in position currency
104	NOMZINS	☐	TB_NOMINAL_INTEREST	DECV3_7	DEC	10	7	Nominal Interest Rate
105	BRPWR	☐	TB_BRPWR_A	WERTV8_TR	CURR	15	2	Asset: Remaining capital acc.to debit pos. in position curr.
106	BRPWR_P	☐	TB_BRPWR_P	WERTV8_TR	CURR	15	2	Liab.: Remaining capital acc.to debit pos. in position curr.
107	BRPHW	☐	TB_BRPHW_A	WERTV8_TR	CURR	15	2	Asset: Remaining capital acc.to debit pos. in local currency
108	BRPHW_P	☐	TB_BRPHW_P	WERTV8_TR	CURR	15	2	Liab.: Remaining capital acc.to debit pos. in local currency
109	BRIWR	☐	TB_BRIWR_A	WERTV8_TR	CURR	15	2	Asset: Effective capital (rem.cap. acc.to IP) in pos. curr.
110	BRIWR_P	☐	TB_BRIWR_P	WERTV8_TR	CURR	15	2	Liab.: Effective capital (rem.cap. acc.to IP) in pos. curr.
111	BRIHW	☐	TB_BRIHW_A	WERTV8_TR	CURR	15	2	Asset: Effective capital (rem.cap. acc.to IP) in local curr.
112	BRIHW_P	☐	TB_BRIHW_P	WERTV8_TR	CURR	15	2	Liab.: Effective capital (rem.cap. acc.to IP) in local curr.
113	BVAWR	☐	TB_BVAWR_A	WERTV8_TR	CURR	15	2	Asset: Value-dated capital in position currency
114	BVAWR_P	☐	TB_BVAWR_P	WERTV8_TR	CURR	15	2	Liability: Value-dated capital in position currency
115	BAVWR	☐	TB_BAVWR_A	WERTV8_TR	CURR	15	2	Asset: Disbursement obligation in position currency
116	BAVWR_P	☐	TB_BAVWR_P	WERTV8_TR	CURR	15	2	Liability: Disbursement obligation in position currency
117	BVKWR	☐	TB_BVKWR_A	WERTV8_TR	CURR	15	2	Asset: Contract capital in position currency
118	BVKWR_P	☐	TB_BVKWR_P	WERTV8_TR	CURR	15	2	Liability: Contract capital in position currency
119	TILGUNG	☐	TB_BTILGUNG_A	WERTV8_TR	CURR	15	2	Repayments in Arrears (Assets)
120	TILGUNG_P	☐	TB_BTILGUNG_P	WERTV8_TR	CURR	15	2	Repayments in Arrears (Liability)
121	ZINSEN	☐	TB_BZINS_A	WERTV8_TR	CURR	15	2	Interest Payments in Arrears (Asset)
122	ZINSEN_P	☐	TB_BZINS_P	WERTV8_TR	CURR	15	2	Interest Payments in Arrears (Liability)
123	UEBERZ	☐	VVUEBERZ	WERTV8_TR	CURR	15	2	Total overpayments for contract
124	VERSCH	☐	VVVERSCH	WERTV8_TR	CURR	15	2	Total Remaining Postings Outstanding
125	BRPNWR	☐	TB_BRPNWR_A	WERTV8_TR	CURR	15	2	Asset: Nominal remaining capital in position currency
126	BRPNWR_P	☐	TB_BRPNWR_P	WERTV8_TR	CURR	15	2	Liability: Nominal remaining capital in position currency
127	BRINWR	☐	TB_BRINWR_A	WERTV8_TR	CURR	15	2	Asset: Nominal effective capital in position currency
128	BRINWR_P	☐	TB_BRINWR_P	WERTV8_TR	CURR	15	2	Liability: Nominal effective capital in position currency
129	BBUCHWR_A	☐	TB_BBUCHWR_A	WERTV8_TR	CURR	15	2	Asset: Book value in position currency
130	BBUCHWR_P	☐	TB_BBUCHWR_P	WERTV8_TR	CURR	15	2	Liability: Book value in position currency
131	BBUCHHW_A	☐	TB_BBUCHHW_A	WERTV8_TR	CURR	15	2	Asset: Book value in local currency
132	BBUCHHW_P	☐	TB_BBUCHHW_P	WERTV8_TR	CURR	15	2	Liability: Book value in local currency
133	BNOMWR_A	☐	TB_BNOMWR_A	WERTV8_TR	CURR	15	2	Asset: Nominal value in position currency
134	BNOMWR_P	☐	TB_BNOMWR_P	WERTV8_TR	CURR	15	2	Liability: Nominal value in position currency
135	BKAUFWR_A	☐	TB_BKAUFWR_A	WERTV8_TR	CURR	15	2	Asset: Acquisition value in position currency
136	BKAUFWR_P	☐	TB_BKAUFWR_P	WERTV8_TR	CURR	15	2	Liability: Acquisition value in position currency
137	BKAUFHW_A	☐	TB_BKAUFHW_A	WERTV8_TR	CURR	15	2	Asset: Acquisition value in local currency
138	BKAUFHW_P	☐	TB_BKAUFHW_P	WERTV8_TR	CURR	15	2	Liability: Acquisition value in local currency
139	BVZWR	☐	TB_BVZWR_A	WERTV8_TR	CURR	15	2	Asset: Current Contract Capital in Position Currency
140	BVZWR_P	☐	TB_BVZWR_P	WERTV8_TR	CURR	15	2	Liability: Current Contract Capital in Position Currency
141	BKKWR	☐	TB_BKKWR_A	WERTV8	CURR	15	2	Asset: Commitment capital in position currency
142	BKKWR_P	☐	TB_BKKWR_P	WERTV8	CURR	15	2	Liability: Commitment capital in position currency
143	BZINSANWR	☐	BZINSANWR_A	WERTV8_TR	CURR	15	2	Asset: Accrued interest claim in position currency
144	BZINSANWR_P	☐	BZINSANWR_P	WERTV8_TR	CURR	15	2	Liability: Accrued interest claim in position currency
145	BZINSANHW	☐	BZINSANHW_A	WERTV8_TR	CURR	15	2	Asset: Accrued interest claim in local currency
146	BZINSANHW_P	☐	BZINSANHW_P	WERTV8_TR	CURR	15	2	Liability: Accrued interest claim in local currency
147	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
148	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
149	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
150	NPV_CC	☐	TV_NPV_CC	WERTV8_TR	CURR	15	2	RM NPV in Evaluation Currency
151	CLEAN_PRICE_CC	☐	FTI_CLEAN_PRICE_CC	T_PRESVAL	CURR	17	2	Clean Price in Valuation Currency
152	BPVALUE_CC	☐	TV_VALBP	T_PRESVAL	CURR	17	2	Basis Point Value in Evaluation Currency
153	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
154	MOD_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
155	CONVEXITY	☐	TV_CONVEXITY_MORE_ACCURATE	DEC6_5SIGN	DEC	11	5	Convexity with 5 Decimal Places
156	BANTRAG_AW	☐	FTI_BANTRA	WERTV7	CURR	13	2	Asset: Application capital in display currency
157	BANTRAG_P_AW	☐	FTI_BANTR_P_A	WERTV7	CURR	13	2	Liability: Application capital in display currency
158	BZUSAGE_AW	☐	FTI_BZKWR_A_AW	WERTV8	CURR	15	2	Asset: Current commitment capital in display currency
159	BZUSAGE_P_AW	☐	FTI_BZKWR_P_AW	WERTV8	CURR	15	2	Liability: Current commitment capital in display currency
160	BNBUERG_AW	☐	FTI_VVBNBU	WERTV7	CURR	13	2	Capital not guaranteed at start in display currency
161	BRPWR_AW	☐	FTI_VVBRPW	WERTV8	CURR	15	2	Asset: Remaining capital acc. to debit pos. in displ. curr.
162	BRPWR_P_AW	☐	FTI_VVBRPW_P	WERTV8	CURR	15	2	Liability: Remaining cap. acc. to debit pos. in displ. curr.
163	BRPHW_AW	☐	FTI_BRPHW_A_AW	WERTV8_TR	CURR	15	2	Asset: Remaining capital acc. to debit pos. in displ. curr.
164	BRPHW_P_AW	☐	FTI_BRPHW_P_AW	WERTV8_TR	CURR	15	2	Liability: Remaining cap. acc. to debit pos. in displ. curr.
165	BRIWR_AW	☐	FTI_BRIWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Effective cap. (rem.cap.acc.to IP) in display curr.
166	BRIWR_P_AW	☐	FTI_BRIWR_P_AW	WERTV8_TR	CURR	15	2	Liability: Effective cap.(rem.cap.acc.to IP) in disp. curr.
167	BRIHW_AW	☐	FTI_BRIHW_A_AW	WERTV8_TR	CURR	15	2	Asset: Effective capital (rem.cap.acc.to IP) in DC from LC
168	BRIHW_P_AW	☐	FTI_BRIHW_P_AW	WERTV8_TR	CURR	15	2	Liability: Effective cap. (rem.cap.acc.to IP) in DC from LC
169	BVAWR_AW	☐	FTI_VVBVAW	WERTV8	CURR	15	2	Asset: Value-dated capital in display currency
170	BVAWR_P_AW	☐	FTI_VVBVAW_P	WERTV8	CURR	15	2	Liability: Value-dated capital in display currency
171	BAVWR_AW	☐	FTI_BAVWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Disbursement obligation in display currency
172	BAVWR_P_AW	☐	FTI_BAVWR_P_AW	WERTV8_TR	CURR	15	2	Liability: Disbursement obligation in display currency
173	BVKWR_AW	☐	FTI_VVBVKW	WERTV8	CURR	15	2	Asset: Contract capital in display currency
174	BVKWR_P_AW	☐	FTI_VVBVKW_P	WERTV8	CURR	15	2	Liablility: Contract capital in display currency
175	TILGUNG_AW	☐	FTI_TILGAW	WERTV8	CURR	15	2	Asset: Total of All Open Repayments in DC
176	TILGUNG_P_AW	☐	FTI_TILG_P_AW	WERTV8	CURR	15	2	Liability: Total of Open Repayments in Display Currency
177	ZINSEN_AW	☐	FTI_ZINSAW	WERTV8	CURR	15	2	Asset: Total of Open Repayments in Display Currency
178	ZINSEN_P_AW	☐	FTI_ZINS_P_AW	WERTV8	CURR	15	2	Liability: Total Open Interest Payments in Display Currency
179	UEBERZ_AW	☐	FTI_UEBEAW	WERTV8	CURR	15	2	Total overpayments for contract in display currency
180	VERSCH_AW	☐	FTI_VERSAW	WERTV8	CURR	15	2	Total remaining postings for contract in display currency
181	BRPNWR_AW	☐	FTI_BRPNWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Nominal remaining capital in disp.curr.from pos.curr.
182	BRPNWR_P_AW	☐	FTI_BRPNWR_P_AW	WERTV8_TR	CURR	15	2	Liabilities: Nominal remain.cap.in disp.curr.from pos.curr.
183	BRINWR_AW	☐	FTI_BRINWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Nominal effective capital in display currency
184	BRINWR_P_AW	☐	FTI_BRINWR_P_AW	WERTV8_TR	CURR	15	2	Liability: Nominal effective capital in display currency
185	BBUCHWR_A_AW	☐	FTI_BBUCHWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency
186	BBUCHWR_P_AW	☐	FTI_BBUCHWR_P_AW	WERTV8_TR	CURR	15	2	Liability: Book value in display currency
187	BBUCHHW_A_AW	☐	FTI_BBUCHHW_A_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency from local currency
188	BBUCHHW_P_AW	☐	FTI_BBUCHHW_P_AW	WERTV8_TR	CURR	15	2	Liability: Book value in display currency from local curr.
189	BNOMWR_A_AW	☐	FTI_BNOMWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Nominal value in display currency
190	BNOMWR_P_AW	☐	FTI_BNOMWR_P_AW	WERTV8_TR	CURR	15	2	Liability: Nominal value in display currency
191	BKAUFWR_A_AW	☐	FTI_BKAUFWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Acquisition value in display curr. from pos. currency
192	BKAUFWR_P_AW	☐	FTI_BKAUFWR_P_AW	WERTV8_TR	CURR	15	2	Liability: Acquisition value in display curr. from pos.curr.
193	BKAUFHW_A_AW	☐	FTI_BKAUFHW_A_AW	WERTV8_TR	CURR	15	2	Asset: Acquisition value in display curr. from local curr.
194	BKAUFHW_P_AW	☐	FTI_BKAUFHW_P_AW	WERTV8_TR	CURR	15	2	Liability: Acquisition value in displ.curr. from local curr.
195	BVZWR_AW	☐	FTI_BVZWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Current contract capital in display currency
196	BVZWR_P_AW	☐	FTI_BVZWR_P_AW	WERTV8_TR	CURR	15	2	Liability: Current contract capital in display currency
197	BKKWR_AW	☐	FTI_BKKWR_A_AW	WERTV8	CURR	15	2	Asset: Commitment capital in display currency
198	BKKWR_P_AW	☐	FTI_BKKWR_P_AW	WERTV8	CURR	15	2	Liability: Commitment capital in display currency
199	BZINSANWR_AW	☐	FTI_BZINSANWR_A_AW	WERTV8_TR	CURR	15	2	Asset: Accrued interest claim in display currency
200	BZINSANWR_P_AW	☐	FTI_BZINSANWR_P_AW	WERTV8_TR	CURR	15	2	Liability: Accrued interest claim in display currency
201	BZINSANHW_AW	☐	FTI_BZINSANHW_A_AW	WERTV8_TR	CURR	15	2	Asset: Accrued interest claim in disp.curr. from local curr.
202	BZINSANHW_P_AW	☐	FTI_BZINSANHW_P_AW	WERTV8_TR	CURR	15	2	Liability: Accrued int. claim in disp.curr. from local curr.
203	NPV_PC_AW	☐	FTI_NPV_PC		CURR	23	2	RM NPV in Display Currency
204	CLEAN_PRICE_PC_AW	☐	FTI_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
205	BPVALUE_PC_AW	☐	FTI_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Display Currency
206	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
207	RLZTG_K	☐	FTI_RLZTGK	DEC7	DEC	7	0	Remaining Term in Days (Key Figure)
208	UEBTG_K	☐	FTI_UEBTGK	DEC7	DEC	7	0	Overdue Period in Days (Key Figure)
209	STUECKE	☐	FTI_STUECKE	ASTUECK	DEC	15	5	Number of units / Number of transactions
210	.INCLUDE	☐				0	0	Additional Treasury Selections
211	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	T242Q
212	NUMBR_LC	☐	FTI_NUMBR_LC	CFNUMBR	NUMC	3	0	Translation Type for Currency Translation into Local Crcy	T242Q
213	KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	TW56
214	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
215	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	TWX1
216	CASHF	☐	SCASHFLOW	XFELD	CHAR	1	0	Indicator for cash flow calculation up to end of term
217	BILST	☐	FTI_BILST	DATUM	DATS	8	0	Reference Date
218	BILST2	☐	FTI_BILST2	DATUM	DATS	8	0	Reference Date
219	BILST_REF_B	☐	FTI_BILST_REF_B	FTI_BILST_REF_B	CHAR	1	0	Positions: Remaining Term/Overdue Period Based On
220	BILST_REF_F	☐	FTI_BILST_REF_F	FTI_BILST_REF_F	CHAR	1	0	Flows: Remaining Term/Overdue Period Based On
221	STORNO	☐	FTI_STORNO	XFELD	CHAR	1	0	Evaluate Reversed Flows
222	AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	JBREVAL
223	FLG_SE	☐	FTI_LDB_FLG_SE	XFELD	CHAR	1	0	Product Group Securities: Yes/No
224	FLG_LO	☐	FTI_LDB_FLG_LO	XFELD	CHAR	1	0	Product Group Loans: Yes/No
225	FLG_OTC	☐	FTI_LDB_FLG_OTC	XFELD	CHAR	1	0	Product Group OTC (MM, FX, DE): Yes/No
226	FLG_LOF	☐	FTI_LDB_FLG_LOF	XFELD	CHAR	1	0	Product Group Listed Derivatives (Futures): Yes/No
227	FLG_COUPLING_SECACCGRP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
228	FLG_HISTORIC_ACCASSREF	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
229	FLG_CONDENSE	☐	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
230	FLG_NO_NULL	☐	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
231	FLG_EXCLUDING_PLAN	☐	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
232	FLG_REVERSED_FLOWS	☐	FTI_REVERSED_FLOWS	XFELD	CHAR	1	0	Process Reversed Flows (for Query)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVBARW_DL	ANZGW	TCURC	WAERS
2	VTVBARW_DL	AUSWT	JBREVAL	AUSWERTUNG
3	VTVBARW_DL	BUKRS	T001	BUKRS		C	CN
4	VTVBARW_DL	CALC_CCY	TCURC	WAERS
5	VTVBARW_DL	CNTRY_COMP	T005	LAND1
6	VTVBARW_DL	GROUP_D	TP13	GROUP_D
7	VTVBARW_DL	GROUP_ID	TB001	BU_GROUP
8	VTVBARW_DL	GSART	TZPA	GSART
9	VTVBARW_DL	GSBER	TGSB	GSBER
10	VTVBARW_DL	HKONT	SKB1	SAKNR
11	VTVBARW_DL	IND_SECTOR	TB038A	IND_SECTOR
12	VTVBARW_DL	ISTYPE	TB038	ISTYPE
13	VTVBARW_DL	KURSA	TW56	SKURSART
14	VTVBARW_DL	LAND1	T005	LAND1
15	VTVBARW_DL	LEGAL_ENTY	TB019	LEGAL_ENTY
16	VTVBARW_DL	LEGAL_ORG	TB032	LEGAL_ORG
17	VTVBARW_DL	MABER	T047M	MABER
18	VTVBARW_DL	MANDT	T000	MANDT		C	CN
19	VTVBARW_DL	NATION	T005	LAND1
20	VTVBARW_DL	NUMBR	T242Q	NUMBR
21	VTVBARW_DL	NUMBR_LC	T242Q	NUMBR
22	VTVBARW_DL	PARTNR	BUT000	PARTNER
23	VTVBARW_DL	PERIV	T009	PERIV
24	VTVBARW_DL	RANLVD	VDARL	RANL
25	VTVBARW_DL	RATING	TP06	RATING
26	VTVBARW_DL	RPORTB	TWPOB	RPORTB		1	CN
27	VTVBARW_DL	RREFKONT	T037S	RREFKONT
28	VTVBARW_DL	SANLF	TZAF	SANLF
29	VTVBARW_DL	SBILK	TW11	SBILK		C	CN
30	VTVBARW_DL	SBWHR	TCURC	WAERS
31	VTVBARW_DL	SB_BUCHH	BUT000	PARTNER		C	CN
32	VTVBARW_DL	SB_PROLO	BUT000	PARTNER		C	CN
33	VTVBARW_DL	SB_VERTRAG	BUT000	PARTNER		C	CN
34	VTVBARW_DL	SDTYP	TD02	SDTYP
35	VTVBARW_DL	SFIBG	TW08	SFIBG		C	CN
36	VTVBARW_DL	SFIWO	TD15	SFIWO
37	VTVBARW_DL	SFRIST	TD09	SFRIST
38	VTVBARW_DL	SGESST	TD17	SGESST
39	VTVBARW_DL	SGR1	TDDG1	SGRP1		C	CN
40	VTVBARW_DL	SGR2	TDDG2	SGRP2		C	CN
41	VTVBARW_DL	SGRP3	TDDG3	SGRP3		C	CN
42	VTVBARW_DL	SGRP4	TDDG4	SGRP4		C	CN
43	VTVBARW_DL	SMAHNM	TDMAHNS_MAN	SMAHNM
44	VTVBARW_DL	SNUTZART	TIV01	SNUNR		C	CN
45	VTVBARW_DL	SOBJART	TIV5A	SOBJART
46	VTVBARW_DL	SOL_INS	TP07	SOL_INS
47	VTVBARW_DL	SREGION	TD18	SREGION
48	VTVBARW_DL	SSICHER	TD01	SSICH
49	VTVBARW_DL	SSONDER	TD10	SSONDER
50	VTVBARW_DL	SSTATI	TZC37	STATU
51	VTVBARW_DL	STAFF_GRP	TP05	STAFF_GRP
52	VTVBARW_DL	STATE	T005	LAND1
53	VTVBARW_DL	STITEL	TD03A	STITEL
54	VTVBARW_DL	SVZWECK	TD07	SVZWECK
55	VTVBARW_DL	VVRANLWI	TWX1	VVRANLWI
56	VTVBARW_DL	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20131127
SAP Release Created in