SAP ABAP Table VTVDETA_DR (Derivatives (OTC): 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	Table Relationship Diagram
Short Description	Derivatives (OTC): 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	Treasury: Non-Cumulative Values Deriv.: 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	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
9	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
10	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
11	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
12	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
13	SAKTIV	☐	FTI_SAKTIV	FTI_SAKTIV	CHAR	1	0	Active status of financial transaction (drilldown reporting)
14	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
15	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
16	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
17	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
18	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
19	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
20	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
21	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
22	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
23	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
24	SPUTCALL	☐	TI_SPUTCAL	T_SPUTCAL	NUMC	1	0	Put/call indicator
25	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
26	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
27	.INCLUDE	☐				0	0	Treasury: Commitment Partner
28	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
29	.INCLUDE	☐				0	0	Treasury: Partner Attributes
30	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
31	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
32	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
33	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
34	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
35	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
36	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
37	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
38	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
39	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
40	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
41	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
42	.INCLUDE	☐				0	0	Business partner credit standing data
43	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
44	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
45	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
46	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
47	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
48	.INCLUDE	☐				0	0	Treasury: Cumulative Values: Characteristics Trans./Activity
49	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
50	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
51	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
52	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
53	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
54	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
55	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
56	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
57	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
58	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
59	JFDBUC	☐	FTI_FDBUC	FTI_FDBUC	CHAR	1	0	Relevance to CM
60	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
61	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
62	BANKK_HB	☐	FTI_BANKK	BANKK	CHAR	15	0	Bank key of house bank
63	BANKN_HB	☐	FTI_BANKN	BANKN	CHAR	18	0	Bank account number of house bank
64	BANKK_BP	☐	FTI_BANKKP	BANKK	CHAR	15	0	Bank key of business partner bank
65	BANKN_BP	☐	FTI_BANKNP	BANKN	CHAR	18	0	Bank account number of business partner
66	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
67	JAHR	☐	TB_JAHR	GJAHR	NUMC	4	0	Calendar year
68	MONAT	☐	TB_MONAT	TB_MONAT	NUMC	2	0	Calendar month
69	WOCHE	☐	FTI_WOCHE	NUMC2	NUMC	2	0	Calendar Week
70	MONAT_JAHR	☐	FTI_MONTH_YEAR	MCPERIOD	NUMC	6	0	Calendar Month/Year
71	WOCHE_JAHR	☐	FTI_WEEK_YEAR	MCPERIOD	NUMC	6	0	Calendar Week/Year
72	.INCLUDE	☐				0	0	Contains Invisible Calculation Fields for Drilldown Reportng
73	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
74	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
75	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
76	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
77	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
78	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	*
79	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	*
80	SBEWEBE	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
81	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
82	SBFREI	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
83	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
84	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
85	GSTRAT	☐	FTI_GSTRAT	T_SPUTCAL	NUMC	1	0	Business strategy combination product type/trans.type/PC ID
86	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
87	PAYIND	☐	TB_SPAYIND	T_SPAYIND	CHAR	1	0	Payment Status of Flows
88	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
89	SUWHR	☐	SUWHR	WAERS	CUKY	5	0	Underlying currency	TCURC
90	WGSCHFT3	☐	FTI_WGSCH3	WAERS	CUKY	5	0	Currency borr./sale start/end	TCURC
91	WGSCHFT4	☐	FTI_WGSCH4	WAERS	CUKY	5	0	Currency investment/purchase start/end	TCURC
92	.INCLUDE	☐				0	0	Key Figures Occurring in Position and Flow Lists
93	.INCLUDE	☐				0	0	Actual Key Figures Occurring in Position and Flow Lists
94	RLZTG_K_F	☐	FTI_RLZTGK_F	DEC7	DEC	7	0	Remaining Term in Days (Key Figure)
95	UEBTG_K_F	☐	FTI_UEBTGK_F	DEC7	DEC	7	0	Overdue Period in Days (Key Figure)
96	.INCLUDE	☐				0	0	Quasi Key Figures Occurring in Position and Flow Lists
97	RLZTG_F	☐	FTI_RLZTG_F	NUMC5	NUMC	5	0	Remaining Term in Days
98	RLZMO_F	☐	FTI_RLZMO_F	NUMC4	NUMC	4	0	Remaining Term in Months
99	RLZJA_F	☐	FTI_RLZJA_F	NUMC3	NUMC	3	0	Remaining Term in Years
100	UEBTG_F	☐	FTI_UEBTG_F	NUMC5	NUMC	5	0	Overdue Period in Days
101	UEBMO_F	☐	FTI_UEBMO_F	NUMC3	NUMC	3	0	Overdue Period in Months
102	UEBJA_F	☐	FTI_UEBJA_F	NUMC2	NUMC	2	0	Overdue Period in Years
103	.INCLUDE	☐				0	0	Treasury: Characteristics for Cumulative Values
104	BZBETR	☐	D_CASHCW	WERTV8_TR	CURR	15	2	Payment amount in payment currency
105	BHWBETR	☐	D_CASHHW	WERTV8_TR	CURR	15	2	Payment amount in local currency
106	EHBETR	☐	EHBETR	WERTV7	CURR	13	2	Profit/loss amount in local currency
107	EEBETR	☐	EEBETR	WERTV7	CURR	13	2	Profit/loss amount in profit/loss currency
108	PABGERFHW	☐	PABGERFHW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in Local Currency
109	PABGERFPL	☐	PABGERFPLW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in Profit/Loss Currency
110	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
111	SPLWHR	☐	SPLWHR	WAERS	CUKY	5	0	Profit/loss currency	TCURC
112	D_AKTBWBW	☐	D_AKTBWBW	WERTV8_TR	CURR	15	2	Asset: Change in book value in position/transaction curr.
113	D_AKTBWHW	☐	D_AKTBWHW	WERTV8_TR	CURR	15	2	Asset: Change in book value in local currency
114	D_PASBWBW	☐	D_PASBWBW	WERTV8_TR	CURR	15	2	Liability: Change in book value in position/trans. curr.
115	D_PASBWHW	☐	D_PASBWHW	WERTV8_TR	CURR	15	2	Liability: Change in book value in local currency
116	D_BEW_PAS_OPR	☐	FTI_D_BEW_PAS_OPR	WERTV8_TR	CURR	15	2	Liability: Delta Eval. Option Premium (Borrow/Sale) in PC/TC
117	D_BEW_PAS_OPR_HW	☐	FTI_D_BEW_PAS_OPR_HW	WERTV8_TR	CURR	15	2	Liability: Delta Eval. Option Premium (Borrowing/Sale) in LC
118	D_FXBEW_PAS_OPR_HW	☐	FTI_D_FXBEW_PAS_OPR_HW	WERTV8_TR	CURR	15	2	Delta Evaluation Forex Liability Option Premium in LC
119	D_BEW_AKT_OPR	☐	FTI_D_BEW_AKT_OPR	WERTV8_TR	CURR	15	2	Asset: Delta Eval. Option Premium (Borrowing/Sale in PC/TC
120	D_BEW_AKT_OPR_HW	☐	FTI_D_BEW_AKT_OPR_HW	WERTV8_TR	CURR	15	2	Asset: Delta Eval. Option Premium (Borrowing/Sale) in LC
121	D_FXBEW_AKT_OPR_HW	☐	FTI_D_FXBEW_AKT_OPR_HW	WERTV8_TR	CURR	15	2	Delta Evaluation Forex Capitalized Option Premium in LC
122	D_BNOMBW	☐	D_BNOMUNDERLYING_UW	WERTV8_TR	CURR	15	2	Delta Nominal Value of Underlying in Underlying Currency
123	D_BNOMBW1	☐	D_BNOMBW_AS	WERTV8_TR	CURR	15	2	Delta Nominal Value Outgoing Side in Crcy of Outgoing Side
124	D_BNOMBW2	☐	D_BNOMBW_ES	WERTV8_TR	CURR	15	2	Delta Nominal Value Incoming Side in Crcy of Incoming Side
125	.INCLUDE	☐				0	0	Key Figures for Position Trend List
126	CALC_CCY	☐	AFW_EVAL_CURRENCY	WAERS	CUKY	5	0	Evaluation Currency	TCURC
127	BNOMI_AS_A	☐	FTI_NOM_AUSGS_A	WERTV8	CURR	15	2	Nominal amount of outgoing side in outgoing PC - start
128	BNOMI_AS_E	☐	FTI_NOM_AUSGS_E	WERTV8	CURR	15	2	Nominal amount of outgoing side in outgoing PC - end
129	BNOMI_ES_A	☐	FTI_NOM_EINGS_A	WERTV8	CURR	15	2	Nominal amount of incoming side in incoming PC - start
130	BNOMI_ES_E	☐	FTI_NOM_EINGS_E	WERTV8	CURR	15	2	Nominal amount of incoming side in incoming PC - end
131	BNOMI_UNDERLYING_A	☐	FTI_NOM_UNDERLYING_A	WERTV8	CURR	15	2	Nominal Amount of Underlying in Crcy of Underlying: Start
132	BNOMI_UNDERLYING_E	☐	FTI_NOM_UNDERLYING_E	WERTV8	CURR	15	2	Nominal Amount of Underlying in Crcy of Underlying: End
133	BOPRAKTWR_A	☐	FTI_AKT_OPR_A	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in PC - start
134	BOPRAKTWR_E	☐	FTI_AKT_OPR_E	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in PC - end
135	BOPRAKTHW_A	☐	FTI_AKT_OPR_HW_A	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in LC - start
136	BOPRAKTHW_E	☐	FTI_AKT_OPR_HW_E	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in LC - end
137	BOPRPASWR_A	☐	FTI_PAS_OPR_A	WERTV8_TR	CURR	15	2	Liability: Option premium (borrowing/sale) in PC - start
138	BOPRPASWR_E	☐	FTI_PAS_OPR_E	WERTV8_TR	CURR	15	2	Liability: Option premium (borrowing/sale) in PC - end
139	BOPRPASHW_A	☐	FTI_PAS_OPR_HW_A	WERTV8_TR	CURR	15	2	Liability: Option premium (borrowing/sale) in LC - start
140	BOPRPASHW_E	☐	FTI_PAS_OPR_HW_E	WERTV8_TR	CURR	15	2	Liability: Option premium (borrowing/sale) in LC - end
141	BOPRWR_A	☐	FTI_OPR_A	WERTV8_TR	CURR	15	2	Option premium affecting income in PC/TC - start
142	BOPRWR_E	☐	FTI_OPR_E	WERTV8_TR	CURR	15	2	Option premium affecting income in PC(TC) - end
143	BOPRHW_A	☐	FTI_OPR_HW_A	WERTV8_TR	CURR	15	2	Option premium affecting income in local currency - start
144	BOPRHW_E	☐	FTI_OPR_HW_E	WERTV8_TR	CURR	15	2	Option premium affecting income in local currency - end
145	BEW_PAS_OPR_A	☐	FTI_BEW_PAS_OPR_A	WERTV8_TR	CURR	15	2	Liability: Option Premium Eval. (Borr./Sale) PC/TC - Start
146	BEW_PAS_OPR_E	☐	FTI_BEW_PAS_OPR_E	WERTV8_TR	CURR	15	2	Liability: Option Premium Eval. (Borr./Sale) in PC/TC - End
147	BEW_PAS_OPR_HW_A	☐	FTI_BEW_PAS_OPR_HW_A	WERTV8_TR	CURR	15	2	Liability: Option Premium Eval. (Borrow/Sale) in LC - Start
148	BEW_PAS_OPR_HW_E	☐	FTI_BEW_PAS_OPR_HW_E	WERTV8_TR	CURR	15	2	Liability: Option Premium Eval. (Borrowing/Sale) in LC - End
149	FXBEW_PAS_OPR_HW_A	☐	FTI_FXBEW_PAS_OPR_HW_A	WERTV8_TR	CURR	15	2	Evaluation Forex of Option Premium (Liability) in LC Start
150	FXBEW_PAS_OPR_HW_E	☐	FTI_FXBEW_PAS_OPR_HW_E	WERTV8_TR	CURR	15	2	Evaluation Forex of Option Premium (Liability) in LC End
151	BEW_AKT_OPR_A	☐	FTI_BEW_AKT_OPR_A	WERTV8_TR	CURR	15	2	Asset: Opt. Premium Evaluation (Inv./Purc.) in PC/TC Start
152	BEW_AKT_OPR_E	☐	FTI_BEW_AKT_OPR_E	WERTV8_TR	CURR	15	2	Asset: Opt. Premium Evaluation (Inv./Purc.) in PC/TC End
153	BEW_AKT_OPR_HW_A	☐	FTI_BEW_AKT_OPR_HW_A	WERTV8_TR	CURR	15	2	Asset: Opt. Premium Evaluation (Invest./Purc.) in LC Start
154	BEW_AKT_OPR_HW_E	☐	FTI_BEW_AKT_OPR_HW_E	WERTV8_TR	CURR	15	2	Asset: Opt. Premium Evaluation (Investment/Purc.) in LC End
155	FXBEW_AKT_OPR_HW_A	☐	FTI_FXBEW_AKT_OPR_HW_A	WERTV8_TR	CURR	15	2	Evaluation Forex of Capitalized Option Premium in LC Start
156	FXBEW_AKT_OPR_HW_E	☐	FTI_FXBEW_AKT_OPR_HW_E	WERTV8_TR	CURR	15	2	Evaluation Forex of Capitalized Option Premium in LC End
157	NPV_PC_A	☐	FTI_NPV_PC_A	WERTV8_TR	CURR	15	2	RM NPV in Position Currency: Start
158	NPV_PC_E	☐	FTI_NPV_PC_E	WERTV8_TR	CURR	15	2	RM NPV in Position Currency: End
159	NPV_CC_A	☐	FTI_NPV_CC_A	WERTV8_TR	CURR	15	2	RM Net Present Value in Valuation Currency Start
160	NPV_CC_E	☐	FTI_NPV_CC_E	WERTV8_TR	CURR	15	2	RM Net Present Value in Valuation Currency End
161	NPV_LONG_PC_A	☐	FTI_NPV_LONG_PC_A	WERTV8_TR	CURR	15	2	RM NPV Incoming Side in Currency Incoming Side Start
162	NPV_LONG_PC_E	☐	FTI_NPV_LONG_PC_E	WERTV8_TR	CURR	15	2	RM NPV Incoming Side in Currency Incoming Side End
163	NPV_SHORT_PC_A	☐	FTI_NPV_SHORT_PC_A	WERTV8_TR	CURR	15	2	RM NPV Outgoing Side in Currency Outgoing Side Start
164	NPV_SHORT_PC_E	☐	FTI_NPV_SHORT_PC_E	WERTV8_TR	CURR	15	2	RM NPV Outgoing Side in Currency Outgoing Side End
165	NPV_LONG_CC_A	☐	FTI_NPV_LONG_CC_A	WERTV8_TR	CURR	15	2	RM Net Present Value Incoming Side in Val. Currency Start
166	NPV_LONG_CC_E	☐	FTI_NPV_LONG_CC_E	WERTV8_TR	CURR	15	2	RM Net Present Value Incoming Side in Val. Currency End
167	NPV_SHORT_CC_A	☐	FTI_NPV_SHORT_CC_A	WERTV8_TR	CURR	15	2	RM NPV Outgoing Side in Valuation Currency Start
168	NPV_SHORT_CC_E	☐	FTI_NPV_SHORT_CC_E	WERTV8_TR	CURR	15	2	RM NPV Outgoing Side in Valuation Currency End
169	CLEAN_PRICE_PC_A	☐	FTI_CLEAN_PRICE_PC_A	WERTV8_TR	CURR	15	2	Clean Price in Position Currency: Start
170	CLEAN_PRICE_PC_E	☐	FTI_CLEAN_PRICE_PC_E	WERTV8_TR	CURR	15	2	Clean Price in Position Currency: End
171	CLEAN_PRICE_CC_A	☐	FTI_CLEAN_PRICE_CC_A	WERTV8_TR	CURR	15	2	Clean Price in Valuation Currency - Start
172	CLEAN_PRICE_CC_E	☐	FTI_CLEAN_PRICE_CC_E	WERTV8_TR	CURR	15	2	Clean Price in Evaluation Currency End
173	BPVALUE_PC_A	☐	FTI_VALBP_PC_A	WERTV8_TR	CURR	15	2	Basis Point Value in Position Currency: Start
174	BPVALUE_PC_E	☐	FTI_VALBP_PC_E	WERTV8_TR	CURR	15	2	Basis Point Value in Position Currency: End
175	BPVALUE_CC_A	☐	FTI_VALBP_CC_A	WERTV8_TR	CURR	15	2	Basis Point Value in Valuation Currency Start
176	BPVALUE_CC_E	☐	FTI_VALBP_CC_E	WERTV8_TR	CURR	15	2	Basis Point Value in Valuation Currency End
177	MAC_DURATION_A	☐	FTI_MAC_DURATION_A	DEC9_3	DEC	12	3	Macaulay Duration: Start
178	MAC_DURATION_E	☐	FTI_MAC_DURATION_E	DEC9_3	DEC	12	3	Macaulay Duration: End
179	MOD_DURATION_A	☐	FTI_MOD_DURATION_A	DEC9_3	DEC	12	3	Modified Duration: Start
180	MOD_DURATION_E	☐	FTI_MOD_DURATION_E	DEC9_3	DEC	12	3	Modified Duration: End
181	STUECKE_A	☐	FTI_STUECKE_A	ASTUECK	DEC	15	5	Number of units / Number of transactions - start
182	STUECKE_E	☐	FTI_STUECKE_E	ASTUECK	DEC	15	5	No. of units/No. of transactions - end
183	.INCLUDE	☐				0	0	Display Currency Fields Cumulative Values Treasury
184	BZBETR_AW	☐	FTI_CASWCW	WERTV8	CURR	15	2	Payment Amount of Flow in Display Crcy (from Pmnt Crcy)
185	BHWBETR_AW	☐	FTI_CASWHW	WERTV8	CURR	15	2	Payment amount of flow in display currency from local curr.
186	EHBETR_AW	☐	EHBETR_AW	WERTV8_TR	CURR	15	2	Profit/loss amount in display currency from local currency
187	EEBETR_AW	☐	EEBETR_AW	WERTV8_TR	CURR	15	2	Profit/Loss Amount in DC (from P/L Currency)
188	PABGERFPL_AW	☐	FTI_PABGERFPLW_AW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in DC (from P/L Currency)
189	PABGERFHW_AW	☐	FTI_PABGERFHW_AW	WERTV8_TR	CURR	15	2	Revenue accrued/deferred in display currency (local curr.)
190	D_AKTBWBW_AW	☐	FTI_D_AKTBWBW_AW	WERTV8_TR	CURR	15	2	Asset: Change in book value in display currency
191	D_AKTBWHW_AW	☐	FTI_D_AKTBWHW_AW	WERTV8_TR	CURR	15	2	Asset: Change in book value in disp. curr. from local curr.
192	D_PASBWBW_AW	☐	FTI_D_PASBWBW_AW	WERTV8_TR	CURR	15	2	Liability: Change in book value in display currency
193	D_PASBWHW_AW	☐	FTI_D_PASBWHW_AW	WERTV8_TR	CURR	15	2	Liability: Change in book val. in disp.curr.from local curr.
194	D_BNOMBW_AW	☐	FTI_D_BNOMUNDERLYING_UW_AW	WERTV8_TR	CURR	15	2	Delta Nominal Value of Underlying in Display Currency
195	D_BNOMBW1_AW	☐	FTI_D_BNOMBW_AS_AW	WERTV8_TR	CURR	15	2	Delta Nominal Value Outgoing Side in Display Currency
196	D_BNOMBW2_AW	☐	FTI_D_BNOMBW_ES_AW	WERTV8_TR	CURR	15	2	Delta Nominal Value Incoming Side in Display Currency
197	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
198	BNOMI_AS_A_AW	☐	FTI_NOM_AUSGS_A_AW	WERTV8	CURR	15	2	Nominal amount of outgoing side in DC - start
199	BNOMI_AS_E_AW	☐	FTI_NOM_AUSGS_E_AW	WERTV8	CURR	15	2	Nominal amount of outgoing side in DC - end
200	BNOMI_ES_A_AW	☐	FTI_NOM_EINGS_A_AW	WERTV8	CURR	15	2	Nominal amount of incoming side in display currency - start
201	BNOMI_ES_E_AW	☐	FTI_NOM_EINGS_E_AW	WERTV8	CURR	15	2	Nominal amount of incoming side in display currency - end
202	BNOMI_UNDERLYING_A_AW	☐	FTI_NOM_UNDERLYING_A_AW	WERTV8	CURR	15	2	Nominal Amount of Underlying in Display Currency: Start
203	BNOMI_UNDERLYING_E_AW	☐	FTI_NOM_UNDERLYING_E_AW	WERTV8	CURR	15	2	Nominal Amount of Underlying in Display Currency: End
204	BOPRAKTWR_A_AW	☐	FTI_AKT_OPR_A_AW	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in DC - start
205	BOPRAKTWR_E_AW	☐	FTI_AKT_OPR_E_AW	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in DC - end
206	BOPRAKTHW_A_AW	☐	FTI_AKT_OPR_HW_A_AW	WERTV8_TR	CURR	15	2	Asset: Option premium (invest./purchase) in DC(LC)- start
207	BOPRAKTHW_E_AW	☐	FTI_AKT_OPR_HW_E_AW	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in DC(LC) - end
208	BOPRPASWR_A_AW	☐	FTI_PAS_OPR_A_AW	WERTV8_TR	CURR	15	2	Liability: Option premium (investment/purchase) in DC- start
209	BOPRPASWR_E_AW	☐	FTI_PAS_OPR_E_AW	WERTV8_TR	CURR	15	2	Liability: Option premium (investment/purchase) in DC - end
210	BOPRPASHW_A_AW	☐	FTI_PAS_OPR_HW_A_AW	WERTV8_TR	CURR	15	2	Liability: Option premium (invest./purch.) in DC(LC) - start
211	BOPRPASHW_E_AW	☐	FTI_PAS_OPR_HW_E_AW	WERTV8_TR	CURR	15	2	Liability: Option premium (invest./purch.) in DC(LC) - end
212	BOPRWR_A_AW	☐	FTI_OPR_A_AW		CURR	15	2	Option premium affecting income in DC(PC) - start
213	BOPRWR_E_AW	☐	FTI_OPR_E_AW		CURR	15	2	Option premium affecting income in DC(PC) - end
214	BOPRHW_A_AW	☐	FTI_OPR_HW_A_AW		CURR	15	2	Option premium affecting income in DC(LC) - start
215	BOPRHW_E_AW	☐	FTI_OPR_HW_E_AW		CURR	15	2	Option premium affecting income in DC(LC) - end
216	NPV_PC_A_AW	☐	FTI_NPV_PC_A_AW	WERTV8_TR	CURR	15	2	RM NPV in Display Currency: Start
217	NPV_PC_E_AW	☐	FTI_NPV_PC_E_AW	WERTV8_TR	CURR	15	2	RM NPV in Display Currency: End
218	CLEAN_PRICE_PC_A_AW	☐	FTI_CLEAN_PRICE_AW_A	WERTV8_TR	CURR	15	2	Clean Price in Display Currency: Start
219	CLEAN_PRICE_PC_E_AW	☐	FTI_CLEAN_PRICE_AW_E	WERTV8_TR	CURR	15	2	Clean Price in Display Currency: End
220	BPVALUE_PC_A_AW	☐	FTI_VALBP_AW_A	WERTV8_TR	CURR	15	2	Basis Point Value in Display Currency: Start
221	BPVALUE_PC_E_AW	☐	FTI_VALBP_AW_E	WERTV8_TR	CURR	15	2	Basis Point Value in Display Currency: End
222	.INCLUDE	☐				0	0	Additional Treasury Selections
223	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	T242Q
224	NUMBR_LC	☐	FTI_NUMBR_LC	CFNUMBR	NUMC	3	0	Translation Type for Currency Translation into Local Crcy	T242Q
225	KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	TW56
226	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
227	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	TWX1
228	CASHF	☐	SCASHFLOW	XFELD	CHAR	1	0	Indicator for cash flow calculation up to end of term
229	BILST	☐	FTI_BILST	DATUM	DATS	8	0	Reference Date
230	BILST2	☐	FTI_BILST2	DATUM	DATS	8	0	Reference Date
231	BILST_REF_B	☐	FTI_BILST_REF_B	FTI_BILST_REF_B	CHAR	1	0	Positions: Remaining Term/Overdue Period Based On
232	BILST_REF_F	☐	FTI_BILST_REF_F	FTI_BILST_REF_F	CHAR	1	0	Flows: Remaining Term/Overdue Period Based On
233	STORNO	☐	FTI_STORNO	XFELD	CHAR	1	0	Evaluate Reversed Flows
234	AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	JBREVAL
235	FLG_SE	☐	FTI_LDB_FLG_SE	XFELD	CHAR	1	0	Product Group Securities: Yes/No
236	FLG_LO	☐	FTI_LDB_FLG_LO	XFELD	CHAR	1	0	Product Group Loans: Yes/No
237	FLG_OTC	☐	FTI_LDB_FLG_OTC	XFELD	CHAR	1	0	Product Group OTC (MM, FX, DE): Yes/No
238	FLG_LOF	☐	FTI_LDB_FLG_LOF	XFELD	CHAR	1	0	Product Group Listed Derivatives (Futures): Yes/No
239	FLG_COUPLING_SECACCGRP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
240	FLG_HISTORIC_ACCASSREF	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
241	FLG_CONDENSE	☐	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
242	FLG_NO_NULL	☐	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
243	FLG_EXCLUDING_PLAN	☐	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
244	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	ANZGW	TCURC	WAERS
2	VTVDETA_DR	AUSWT	JBREVAL	AUSWERTUNG
3	VTVDETA_DR	BUKRS	T001	BUKRS
4	VTVDETA_DR	CALC_CCY	TCURC	WAERS
5	VTVDETA_DR	CNTRY_COMP	T005	LAND1
6	VTVDETA_DR	GROUP_D	TP13	GROUP_D
7	VTVDETA_DR	GROUP_ID	TB001	BU_GROUP
8	VTVDETA_DR	GSART	TZPA	GSART
9	VTVDETA_DR	IND_SECTOR	TB038A	IND_SECTOR
10	VTVDETA_DR	ISTYPE	TB038	ISTYPE
11	VTVDETA_DR	KURSA	TW56	SKURSART
12	VTVDETA_DR	LAND1	T005	LAND1
13	VTVDETA_DR	LEGAL_ENTY	TB019	LEGAL_ENTY
14	VTVDETA_DR	LEGAL_ORG	TB032	LEGAL_ORG
15	VTVDETA_DR	MANDT	T000	MANDT
16	VTVDETA_DR	NATION	T005	LAND1
17	VTVDETA_DR	NUMBR	T242Q	NUMBR
18	VTVDETA_DR	NUMBR_LC	T242Q	NUMBR
19	VTVDETA_DR	PARTNR	BUT000	PARTNER
20	VTVDETA_DR	PERIV	T009	PERIV
21	VTVDETA_DR	PRKEY	PAYRQ	KEYNO		C	CN
22	VTVDETA_DR	RAHABKI	T012	HBKID
23	VTVDETA_DR	RAHKTID	T012K	HKTID
24	VTVDETA_DR	RATING	TP06	RATING
25	VTVDETA_DR	RDEALER	TZDEA	RDEALER
26	VTVDETA_DR	RFHA	VTBFHA	RFHA
27	VTVDETA_DR	RGARANT	BUT000	PARTNER		C	CN
28	VTVDETA_DR	RMAID	VTBMA	RMAID		C	CN
29	VTVDETA_DR	RPORTB	TWPOB	RPORTB
30	VTVDETA_DR	RPZAHL	BUT000	PARTNER
31	VTVDETA_DR	RREFKONT	T037S	RREFKONT
32	VTVDETA_DR	SANLF	TZAF	SANLF
33	VTVDETA_DR	SBEWART	TZB0A	SBEWART
34	VTVDETA_DR	SBWHR	TCURC	WAERS		C	CN
35	VTVDETA_DR	SFGTYP	AT01	SFGTYP
36	VTVDETA_DR	SFGZUSTT	AT02	SFGZUSTT
37	VTVDETA_DR	SFHAART	AT10	SFHAART
38	VTVDETA_DR	SOL_INS	TP07	SOL_INS
39	VTVDETA_DR	SPLWHR	TCURC	WAERS
40	VTVDETA_DR	STAFF_GRP	TP05	STAFF_GRP
41	VTVDETA_DR	STATE	T005	LAND1
42	VTVDETA_DR	SUWHR	TCURC	WAERS		C	CN
43	VTVDETA_DR	VVRANLWI	TWX1	VVRANLWI
44	VTVDETA_DR	WAERS	TCURC	WAERS
45	VTVDETA_DR	WGSCHFT3	TCURC	WAERS		C	CN
46	VTVDETA_DR	WGSCHFT4	TCURC	WAERS		C	CN
47	VTVDETA_DR	WZBETR	TCURC	WAERS
48	VTVDETA_DR	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20131127
SAP Release Created in