SAP ABAP Table VTVBARW_WP (Securities: 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_WP	Table Relationship Diagram
Short Description	Securities: 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 Sec.: 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	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
9	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
10	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
11	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
12	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
13	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
14	BUCHST_BSE	☐	BUCHST_BSE	BUCHST	CHAR	1	0	Posting status for position determination (securities)
15	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
16	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
17	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
18	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
19	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
20	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
21	LOTGENERATION_USER	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
22	LOTGENERATION_BUSTRANSCAT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	TRDTS_BT_CAT
23	.INCLUDE	☐				0	0	Treasury: Commitment Partner
24	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
25	.INCLUDE	☐				0	0	Treasury: Partner Attributes
26	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
27	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
28	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
29	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
30	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
31	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
32	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
33	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
34	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
35	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
36	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
37	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
38	.INCLUDE	☐				0	0	Business partner credit standing data
39	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
40	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
41	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
42	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
43	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
44	.INCLUDE	☐				0	0	TR: Class Information for Drilldown Reporting (Position)
45	.INCLUDE	☐				0	0	Treasury: Class info for drill-down reporting
46	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
47	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	TW20
48	SWPKLASS	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	TW01
49	ALWPKL	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	TW22
50	SARTBET	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	TW02
51	SAKAR	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
52	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
53	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
54	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
55	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
56	SFOTY	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	TW21
57	SOL_INS_RANL	☐	FTI_SOL_INS_RANL	BP_SOL_INS	CHAR	4	0	Institut Supplying Credit Rating Information for Secur. ID	TP07
58	RATING_RANL	☐	BP_RATING_RANL	BP_RATING	CHAR	3	0	Rating for Securities ID Number/OTC Transaction	TP06
59	KBNEWE	☐	VVBNEWE	VVKWKURS	DEC	15	6	Nominal Value per Stock (Independent of Currency)
60	KZAHLAKT	☐	KZAHLAKT	DEC3_7	DEC	10	7	Pay-in rate
61	.INCLUDE	☐				0	0	Treasury: Class info for drilldown reporting (only positns)
62	AAAAKTIE	☐	FTI_AAAKTIE	DEC12	DEC	12	0	Number of stocks issued
63	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
64	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
65	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
66	RLZTG	☐	FTI_RLZTG	NUMC5	NUMC	5	0	Remaining Term in Days
67	RLZMO	☐	FTI_RLZMO	NUMC4	NUMC	4	0	Remaining Term in Months
68	RLZJA	☐	FTI_RLZJA	NUMC3	NUMC	3	0	Remaining Term in Years
69	UEBTG	☐	FTI_UEBTG	NUMC5	NUMC	5	0	Overdue Period in Days
70	UEBMO	☐	FTI_UEBMO	NUMC3	NUMC	3	0	Overdue Period in Months
71	UEBJA	☐	FTI_UEBJA	NUMC2	NUMC	2	0	Overdue Period in Years
72	MPKOND	☐	MPKOND	FTI_NUMC3	NUMC	3	0	Interest rate (characteristic in drill-down reporting)
73	PKOND	☐	TV_PKOND	DECV3_7	DEC	10	7	Interest rate
74	PEFFZINS	☐	FTI_PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate on Key Date
75	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
76	VVRANLWX	☐	VVRANLWXS	CHAR20S	CHAR	20	0	Secondary index class data
77	RDPBANK	☐	RDEPOTBANK	BU_PARTNER	CHAR	10	0	Depository Bank	BUT000
78	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
79	CALC_CCY	☐	AFW_EVAL_CURRENCY	WAERS	CUKY	5	0	Evaluation Currency	TCURC
80	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
81	ASTUECK_SP	☐	ASTUECK_SP	ASTUECK	DEC	15	5	No. of Units Blocked for Unit-Quoted Securities
82	BNOMINA	☐	BNOMINAL	WERTV8_TR	CURR	15	2	Nominal amount in position currency
83	BNOMINA_AW	☐	BNOMINA_AW	WERTV8	CURR	15	2	Nominal amount in display currency from position currency
84	BNOMINA_SP	☐	BNOMINAL_SP	WERTV8_TR	CURR	15	2	Locked Nominal Amount in Position Currency
85	BNOMINA_SP_AW	☐	BNOMINAL_SP_AW	WERTV8	CURR	15	2	Nominal amount blocked in display curr. from position curr.
86	BKAUFWR	☐	BKAUFWR	WERTV8_TR	CURR	15	2	Acquisition value in position currency
87	BKAUFHW	☐	BKAUFHW	WERTV8_TR	CURR	15	2	Acquisition value in local currency
88	BKAUFWR_AW	☐	BKAUFWR_AW	WERTV8	CURR	15	2	Acquisition value in display currency from position currency
89	BKAUFHW_AW	☐	BKAUFHW_AW	WERTV8	CURR	15	2	Acquisition value in display currency from local currency
90	BBUCHWR	☐	FTI_BBUCHWR	WERTV8_TR	CURR	15	2	Book Value Excluding Costs in Position Currency
91	BBUCHHW	☐	FTI_BBUCHHW	WERTV8_TR	CURR	15	2	Book Value Excluding Costs in Local Currency
92	BBUCHWR_AW	☐	BBUCHWR_AW	WERTV8	CURR	15	2	Book Value Excl. Costs in Display Crcy (From Position Crcy)
93	BBUCHHW_AW	☐	BBUCHHW_AW	WERTV8	CURR	15	2	Book Value Excl. Costs in Display Crcy (From Local Crcy)
94	BAKTBWBW	☐	FTI_AKTBWBW	WERTV8_TR	CURR	15	2	Asset: Book value in position currency/transaction currency
95	BAKTBWHW	☐	FTI_AKTBWHW	WERTV8_TR	CURR	15	2	Asset: Book value in local currency
96	BAKTBWBW_AW	☐	FTI_AKTBWBW_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency from position currency
97	BAKTBWHW_AW	☐	FTI_AKTBWHW_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency from local currency
98	BKOSTWR	☐	BKOSTWR	WERTV8_TR	CURR	15	2	Capitalized incid.costs acquisition value in pos. currency
99	BKOSTHW	☐	BKOSTHW	WERTV8_TR	CURR	15	2	Capitalized incid.costs acquisition value in local currency
100	BKOSTWR_AW	☐	BKOSTWR_AW	WERTV8	CURR	15	2	Capitalized incidental costs acquisition value in DC from PC
101	BKOSTHW_AW	☐	BKOSTHW_AW	WERTV8	CURR	15	2	Capitalized incidental costs acquisition value in DC from LC
102	BKSTBWR	☐	VVBKSTBWR	WERTV8_TR	CURR	15	2	Book value of capitalized incid. costs in position currency
103	BKSTBHW	☐	VVBKSTBHW	WERTV8_TR	CURR	15	2	Book value of activated incid. costs in local currency
104	BKSTBWR_AW	☐	BKSTBWR_AW	WERTV8	CURR	15	2	Cap.incid.costs book value in display currency from PC
105	BKSTBHW_AW	☐	BKSTBHW_AW	WERTV8	CURR	15	2	Capitalized incid.costs book value in display curr. from LC
106	BKURSWEFW	☐	TB_BKURSWR	WERTV8_TR	CURR	15	2	Market value of position in position currency
107	BKURSWEHW	☐	TB_BKURSHW	WERTV8_TR	CURR	15	2	Market value of position in local currency
108	BKURSWE_AW	☐	BKUWEFW_AW	WERTV8	CURR	15	2	Market value of position in display currency from PC
109	BKURSHW_AW	☐	BKUWEHW_AW	WERTV8	CURR	15	2	Market value of position in display currency from LC
110	BWPBWWR	☐	VVBWPBWWR	WERTV8_TR	CURR	15	2	Price valuation in position currency
111	BWPBWHW	☐	VVBWPBWHW	WERTV8_TR	CURR	15	2	Price valuation in local currency
112	BWPBWWR_AW	☐	BWPBWWR_AW	WERTV8_TR	CURR	15	2	Rate valuation in display currency from position currency
113	BWPBWHW_AW	☐	BWPBWHW_AW	WERTV8_TR	CURR	15	2	Rate valuation in display currency from local currency
114	BFWBWHW	☐	VVBFWBWHW	WERTV8_TR	CURR	15	2	Foreign exchange valuation in local currency
115	BFWBWHW_AW	☐	BFWBWHW_AW	WERTV8_TR	CURR	15	2	Forex valuation in display currency from local currency
116	BKOBWWR	☐	VVBKOBWWR	WERTV8_TR	CURR	15	2	Valuation of capitalized costs from price in pos. currency
117	BKOBWHW	☐	VVBKOBWHW	WERTV8_TR	CURR	15	2	Valuation of capitalized costs from price in local currency
118	BKOBWWR_AW	☐	BKOBWWR_AW	WERTV8_TR	CURR	15	2	Cap. costs val. from rate in display curr. from pos. curr.
119	BKOBWHW_AW	☐	BKOBWHW_AW	WERTV8_TR	CURR	15	2	Cap. costs val. from rate in display curr. from local curr.
120	BKOFBHW	☐	VVBKOFBHW	WERTV8_TR	CURR	15	2	Forex valuation of capitalized costs in local currency
121	BKOFBHW_AW	☐	BKOFBHW_AW	WERTV8_TR	CURR	15	2	Forex valuat.of cap. costs in display curr. from local curr.
122	BAMORTWR	☐	FTI_BAMORTWR	WERTV8_TR	CURR	15	2	Total of amortization in position currency
123	BAMORTHW	☐	FTI_BAMORTHW	WERTV8_TR	CURR	15	2	Total of amortization in local currency
124	BAMORTWR_AW	☐	FTI_BAMORTWR_AW	WERTV8_TR	CURR	15	2	Total of amortization in display curr. from position curr.
125	BAMORTHW_AW	☐	FTI_BAMORTHW_AW	WERTV8_TR	CURR	15	2	Total of amortization in display curr. from local currency
126	BAGIOWR	☐	FTI_BAGIOWR	WERTV8_TR	CURR	15	2	Remaining premium/discount in position currency
127	BAGIOHW	☐	FTI_BAGIOHW	WERTV8_TR	CURR	15	2	Remaining premium/discount in local currency
128	BAGIOWR_AW	☐	FTI_BAGIOWR_AW	WERTV8_TR	CURR	15	2	Remaining premium/discount in display curr. from pos. curr.
129	BAGIOHW_AW	☐	FTI_BAGIOHW_AW	WERTV8_TR	CURR	15	2	Remaining premium/discount in display curr. from local curr.
130	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
131	RLZTG_K	☐	FTI_RLZTGK	DEC7	DEC	7	0	Remaining Term in Days (Key Figure)
132	UEBTG_K	☐	FTI_UEBTGK	DEC7	DEC	7	0	Overdue Period in Days (Key Figure)
133	G_AFABW	☐	FTI_AFABW	WERTV8	CURR	15	2	Total current depreciation in position currency
134	G_AFAHW	☐	FTI_AFAHW	WERTV8	CURR	15	2	Total current depreciation in local currency
135	G_AFAAW	☐	FTI_AFAAW	WERTV8	CURR	15	2	Total current depreciation in display currency from PC
136	G_AFAAWH	☐	FTI_AFAAWH	WERTV8	CURR	15	2	Total current dep.requirement in display currency from LC
137	G_AFABBW	☐	FTI_AFABBW	WERTV8	CURR	15	2	Write-Down Requirement in Position Currency
138	G_AFABHW	☐	FTI_AFABHW	WERTV8	CURR	15	2	Write-Down Requirement in Local Currency
139	G_AFABAW	☐	FTI_AFABAW	WERTV8	CURR	15	2	Write-Down Requirement in DC (from PC)
140	G_AFABAWH	☐	FTI_AFAHAW	WERTV8	CURR	15	2	Write-Down Requirement in Display Currency (from Local Crcy)
141	G_ERLEBW	☐	FTI_ERLEBW	WERTV8	CURR	15	2	Redemption gain in position currency
142	G_ERLEAW	☐	FTI_ERLEAW	WERTV8	CURR	15	2	Redemption gain in display currency from PC
143	G_ANKUPR	☐	FTI_ANKUPR	VVPKTKUR	DEC	15	6	Acquisition Price for Percentage-Quoted Securities in %
144	G_ANKSAW	☐	FTI_ANKSAW	VVPKTKUR	DEC	15	6	Acquisition price for unit-quoted sec. in DC calc. from PC
145	G_ANKSBW	☐	FTI_ANKSBW	VVPKTKUR	DEC	15	6	Acquisition Price f. Unit-Quoted Securities in Position Crcy
146	G_KAKSBW	☐	FTI_KAKSBW	VVPKTKUR	DEC	15	6	Purchase Price for Unit-Quoted Securities in Position Crcy
147	G_KAKUPR	☐	FTI_KAKUPR	VVPKTKUR	DEC	15	6	Purchase Price for Percentage-Quoted Securities in %
148	G_BUKSBW	☐	FTI_BUKSBW	VVPKTKUR	DEC	15	6	Book Price for Unit-Quoted Securities in Position Currency
149	G_BUKUPR	☐	FTI_BUKUPR	VVPKTKUR	DEC	15	6	Book Price for Percentage-Quoted Securities in %
150	G_KURSPR	☐	FTI_KURSPR	VVPKTKUR	DEC	15	6	Market Price / % (Percentage-Quoted Securities)
151	G_KURSAW	☐	FTI_KURSAW	VVPKTKUR	DEC	15	6	Market Price/Unit in DC (PC) for Unit-Quoted Securities
152	G_KURSBW	☐	FTI_KURSBW	VVPKTKUR	DEC	15	6	Market Price/Unit in Position Crcy (Unit-Quoted Securities)
153	G_SGEWBW	☐	FTI_SGEWBW	WERTV8	CURR	15	2	Pending gains in position currency
154	G_SGEWHW	☐	FTI_SGEWHW	WERTV8	CURR	15	2	Pending gains in local currency
155	G_SGEWAW	☐	FTI_SGEWAW	WERTV8	CURR	15	2	Pending gains in display currency from PC
156	G_SGEWAWH	☐	FTI_SGEHAW	WERTV8	CURR	15	2	Pending gains in display currency from LC
157	G_SVERBW	☐	FTI_SVERBW	WERTV8	CURR	15	2	Pending losses in position currency
158	G_SVERHW	☐	FTI_SVERHW	WERTV8	CURR	15	2	Pending losses in local currency
159	G_SVERAW	☐	FTI_SVERAW	WERTV8_TR	CURR	15	2	Pending losses in display currency from PC
160	G_SVERAWH	☐	FTI_SVEHAW	WERTV8	CURR	15	2	Pending losses in display currency from LC
161	G_STIRBW	☐	FTI_STIRBW	WERTV8	CURR	15	2	Hidden Reserve in Position Currency
162	G_STIRHW	☐	FTI_STIRHW	WERTV8	CURR	15	2	Hidden Reserve in Local Currency
163	G_STIRAW	☐	FTI_STIRAW	WERTV8	CURR	15	2	Undisclosed reserves in display currency from PC
164	G_STIRAWH	☐	FTI_STIHAW	WERTV8	CURR	15	2	Undisclosed reserves in display currency from LC
165	NOTWAERS	☐	VVNOTWAERS	WAERS	CUKY	5	0	Quotation currency (which prices are in)	TCURC
166	R_KSTST	☐	FTI_KSTST	VVPKTKUR	DEC	15	6	Market price for unit-quoted securities
167	R_KSTST_AW	☐	FTI_KSTSTAW	VVPKTKUR	DEC	15	6	Market price for unit-quoted securities in display currency
168	R_KPRST	☐	FTI_KPRST	VVPKTKUR	DEC	15	6	Market price for percentage-quoted securities
169	STUECKZINS	☐	TB_STZINS	TPM_AMOUNT	CURR	21	2	Accrued Interest in Position Currency
170	STUECKZINS_AW	☐	FTI_STZINS	TPM_AMOUNT	CURR	21	2	Accumulated Accrued Interest in DC (PC)
171	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
172	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
173	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
174	NPV_CC	☐	TV_NPV_CC	WERTV8_TR	CURR	15	2	RM NPV in Evaluation Currency
175	CLEAN_PRICE_CC	☐	FTI_CLEAN_PRICE_CC	T_PRESVAL	CURR	17	2	Clean Price in Valuation Currency
176	BPVALUE_CC	☐	TV_VALBP	T_PRESVAL	CURR	17	2	Basis Point Value in Evaluation Currency
177	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
178	MOD_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
179	NPV_PC_AW	☐	FTI_NPV_PC		CURR	23	2	RM NPV in Display Currency
180	CLEAN_PRICE_PC_AW	☐	FTI_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
181	BPVALUE_PC_AW	☐	FTI_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Display Currency
182	VAL_TI_PC	☐	FTI_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency
183	VAL_TI_LC	☐	FTI_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Security Valuation in Local Currency
184	VAL_TI_DC	☐	FTI_VAL_TI_DC	TPM_AMOUNT	CURR	21	2	Security Valuation in Display Currency (from Position Crcy)
185	VAL_FX_LC	☐	FTI_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Local Currency
186	VAL_CH_TI_PC	☐	FTI_VAL_CH_TI_PC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, in Position Currency
187	VAL_CH_TI_LC	☐	FTI_VAL_CH_TI_LC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, in Local Currency
188	VAL_CH_TI_DC	☐	FTI_VAL_CH_TI_DC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, in Display Crcy (from PC)
189	VAL_CH_FX_LC	☐	FTI_VAL_CH_FX_LC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, FX, in Local Currency
190	.INCLUDE	☐				0	0	Additional Treasury Selections
191	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	T242Q
192	NUMBR_LC	☐	FTI_NUMBR_LC	CFNUMBR	NUMC	3	0	Translation Type for Currency Translation into Local Crcy	T242Q
193	KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	TW56
194	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
195	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	TWX1
196	CASHF	☐	SCASHFLOW	XFELD	CHAR	1	0	Indicator for cash flow calculation up to end of term
197	BILST	☐	FTI_BILST	DATUM	DATS	8	0	Reference Date
198	BILST2	☐	FTI_BILST2	DATUM	DATS	8	0	Reference Date
199	BILST_REF_B	☐	FTI_BILST_REF_B	FTI_BILST_REF_B	CHAR	1	0	Positions: Remaining Term/Overdue Period Based On
200	BILST_REF_F	☐	FTI_BILST_REF_F	FTI_BILST_REF_F	CHAR	1	0	Flows: Remaining Term/Overdue Period Based On
201	STORNO	☐	FTI_STORNO	XFELD	CHAR	1	0	Evaluate Reversed Flows
202	AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	JBREVAL
203	FLG_SE	☐	FTI_LDB_FLG_SE	XFELD	CHAR	1	0	Product Group Securities: Yes/No
204	FLG_LO	☐	FTI_LDB_FLG_LO	XFELD	CHAR	1	0	Product Group Loans: Yes/No
205	FLG_OTC	☐	FTI_LDB_FLG_OTC	XFELD	CHAR	1	0	Product Group OTC (MM, FX, DE): Yes/No
206	FLG_LOF	☐	FTI_LDB_FLG_LOF	XFELD	CHAR	1	0	Product Group Listed Derivatives (Futures): Yes/No
207	FLG_COUPLING_SECACCGRP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
208	FLG_HISTORIC_ACCASSREF	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
209	FLG_CONDENSE	☐	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
210	FLG_NO_NULL	☐	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
211	FLG_EXCLUDING_PLAN	☐	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
212	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_WP	ALWPKL	TW22	ALWPKL
2	VTVBARW_WP	ANZGW	TCURC	WAERS
3	VTVBARW_WP	AUSWT	JBREVAL	AUSWERTUNG
4	VTVBARW_WP	BUKRS	T001	BUKRS		C	CN
5	VTVBARW_WP	CALC_CCY	TCURC	WAERS
6	VTVBARW_WP	CNTRY_COMP	T005	LAND1
7	VTVBARW_WP	GROUP_D	TP13	GROUP_D
8	VTVBARW_WP	GROUP_ID	TB001	BU_GROUP
9	VTVBARW_WP	GSART	TZPA	GSART
10	VTVBARW_WP	GSBER	TGSB	GSBER		C	CN
11	VTVBARW_WP	HKONT	SKB1	SAKNR
12	VTVBARW_WP	IND_SECTOR	TB038A	IND_SECTOR
13	VTVBARW_WP	ISTYPE	TB038	ISTYPE
14	VTVBARW_WP	KURSA	TW56	SKURSART
15	VTVBARW_WP	LAND1	T005	LAND1
16	VTVBARW_WP	LEGAL_ENTY	TB019	LEGAL_ENTY
17	VTVBARW_WP	LEGAL_ORG	TB032	LEGAL_ORG
18	VTVBARW_WP	LOTGENERATION_BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
19	VTVBARW_WP	MANDT	T000	MANDT		C	CN
20	VTVBARW_WP	NATION	T005	LAND1
21	VTVBARW_WP	NOTWAERS	TCURC	WAERS		C	CN
22	VTVBARW_WP	NUMBR	T242Q	NUMBR
23	VTVBARW_WP	NUMBR_LC	T242Q	NUMBR
24	VTVBARW_WP	PARTNR	BUT000	PARTNER
25	VTVBARW_WP	PERIV	T009	PERIV
26	VTVBARW_WP	RANL	VWPANLA	RANL
27	VTVBARW_WP	RATING	TP06	RATING
28	VTVBARW_WP	RATING_RANL	TP06	RATING
29	VTVBARW_WP	RDPBANK	BUT000	PARTNER		C	CN
30	VTVBARW_WP	RLDEPO	TWD01	RLDEPO
31	VTVBARW_WP	RPORTB	TWPOB	RPORTB		C	CN
32	VTVBARW_WP	RREFKONT	T037S	RREFKONT		C	CN
33	VTVBARW_WP	SANLF	TZAF	SANLF
34	VTVBARW_WP	SARTBET	TW02	SARTBET
35	VTVBARW_WP	SBILK	TW11	SBILK
36	VTVBARW_WP	SBWHR	TCURC	WAERS
37	VTVBARW_WP	SFHAART	AT10	SFHAART
38	VTVBARW_WP	SFOTY	TW21	SFOTY
39	VTVBARW_WP	SOL_INS	TP07	SOL_INS
40	VTVBARW_WP	SOL_INS_RANL	TP07	SOL_INS
41	VTVBARW_WP	STAFF_GRP	TP05	STAFF_GRP
42	VTVBARW_WP	STATE	T005	LAND1
43	VTVBARW_WP	SWERTTYP	TW20	SWERTTYP
44	VTVBARW_WP	SWPKLASS	TW01	SWPKLASS
45	VTVBARW_WP	VVRANLWI	TWX1	VVRANLWI
46	VTVBARW_WP	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20131127
SAP Release Created in