SAP ABAP Table VTVDETA_DR_BOE (Derivatives (Listed Transactions): For a Given Period)

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	VTVDETA_DR_BOE	Table Relationship Diagram
Short Description	Derivatives (Listed Transactions): For a Given Period

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	Derivatives Listed Trans.: Trans./Activity Characteristics
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	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
9	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
10	RLOT	☐	TPM_RLOT	TPM_RLOT	NUMC	10	0	Single position number for TR position management
11	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
12	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
13	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
14	.INCLUDE	☐				0	0	Treasury: Commitment Partner
15	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
16	.INCLUDE	☐				0	0	Treasury: Partner Attributes
17	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
18	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
19	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
20	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
21	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
22	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
23	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
24	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
25	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
26	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
27	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
28	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
29	.INCLUDE	☐				0	0	Business partner credit standing data
30	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
31	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
32	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
33	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
34	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
35	.INCLUDE	☐				0	0	Treasury: Cumulative Values: Characteristics Trans./Activity
36	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
37	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
38	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
39	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
40	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
41	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
42	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
43	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
44	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
45	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
46	JFDBUC	☐	FTI_FDBUC	FTI_FDBUC	CHAR	1	0	Relevance to CM
47	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
48	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
49	BANKK_HB	☐	FTI_BANKK	BANKK	CHAR	15	0	Bank key of house bank
50	BANKN_HB	☐	FTI_BANKN	BANKN	CHAR	18	0	Bank account number of house bank
51	BANKK_BP	☐	FTI_BANKKP	BANKK	CHAR	15	0	Bank key of business partner bank
52	BANKN_BP	☐	FTI_BANKNP	BANKN	CHAR	18	0	Bank account number of business partner
53	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
54	JAHR	☐	TB_JAHR	GJAHR	NUMC	4	0	Calendar year
55	MONAT	☐	TB_MONAT	TB_MONAT	NUMC	2	0	Calendar month
56	WOCHE	☐	FTI_WOCHE	NUMC2	NUMC	2	0	Calendar Week
57	MONAT_JAHR	☐	FTI_MONTH_YEAR	MCPERIOD	NUMC	6	0	Calendar Month/Year
58	WOCHE_JAHR	☐	FTI_WEEK_YEAR	MCPERIOD	NUMC	6	0	Calendar Week/Year
59	.INCLUDE	☐				0	0	Contains Invisible Calculation Fields for Drilldown Reportng
60	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
61	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
62	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
63	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
64	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
65	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	*
66	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	*
67	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
68	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
69	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
70	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
71	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
72	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
73	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
74	PAYIND	☐	TB_SPAYIND	T_SPAYIND	CHAR	1	0	Payment Status of Flows
75	SBWHRUL	☐	SBWHRUL	WAERS	CUKY	5	0	Position currency of underlying	TCURC
76	.INCLUDE	☐				0	0	Key Figures Occurring in Position and Flow Lists
77	.INCLUDE	☐				0	0	Actual Key Figures Occurring in Position and Flow Lists
78	RLZTG_K_F	☐	FTI_RLZTGK_F	DEC7	DEC	7	0	Remaining Term in Days (Key Figure)
79	UEBTG_K_F	☐	FTI_UEBTGK_F	DEC7	DEC	7	0	Overdue Period in Days (Key Figure)
80	.INCLUDE	☐				0	0	Quasi Key Figures Occurring in Position and Flow Lists
81	RLZTG_F	☐	FTI_RLZTG_F	NUMC5	NUMC	5	0	Remaining Term in Days
82	RLZMO_F	☐	FTI_RLZMO_F	NUMC4	NUMC	4	0	Remaining Term in Months
83	RLZJA_F	☐	FTI_RLZJA_F	NUMC3	NUMC	3	0	Remaining Term in Years
84	UEBTG_F	☐	FTI_UEBTG_F	NUMC5	NUMC	5	0	Overdue Period in Days
85	UEBMO_F	☐	FTI_UEBMO_F	NUMC3	NUMC	3	0	Overdue Period in Months
86	UEBJA_F	☐	FTI_UEBJA_F	NUMC2	NUMC	2	0	Overdue Period in Years
87	.INCLUDE	☐				0	0	Treasury: Characteristics for Cumulative Values
88	BZBETR	☐	D_CASHCW	WERTV8_TR	CURR	15	2	Payment amount in payment currency
89	BHWBETR	☐	D_CASHHW	WERTV8_TR	CURR	15	2	Payment amount in local currency
90	EHBETR	☐	EHBETR	WERTV7	CURR	13	2	Profit/loss amount in local currency
91	EEBETR	☐	EEBETR	WERTV7	CURR	13	2	Profit/loss amount in profit/loss currency
92	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
93	SPLWHR	☐	SPLWHR	WAERS	CUKY	5	0	Profit/loss currency	TCURC
94	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
95	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	TCURC
96	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	TCURC
97	D_ASTUECK	☐	D_ASTUECK	ASTUECK	DEC	15	5	Change in no. of units (for unit-quoted securities)
98	D_ASTUECK_LONG	☐	D_ASTUECK_LONG	ASTUECK	DEC	15	5	Change in number of units - long
99	D_ASTUECK_SHORT	☐	D_ASTUECK_SHORT	ASTUECK	DEC	15	5	Change in number of units - short
100	D_BNOMBW	☐	D_BNOMBW	WERTV8_TR	CURR	15	2	Change in nominal value in position currency
101	D_BNOMBW_LONG	☐	D_BNOMBW_LONG	WERTV8_TR	CURR	15	2	Change in nom. value of underlying - long (UL pos.currency)
102	D_BNOMBW_SHORT	☐	D_BNOMBW_SHORT	WERTV8_TR	CURR	15	2	Change in nom. value of underlying - short (UL pos.currency)
103	D_AWBW	☐	D_AWBW	WERTV8_TR	CURR	15	2	Change in acquisition value in position currency
104	D_AWBW_LONG	☐	D_AWBW_LONG	WERTV8_TR	CURR	15	2	Change in acquisition value - long (position currency)
105	D_AWBW_SHORT	☐	D_AWBW_SHORT	WERTV8_TR	CURR	15	2	Change in acquisition value - short (position currency)
106	D_AWHW	☐	D_AWHW	WERTV8_TR	CURR	15	2	Change in acquisition value in local currency
107	D_AWHW_LONG	☐	D_AWHW_LONG	WERTV8_TR	CURR	15	2	Change in acquisition value - long (local currency)
108	D_AWHW_SHORT	☐	D_AWHW_SHORT	WERTV8_TR	CURR	15	2	Change in acquisition value - short (local currency)
109	D_BWBW	☐	D_BWBW	WERTV8_TR	CURR	15	2	Change in book values in position currency
110	D_BWBW_LONG	☐	D_BWBW_LONG	WERTV8_TR	CURR	15	2	Delta Book Value, Long (Position Currency)
111	D_BWBW_SHORT	☐	D_BWBW_SHORT	WERTV8_TR	CURR	15	2	Change in book value - short (postition currency)
112	D_BWHW	☐	D_BWHW	WERTV8_TR	CURR	15	2	Change in book value in local currency
113	D_BWHW_LONG	☐	D_BWHW_LONG	WERTV8_TR	CURR	15	2	Change in book value - long (local currency)
114	D_BWHW_SHORT	☐	D_BWHW_SHORT	WERTV8_TR	CURR	15	2	Change in book value - short (local currency)
115	.INCLUDE	☐				0	0	Key Figures for Position Trend List
116	ASTUECK_A	☐	FTI_ASTUEA	ASTUECK	DEC	15	5	No. of units for unit-quoted securities - start
117	ASTUECK_E	☐	FTI_ASTUEE	ASTUECK	DEC	15	5	No. of units for unit-quoted securities - end
118	ASTUECK_LONG_A	☐	FTI_ASTUECK_LONG_A	ASTUECK	DEC	15	5	Number of units long - start
119	ASTUECK_LONG_E	☐	FTI_ASTUECK_LONG_E	ASTUECK	DEC	15	5	Number of units long - end
120	ASTUECK_SHORT_A	☐	FTI_ASTUECK_SHORT_A	ASTUECK	DEC	15	5	Number of units short - start
121	ASTUECK_SHORT_E	☐	FTI_ASTUECK_SHORT_E	ASTUECK	DEC	15	5	Number of units short - end
122	BNOMINAL_UL_A	☐	FTI_BNOMINAL_A	WERTV8_TR	CURR	15	2	Total Nominal Amount of Underlying (UL Pos. Crcy): Start
123	BNOMINAL_UL_E	☐	FTI_BNOMINAL_E	WERTV8_TR	CURR	15	2	Total Nominal Amount of Underlying (UL Pos. Crcy): End
124	BNOMINAL_LONG_A	☐	FTI_BNOMINAL_LONG_A	WERTV8_TR	CURR	15	2	Total nom. amount of underlying long (UL pos. curr.) - start
125	BNOMINAL_LONG_E	☐	FTI_BNOMINAL_LONG_E	WERTV8_TR	CURR	15	2	Total nom. amount of underlying long (UL pos. curr.) - end
126	BNOMINAL_SHORT_A	☐	FTI_BNOMINAL_SHORT_A	WERTV8_TR	CURR	15	2	Total nom. amount of underlying short (UL pos. curr) - start
127	BNOMINAL_SHORT_E	☐	FTI_BNOMINAL_SHORT_E	WERTV8_TR	CURR	15	2	Total nom. amount of underlying short (UL pos. curr) - end
128	BKA_AWR	☐	FTI_BKAAFW	WERTV8	CURR	15	2	Acquisition value in position currency (start)
129	BKA_AHW	☐	FTI_BKAAHW	WERTV8	CURR	15	2	Acquisition value in local currency (start)
130	BKA_EWR	☐	FTI_BKAEFW	WERTV8	CURR	15	2	Acquisition value in position currency (end)
131	BKA_EHW	☐	FTI_BKAEHW	WERTV8	CURR	15	2	Acquisition value in local currency (end)
132	BBU_AWR	☐	FTI_BBUABW	WERTV8	CURR	15	2	Book Value Excl. Costs in Position Currency: Start
133	BBU_AHW	☐	FTI_BBUAHW	WERTV8	CURR	15	2	Book Value Excl. Costs in Local Currency: Start
134	BBU_EWR	☐	FTI_BBUEBW	WERTV8	CURR	15	2	Book Value Excl. Costs in Position Currency: End
135	BBU_EHW	☐	FTI_BBUEHW	WERTV8	CURR	15	2	Book Value Excl. Costs in Local Currency: End
136	AKTBWBW_A	☐	FTI_AKTBWBW_A	WERTV8_TR	CURR	15	2	Asset: Book value in position currency - start
137	AKTBWBW_E	☐	FTI_AKTBWBW_E	WERTV8_TR	CURR	15	2	Asset: Book value in position currency - end
138	AKTBWHW_A	☐	FTI_AKTBWHW_A	WERTV8_TR	CURR	15	2	Asset: Book value in local currency - start
139	AKTBWHW_E	☐	FTI_AKTBWHW_E	WERTV8_TR	CURR	15	2	Asset: Book value in local currency - end
140	PASBWBW_A	☐	FTI_PASBWBW_A	WERTV8_TR	CURR	15	2	Liability: Book value in position currency - start
141	PASBWBW_E	☐	FTI_PASBWBW_E	WERTV8_TR	CURR	15	2	Liability: Book value in position currency - end
142	PASBWHW_A	☐	FTI_PASBWHW_A	WERTV8_TR	CURR	15	2	Liability: Book value in local currency - start
143	PASBWHW_E	☐	FTI_PASBWHW_E	WERTV8_TR	CURR	15	2	Liability: Book value in local currency - end
144	BKAUFWR_A_A	☐	FTI_BKAUFWR_A_A	WERTV8_TR	CURR	15	2	Asset: Acquisition value in position currency - start
145	BKAUFWR_A_E	☐	FTI_BKAUFWR_A_E	WERTV8_TR	CURR	15	2	Asset: Acquisition value in position currency - end
146	BKAUFHW_A_A	☐	FTI_BKAUFHW_A_A	WERTV8_TR	CURR	15	2	Asset: Acquisition value in local currency - start
147	BKAUFHW_A_E	☐	FTI_BKAUFHW_A_E	WERTV8_TR	CURR	15	2	Asset: Acquisition value in local currency - end
148	BKAUFWR_P_A	☐	FTI_BKAUFWR_P_A	WERTV8_TR	CURR	15	2	Liability: Acquisition value in position currency - start
149	BKAUFWR_P_E	☐	FTI_BKAUFWR_P_E	WERTV8_TR	CURR	15	2	Liability: Acquisition value in position currency - end
150	BKAUFHW_P_A	☐	FTI_BKAUFHW_P_A	WERTV8_TR	CURR	15	2	Liability: Acquisition value in local currency - start
151	BKAUFHW_P_E	☐	FTI_BKAUFHW_P_E	WERTV8_TR	CURR	15	2	Liability: Acquisition value in local currency - end
152	BKURSWEFW_LONG_A	☐	FTI_BKURSWR_LONG_A	WERTV8_TR	CURR	15	2	Current Market Value of Underlying Long (ULPC): Start
153	BKURSWEFW_LONG_E	☐	FTI_BKURSWR_LONG_E	WERTV8_TR	CURR	15	2	Current Market Value of Underlying Long (ULPC): End
154	BKURSWEFW_SHORT_A	☐	FTI_BKURSWR_SHORT_A	WERTV8_TR	CURR	15	2	Current Market Value of Underlying Short (ULPC): Start
155	BKURSWEFW_SHORT_E	☐	FTI_BKURSWR_SHORT_E	WERTV8_TR	CURR	15	2	Current Market Value of Underlying Short (ULPC): End
156	NPV_PC_A	☐	FTI_NPV_PC_A	WERTV8_TR	CURR	15	2	RM NPV in Position Currency: Start
157	NPV_PC_E	☐	FTI_NPV_PC_E	WERTV8_TR	CURR	15	2	RM NPV in Position Currency: End
158	CLEAN_PRICE_PC_A	☐	FTI_CLEAN_PRICE_PC_A	WERTV8_TR	CURR	15	2	Clean Price in Position Currency: Start
159	CLEAN_PRICE_PC_E	☐	FTI_CLEAN_PRICE_PC_E	WERTV8_TR	CURR	15	2	Clean Price in Position Currency: End
160	BPVALUE_PC_A	☐	FTI_VALBP_PC_A	WERTV8_TR	CURR	15	2	Basis Point Value in Position Currency: Start
161	BPVALUE_PC_E	☐	FTI_VALBP_PC_E	WERTV8_TR	CURR	15	2	Basis Point Value in Position Currency: End
162	MAC_DURATION_A	☐	FTI_MAC_DURATION_A	DEC9_3	DEC	12	3	Macaulay Duration: Start
163	MAC_DURATION_E	☐	FTI_MAC_DURATION_E	DEC9_3	DEC	12	3	Macaulay Duration: End
164	MOD_DURATION_A	☐	FTI_MOD_DURATION_A	DEC9_3	DEC	12	3	Modified Duration: Start
165	MOD_DURATION_E	☐	FTI_MOD_DURATION_E	DEC9_3	DEC	12	3	Modified Duration: End
166	.INCLUDE	☐				0	0	Display Currency Fields Cumulative Values Treasury
167	BZBETR_AW	☐	FTI_CASWCW	WERTV8	CURR	15	2	Payment Amount of Flow in Display Crcy (from Pmnt Crcy)
168	BHWBETR_AW	☐	FTI_CASWHW	WERTV8	CURR	15	2	Payment amount of flow in display currency from local curr.
169	EHBETR_AW	☐	EHBETR_AW	WERTV8_TR	CURR	15	2	Profit/loss amount in display currency from local currency
170	EEBETR_AW	☐	EEBETR_AW	WERTV8_TR	CURR	15	2	Profit/Loss Amount in DC (from P/L Currency)
171	D_BNOMBW_LONG_AW	☐	FTI_D_BNOMBW_LONG_AW	WERTV8_TR	CURR	15	2	Change in nominal value of underlying - long (display curr.)
172	D_BNOMBW_SHORT_AW	☐	FTI_D_BNOMBW_SHORT_AW	WERTV8_TR	CURR	15	2	Change in nominal value of underlying- short (display curr.)
173	D_BNOMBW_AW	☐	FTI_D_BNOMUNDERLYING_UW_AW	WERTV8_TR	CURR	15	2	Delta Nominal Value of Underlying in Display Currency
174	D_AWBW_LONG_AW	☐	FTI_D_AWBW_LONG_AW	WERTV8_TR	CURR	15	2	Change in acquisition val.- long (disp.curr. from pos.curr.)
175	D_AWBW_SHORT_AW	☐	FTI_D_AWBW_SHORT_AW	WERTV8_TR	CURR	15	2	Change in acquisition val.- short (disp.curr.from pos.curr.)
176	D_AWHW_LONG_AW	☐	FTI_D_AWHW_LONG_AW	WERTV8_TR	CURR	15	2	Change in acquisition val. - long (disp.curr.from loc.curr.)
177	D_AWHW_SHORT_AW	☐	FTI_D_AWHW_SHORT_AW	WERTV8_TR	CURR	15	2	Change in acquisition val.- short (disp.curr.from loc.curr.)
178	D_AWHW_AW	☐	FTI_AWAWHW	WERTV8	CURR	15	2	Change in acquisition value in display curr. from loc.curr.
179	D_AWBW_AW	☐	FTI_AWAWBW	WERTV8	CURR	15	2	Change in acquisition value in display curr. from pos.curr.
180	D_BWBW_AW	☐	FTI_BWAWBW	WERTV8	CURR	15	2	Change in book value in display currency from pos.currency
181	D_BWBW_LONG_AW	☐	FTI_D_AKTBWBW_AW	WERTV8_TR	CURR	15	2	Asset: Change in book value in display currency
182	D_BWBW_SHORT_AW	☐	FTI_D_PASBWBW_AW	WERTV8_TR	CURR	15	2	Liability: Change in book value in display currency
183	D_BWHW_AW	☐	FTI_BWAWHW	WERTV8	CURR	15	2	Change in book value in display currency from local currency
184	D_BWHW_LONG_AW	☐	FTI_D_AKTBWHW_AW	WERTV8_TR	CURR	15	2	Asset: Change in book value in disp. curr. from local curr.
185	D_BWHW_SHORT_AW	☐	FTI_D_PASBWHW_AW	WERTV8_TR	CURR	15	2	Liability: Change in book val. in disp.curr.from local curr.
186	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
187	BNOMINAL_UL_A_AW	☐	FTI_BNOMINAL_A_AW	WERTV8_TR	CURR	15	2	Total Nominal Amount of Underlying in Display Crcy: Start
188	BNOMINAL_UL_E_AW	☐	FTI_BNOMINAL_E_AW	WERTV8_TR	CURR	15	2	Total Nominal Amount of Underlying in Display Crcy: End
189	BNOMINAL_LONG_A_AW	☐	FTI_BNOMINAL_LONG_A_AW	WERTV8_TR	CURR	15	2	Total nom. amount of underlying long (display curr.) - start
190	BNOMINAL_LONG_E_AW	☐	FTI_BNOMINAL_LONG_E_AW	WERTV8_TR	CURR	15	2	Total nom. amount of underlying long (display curr.) - end
191	BNOMINAL_SHORT_A_AW	☐	FTI_BNOMINAL_SHORT_A_AW	WERTV8_TR	CURR	15	2	Total nom. amount of underlying short (display curr.)- start
192	BNOMINAL_SHORT_E_AW	☐	FTI_BNOMINAL_SHORT_E_AW	WERTV8_TR	CURR	15	2	Total nom. amount of underlying short (display curr.) - end
193	BKA_AWR_AW	☐	FTI_BKWAFW	WERTV8	CURR	15	2	Acquisition value in display currency (start) from pos.curr.
194	BKA_AHW_AW	☐	FTI_BKWAHW	WERTV8	CURR	15	2	Acquisition value in display currency (start) from loc.curr.
195	BKA_EWR_AW	☐	FTI_BKWEFW	WERTV8	CURR	15	2	Acquisition value in display currency (end) from pos. curr.
196	BKA_EHW_AW	☐	FTI_BKWEHW	WERTV8	CURR	15	2	Acquisition value in display currency (end) from local curr.
197	BBU_AWR_AW	☐	FTI_BBWAFW	WERTV8	CURR	15	2	Book Value Excl.Costs in Display Crcy (from Pos.Crcy): Start
198	BBU_AHW_AW	☐	FTI_BBWAHW	WERTV8	CURR	15	2	Book Value Excl.Costs in Display Crcy (from Loc.Crcy): Start
199	BBU_EWR_AW	☐	FTI_BBWEFW	WERTV8	CURR	15	2	Book Value Excl.Costs in Display Crcy (from Pos.Crcy): End
200	BBU_EHW_AW	☐	FTI_BBWEHW	WERTV8	CURR	15	2	Book Value Excl.Costs in Display Crcy (from Loc.Crcy): End
201	AKTBWBW_A_AW	☐	FTI_AKTBWBW_A_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency - start
202	AKTBWBW_E_AW	☐	FTI_AKTBWBW_E_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency - end
203	AKTBWHW_A_AW	☐	FTI_AKTBWHW_A_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency (from LC) - start
204	AKTBWHW_E_AW	☐	FTI_AKTBWHW_E_AW	WERTV8_TR	CURR	15	2	Asset: Book value in display currency (from LC) - end
205	PASBWBW_A_AW	☐	FTI_PASBWBW_A_AW	WERTV8_TR	CURR	15	2	Liability: Book value in display currency - start
206	PASBWBW_E_AW	☐	FTI_PASBWBW_E_AW	WERTV8_TR	CURR	15	2	Liability: Book value in display currency - end
207	PASBWHW_A_AW	☐	FTI_PASBWHW_A_AW	WERTV8_TR	CURR	15	2	Liability: Book value in display currency (from LC) - start
208	PASBWHW_E_AW	☐	FTI_PASBWHW_E_AW	WERTV8_TR	CURR	15	2	Liability: Book value in display currency (from LC) - end
209	BKAUFWR_A_A_AW	☐	FTI_BKAUFWR_A_A_AW	WERTV8_TR	CURR	15	2	Asset: Acquis.value in display curr. from pos. curr. - start
210	BKAUFWR_A_E_AW	☐	FTI_BKAUFWR_A_E_AW	WERTV8_TR	CURR	15	2	Asset: Acquisition value in display curr.from pos.curr.- end
211	BKAUFHW_A_A_AW	☐	FTI_BKAUFHW_A_A_AW	WERTV8_TR	CURR	15	2	Asset: Acq. value in displ. curr. from local. curr. - start
212	BKAUFHW_A_E_AW	☐	FTI_BKAUFHW_A_E_AW	WERTV8_TR	CURR	15	2	Asset: Acquis. value in displ. curr. from local. curr. - end
213	BKAUFWR_P_A_AW	☐	FTI_BKAUFWR_P_A_AW	WERTV8_TR	CURR	15	2	Liability: Acquis. value in disp.curr. from pos.curr - start
214	BKAUFWR_P_E_AW	☐	FTI_BKAUFWR_P_E_AW	WERTV8_TR	CURR	15	2	Liability: Acquis. value in disp. curr. from pos. curr - end
215	BKAUFHW_P_A_AW	☐	FTI_BKAUFHW_P_A_AW	WERTV8_TR	CURR	15	2	Liability: Acquis.val.in displ.curr.from local curr. - start
216	BKAUFHW_P_E_AW	☐	FTI_BKAUFHW_P_E_AW	WERTV8_TR	CURR	15	2	Liability: Acquis.value in displ.curr.from local curr. - end
217	BKURSWEFW_LONG_A_AW	☐	FTI_BKURSWR_LONG_A_AW	WERTV8_TR	CURR	15	2	Current Market Value of Underlying Long in DC (ULPC): Start
218	BKURSWEFW_LONG_E_AW	☐	FTI_BKURSWR_LONG_E_AW	WERTV8_TR	CURR	15	2	Current Market Value of Underlying Long in DC (ULPC): End
219	BKURSWEFW_SHORT_A_AW	☐	FTI_BKURSWR_SHORT_A_AW	WERTV8_TR	CURR	15	2	Current Market Value of Underlying Short in DC (ULPC): Start
220	BKURSWEFW_SHORT_E_AW	☐	FTI_BKURSWR_SHORT_E_AW	WERTV8_TR	CURR	15	2	Current Market Value of Underlying Short in DC (ULPC): End
221	NPV_PC_A_AW	☐	FTI_NPV_PC_A_AW	WERTV8_TR	CURR	15	2	RM NPV in Display Currency: Start
222	NPV_PC_E_AW	☐	FTI_NPV_PC_E_AW	WERTV8_TR	CURR	15	2	RM NPV in Display Currency: End
223	CLEAN_PRICE_PC_A_AW	☐	FTI_CLEAN_PRICE_AW_A	WERTV8_TR	CURR	15	2	Clean Price in Display Currency: Start
224	CLEAN_PRICE_PC_E_AW	☐	FTI_CLEAN_PRICE_AW_E	WERTV8_TR	CURR	15	2	Clean Price in Display Currency: End
225	BPVALUE_PC_A_AW	☐	FTI_VALBP_AW_A	WERTV8_TR	CURR	15	2	Basis Point Value in Display Currency: Start
226	BPVALUE_PC_E_AW	☐	FTI_VALBP_AW_E	WERTV8_TR	CURR	15	2	Basis Point Value in Display Currency: End
227	.INCLUDE	☐				0	0	Additional Treasury Selections
228	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	T242Q
229	NUMBR_LC	☐	FTI_NUMBR_LC	CFNUMBR	NUMC	3	0	Translation Type for Currency Translation into Local Crcy	T242Q
230	KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	TW56
231	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
232	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	TWX1
233	CASHF	☐	SCASHFLOW	XFELD	CHAR	1	0	Indicator for cash flow calculation up to end of term
234	BILST	☐	FTI_BILST	DATUM	DATS	8	0	Reference Date
235	BILST2	☐	FTI_BILST2	DATUM	DATS	8	0	Reference Date
236	BILST_REF_B	☐	FTI_BILST_REF_B	FTI_BILST_REF_B	CHAR	1	0	Positions: Remaining Term/Overdue Period Based On
237	BILST_REF_F	☐	FTI_BILST_REF_F	FTI_BILST_REF_F	CHAR	1	0	Flows: Remaining Term/Overdue Period Based On
238	STORNO	☐	FTI_STORNO	XFELD	CHAR	1	0	Evaluate Reversed Flows
239	AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	JBREVAL
240	FLG_SE	☐	FTI_LDB_FLG_SE	XFELD	CHAR	1	0	Product Group Securities: Yes/No
241	FLG_LO	☐	FTI_LDB_FLG_LO	XFELD	CHAR	1	0	Product Group Loans: Yes/No
242	FLG_OTC	☐	FTI_LDB_FLG_OTC	XFELD	CHAR	1	0	Product Group OTC (MM, FX, DE): Yes/No
243	FLG_LOF	☐	FTI_LDB_FLG_LOF	XFELD	CHAR	1	0	Product Group Listed Derivatives (Futures): Yes/No
244	FLG_COUPLING_SECACCGRP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
245	FLG_HISTORIC_ACCASSREF	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
246	FLG_CONDENSE	☐	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
247	FLG_NO_NULL	☐	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
248	FLG_EXCLUDING_PLAN	☐	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
249	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	VTVDETA_DR_BOE	ANZGW	TCURC	WAERS
2	VTVDETA_DR_BOE	AUSWT	JBREVAL	AUSWERTUNG
3	VTVDETA_DR_BOE	BUKRS	T001	BUKRS		C	CN
4	VTVDETA_DR_BOE	CNTRY_COMP	T005	LAND1
5	VTVDETA_DR_BOE	GROUP_D	TP13	GROUP_D
6	VTVDETA_DR_BOE	GROUP_ID	TB001	BU_GROUP
7	VTVDETA_DR_BOE	GSART	TZPA	GSART
8	VTVDETA_DR_BOE	IND_SECTOR	TB038A	IND_SECTOR
9	VTVDETA_DR_BOE	ISTYPE	TB038	ISTYPE
10	VTVDETA_DR_BOE	KURSA	TW56	SKURSART
11	VTVDETA_DR_BOE	LAND1	T005	LAND1
12	VTVDETA_DR_BOE	LEGAL_ENTY	TB019	LEGAL_ENTY
13	VTVDETA_DR_BOE	LEGAL_ORG	TB032	LEGAL_ORG
14	VTVDETA_DR_BOE	MANDT	T000	MANDT		C	CN
15	VTVDETA_DR_BOE	NATION	T005	LAND1
16	VTVDETA_DR_BOE	NUMBR	T242Q	NUMBR
17	VTVDETA_DR_BOE	NUMBR_LC	T242Q	NUMBR
18	VTVDETA_DR_BOE	PARTNR	BUT000	PARTNER
19	VTVDETA_DR_BOE	PERIV	T009	PERIV
20	VTVDETA_DR_BOE	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT		C	CN
21	VTVDETA_DR_BOE	PRKEY	PAYRQ	KEYNO		C	CN
22	VTVDETA_DR_BOE	RANL	VWPANLA	RANL
23	VTVDETA_DR_BOE	RATING	TP06	RATING
24	VTVDETA_DR_BOE	RDEALER	TZDEA	RDEALER
25	VTVDETA_DR_BOE	RPORTB	TWPOB	RPORTB		C	CN
26	VTVDETA_DR_BOE	RPZAHL	BUT000	PARTNER
27	VTVDETA_DR_BOE	RREFKONT	T037S	RREFKONT
28	VTVDETA_DR_BOE	SANLF	TZAF	SANLF		1	CN
29	VTVDETA_DR_BOE	SBEWART	TZB0A	SBEWART
30	VTVDETA_DR_BOE	SBWHR	TCURC	WAERS
31	VTVDETA_DR_BOE	SBWHRUL	TCURC	WAERS		C	CN
32	VTVDETA_DR_BOE	SFGTYP	AT01	SFGTYP		C	CN
33	VTVDETA_DR_BOE	SFHAART	AT10	SFHAART		C	CN
34	VTVDETA_DR_BOE	SOL_INS	TP07	SOL_INS
35	VTVDETA_DR_BOE	SPLWHR	TCURC	WAERS
36	VTVDETA_DR_BOE	STAFF_GRP	TP05	STAFF_GRP
37	VTVDETA_DR_BOE	STATE	T005	LAND1
38	VTVDETA_DR_BOE	VVRANLWI	TWX1	VVRANLWI
39	VTVDETA_DR_BOE	WAERS	TCURC	WAERS
40	VTVDETA_DR_BOE	WGSCHFT1	TCURC	WAERS		C	CN
41	VTVDETA_DR_BOE	WGSCHFT2	TCURC	WAERS		C	CN
42	VTVDETA_DR_BOE	WZBETR	TCURC	WAERS
43	VTVDETA_DR_BOE	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20131127
SAP Release Created in