SAP ABAP Table VTVBARW_DR_OTC (Derivatives (OTC): 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_DR_OTC	Table Relationship Diagram
Short Description	Derivatives (OTC): 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	Derivative OTC Interest Rate Instruments: Trans./Act. Char.
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	.INCLUDE	☐				0	0	Treasury: Commitment Partner
25	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
26	.INCLUDE	☐				0	0	Treasury: Partner Attributes
27	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
28	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
29	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
30	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
31	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
32	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
33	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
34	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
35	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
36	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
37	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
38	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
39	.INCLUDE	☐				0	0	Business partner credit standing data
40	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
41	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
42	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
43	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
44	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
45	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
46	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
47	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
48	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
49	SUWHR	☐	SUWHR	WAERS	CUKY	5	0	Underlying currency	TCURC
50	WGSCHFT1	☐	FTI_WGSCH1	WAERS	CUKY	5	0	Currency borrowing/sale	TCURC
51	WGSCHFT2	☐	FTI_WGSCH2	WAERS	CUKY	5	0	Currency investment/purchase	TCURC
52	CALC_CCY	☐	AFW_EVAL_CURRENCY	WAERS	CUKY	5	0	Evaluation Currency	TCURC
53	RLZTG	☐	FTI_RLZTG	NUMC5	NUMC	5	0	Remaining Term in Days
54	RLZMO	☐	FTI_RLZMO	NUMC4	NUMC	4	0	Remaining Term in Months
55	RLZJA	☐	FTI_RLZJA	NUMC3	NUMC	3	0	Remaining Term in Years
56	UEBTG	☐	FTI_UEBTG	NUMC5	NUMC	5	0	Overdue Period in Days
57	UEBMO	☐	FTI_UEBMO	NUMC3	NUMC	3	0	Overdue Period in Months
58	UEBJA	☐	FTI_UEBJA	NUMC2	NUMC	2	0	Overdue Period in Years
59	XFORMEL_AS	☐	FTI_XFORMEL_AS	T_XTEXT30	CHAR	30	0	Formula for variable interest condition - outgoing side
60	XFORMEL_ES	☐	FTI_XFORMEL_ES	T_XTEXT30	CHAR	30	0	Formula for variable interest condition - incoming side
61	XFORMEL	☐	FTI_XFORMEL	T_XTEXT30	CHAR	30	0	Variable int. condition formula for non-swap transactions
62	RLZTG_K	☐	FTI_RLZTGK	DEC7	DEC	7	0	Remaining Term in Days (Key Figure)
63	UEBTG_K	☐	FTI_UEBTGK	DEC7	DEC	7	0	Overdue Period in Days (Key Figure)
64	BNOMI_AS	☐	FTI_NOM_AUSGS	WERTV8	CURR	15	2	Nominal Amount Outgoing Side in Position Crcy (Outg. Side)
65	BNOMI_ES	☐	FTI_NOM_EINGS	WERTV8	CURR	15	2	Nominal Amount Incoming Side in Position Crcy (Inc. Side)
66	BNOMI_UNDERLYING	☐	FTI_NOM_UNDERLYING	WERTV8	CURR	15	2	Nominal amount of underlying in currency of underlying
67	BSZINS_AS	☐	FTI_BSUMZINS_AUSGS	WERTV8_TR	CURR	15	2	Total interest - outgoing side (outgoing position currency)
68	BSZINS_ES	☐	FTI_BSUMZINS_EINGS	WERTV8_TR	CURR	15	2	Total interest - incoming side (incoming position currency)
69	BSZINS	☐	FTI_BSUMZINS	WERTV8_TR	CURR	15	2	Total interest in PC/TC for non-swap transactions
70	BOPRPASWR	☐	FTI_PAS_OPR	WERTV8_TR	CURR	15	2	Liability: Option premium (borrowing/sale) in PC/TC
71	BOPRPASHW	☐	FTI_PAS_OPR_HW	WERTV8_TR	CURR	15	2	Liability: Option premium (borrowing/sale) in local currency
72	BOPRAKTWR	☐	FTI_AKT_OPR	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in PC/TC
73	BOPRAKTHW	☐	FTI_AKT_OPR_HW	WERTV8_TR	CURR	15	2	Asset: Option premium (investment/purchase) in LC
74	BOPRWR	☐	FTI_OPR	WERTV8_TR	CURR	15	2	Non-Balance Sheet Option Premium in PC/TC
75	BOPRHW	☐	FTI_OPR_HW	WERTV8_TR	CURR	15	2	Non-Balance Sheet Option Premium in LC
76	NPV_PC	☐	TV_NPV_PC	WERTV8_TR	CURR	15	2	RM Net Present Value in Position Currency
77	NPV_LONG_PC	☐	TV_NPV_LONG_PC	WERTV8_TR	CURR	15	2	RM NPV of Incoming Side in Currency of Incoming Side
78	NPV_SHORT_PC	☐	TV_NPV_SHORT_PC	WERTV8_TR	CURR	15	2	RM NPV of Outgoing Side in Currency of Outgoing Side
79	CLEAN_PRICE_PC	☐	TV_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
80	BPVALUE_PC	☐	TV_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Position Currency
81	NPV_CC	☐	TV_NPV_CC	WERTV8_TR	CURR	15	2	RM NPV in Evaluation Currency
82	NPV_LONG_CC	☐	TV_NPV_LONG_CC	WERTV8_TR	CURR	15	2	RM NPV of Incoming Side in Evaluation Currency
83	NPV_SHORT_CC	☐	TV_NPV_SHORT_CC	WERTV8_TR	CURR	15	2	RM NPV of Outgoing Side in Evaluation Currency
84	CLEAN_PRICE_CC	☐	FTI_CLEAN_PRICE_CC	T_PRESVAL	CURR	17	2	Clean Price in Valuation Currency
85	BPVALUE_CC	☐	TV_VALBP	T_PRESVAL	CURR	17	2	Basis Point Value in Evaluation Currency
86	MAC_DURATION	☐	TV_MAC_DURATION	DEC9_3SIGN	DEC	12	3	Macaulay Duration
87	MOD_DURATION	☐	TV_MOD_DURATION	DEC9_3SIGN	DEC	12	3	Fisher-Weil Duration
88	CONVEXITY	☐	FTI_CONVEXITY_MUL	DEC6_5	DEC	11	5	100*Convexity (With 5 Decimal Places)
89	DELTA	☐	FTI_DELTA_MUL	T_SENSI	DEC	15	10	100*Delta, 1st Underlying Price Derivative of Premium
90	GAMMA	☐	FTI_GAMMA_MUL	T_GAMMA	DEC	14	8	100*Gamma, 2nd Underlying Price Derivative of Premium
91	THETA	☐	FTI_THETA_MUL	T_SENSI	DEC	15	10	100*Theta, 1st Time Derivative of Premium
92	VEGA	☐	FTI_VEGA_MUL	T_SENSI	DEC	15	10	100*Vega, 1st Volatility Derivative
93	BEW_PAS_OPR	☐	FTI_BEW_PAS_OPR	WERTV8_TR	CURR	15	2	Liability: Option Premium Eval. (Borrowing/Sale) in PC/TC
94	BEW_PAS_OPR_HW	☐	FTI_BEW_PAS_OPR_HW	WERTV8_TR	CURR	15	2	Liability: Option Premium Evaluation (Borrowing/Sale) in LC
95	FXBEW_PAS_OPR_HW	☐	FTI_FXBEW_PAS_OPR_HW	WERTV8_TR	CURR	15	2	Evaluation Forex of Option Premium (Liability) in LC
96	BEW_AKT_OPR	☐	FTI_BEW_AKT_OPR	WERTV8_TR	CURR	15	2	Asset: Option Premium Evaluation (Invest./Purc.) in PC/TC
97	BEW_AKT_OPR_HW	☐	FTI_BEW_AKT_OPR_HW	WERTV8_TR	CURR	15	2	Asset: Opt. Premium Evaluation (Investment/Purchase) in LC
98	FXBEW_AKT_OPR_HW	☐	FTI_FXBEW_AKT_OPR_HW	WERTV8_TR	CURR	15	2	Evaluation Forex of Capitalized Option Premium in LC
99	PZINSFEST_AS	☐	FTI_ZINSFEST_AS	DECV3_7	DEC	10	7	Fixed-interest condition - outgoing side
100	PZINSFEST_ES	☐	FTI_ZINSFEST_ES	DECV3_7	DEC	10	7	Fixed-interest condition - incoming side
101	PZINSFEST	☐	FTI_ZINSFEST	DECV3_7	DEC	10	7	Fixed interest condition - non-swap transactions
102	PZINSFIX_AS	☐	FTI_ZINSFIX_AS	DECV3_7	DEC	10	7	Fixed Interest Rate for Variable Condition Outgoing Side
103	PZINSFIX_ES	☐	FTI_ZINSFIX_ES	DECV3_7	DEC	10	7	Fixed Interest Rate for Variable Condition Incoming Side
104	PZINSFIX	☐	FTI_ZINSFIX	DECV3_7	DEC	10	7	Fixed Int. Rate for Variable Condition Non-Swap Transactions
105	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
106	BNOMI_AS_AW	☐	FTI_NOM_AUSGS_AW	WERTV8	CURR	15	2	Nominal Amount Outgoing Side in Display Currency
107	BNOMI_ES_AW	☐	FTI_NOM_EINGS_AW	WERTV8	CURR	15	2	Nominal Amount Incoming Side in Display Currency
108	BNOMI_UNDERLYING_AW	☐	FTI_NOM_UNDERLYING_AW	WERTV8	CURR	15	2	Nominal amount of underlying in display currency
109	BSZINS_AS_AW	☐	FTI_BSUMZINS_AUSGS_AW	WERTV8_TR	CURR	15	2	Total interest - outgoing side (display currency)
110	BSZINS_ES_AW	☐	FTI_BSUMZINS_EINGS_AW	WERTV8_TR	CURR	15	2	Total interest - incoming side (display currency)
111	BSZINS_AW	☐	FTI_BSUMZINS_AW	WERTV8_TR	CURR	15	2	Total interest for non-swap transactions in display currency
112	BOPRPASWR_AW	☐	FTI_PAS_OPR_AW	WERTV8_TR	CURR	15	2	Liability: Option premium (borrowing/sale) in display curr.
113	BOPRPASHW_AW	☐	FTI_PAS_OPR_HW_AW	WERTV8_TR	CURR	15	2	Liability: Option premium (borrowing/sale) in DC(LC)
114	BOPRAKTWR_AW	☐	FTI_AKT_OPR_AW	WERTV8_TR	CURR	15	2	Asset: Option premium (borrowing/sale) in DC
115	BOPRAKTHW_AW	☐	FTI_AKT_OPR_HW_AW	WERTV8_TR	CURR	15	2	Asset: Option premium (borrowing/sale) in DC(LC)
116	BOPRWR_AW	☐	FTI_OPR_AW	WERTV8_TR	CURR	15	2	Off-Balance Sheet Option Premium in Display Currency
117	BOPRHW_AW	☐	FTI_OPR_HW_AW	WERTV8_TR	CURR	15	2	Off-Balance Sheet Option Premium in Display Currency (LC)
118	NPV_PC_AW	☐	FTI_NPV_PC		CURR	23	2	RM NPV in Display Currency
119	NPV_LONG_PC_AW	☐	FTI_NPV_LONG_PC		CURR	23	2	RM NPV Incoming Side in Display Currency Incoming Side
120	NPV_SHORT_PC_AW	☐	FTI_NPV_SHORT_PC		CURR	23	2	RM NPV Outgoing Side in Display Currency Outgoing Side
121	CLEAN_PRICE_PC_AW	☐	FTI_CLEAN_PRICE_PC	T_PRESVAL	CURR	17	2	Clean Price in Position Currency
122	BPVALUE_PC_AW	☐	FTI_VALBP_PC	T_PRESVAL	CURR	17	2	Basis Point Value in Display Currency
123	STUECKE	☐	FTI_STUECKE	ASTUECK	DEC	15	5	Number of units / Number of transactions
124	.INCLUDE	☐				0	0	Additional Treasury Selections
125	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	T242Q
126	NUMBR_LC	☐	FTI_NUMBR_LC	CFNUMBR	NUMC	3	0	Translation Type for Currency Translation into Local Crcy	T242Q
127	KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	TW56
128	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
129	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	TWX1
130	CASHF	☐	SCASHFLOW	XFELD	CHAR	1	0	Indicator for cash flow calculation up to end of term
131	BILST	☐	FTI_BILST	DATUM	DATS	8	0	Reference Date
132	BILST2	☐	FTI_BILST2	DATUM	DATS	8	0	Reference Date
133	BILST_REF_B	☐	FTI_BILST_REF_B	FTI_BILST_REF_B	CHAR	1	0	Positions: Remaining Term/Overdue Period Based On
134	BILST_REF_F	☐	FTI_BILST_REF_F	FTI_BILST_REF_F	CHAR	1	0	Flows: Remaining Term/Overdue Period Based On
135	STORNO	☐	FTI_STORNO	XFELD	CHAR	1	0	Evaluate Reversed Flows
136	AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	JBREVAL
137	FLG_SE	☐	FTI_LDB_FLG_SE	XFELD	CHAR	1	0	Product Group Securities: Yes/No
138	FLG_LO	☐	FTI_LDB_FLG_LO	XFELD	CHAR	1	0	Product Group Loans: Yes/No
139	FLG_OTC	☐	FTI_LDB_FLG_OTC	XFELD	CHAR	1	0	Product Group OTC (MM, FX, DE): Yes/No
140	FLG_LOF	☐	FTI_LDB_FLG_LOF	XFELD	CHAR	1	0	Product Group Listed Derivatives (Futures): Yes/No
141	FLG_COUPLING_SECACCGRP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
142	FLG_HISTORIC_ACCASSREF	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
143	FLG_CONDENSE	☐	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
144	FLG_NO_NULL	☐	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
145	FLG_EXCLUDING_PLAN	☐	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
146	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_DR_OTC	ANZGW	TCURC	WAERS
2	VTVBARW_DR_OTC	AUSWT	JBREVAL	AUSWERTUNG
3	VTVBARW_DR_OTC	BUKRS	T001	BUKRS		C	CN
4	VTVBARW_DR_OTC	CALC_CCY	TCURC	WAERS
5	VTVBARW_DR_OTC	CNTRY_COMP	T005	LAND1
6	VTVBARW_DR_OTC	GROUP_D	TP13	GROUP_D
7	VTVBARW_DR_OTC	GROUP_ID	TB001	BU_GROUP
8	VTVBARW_DR_OTC	GSART	TZPA	GSART
9	VTVBARW_DR_OTC	IND_SECTOR	TB038A	IND_SECTOR
10	VTVBARW_DR_OTC	ISTYPE	TB038	ISTYPE
11	VTVBARW_DR_OTC	KURSA	TW56	SKURSART
12	VTVBARW_DR_OTC	LAND1	T005	LAND1
13	VTVBARW_DR_OTC	LEGAL_ENTY	TB019	LEGAL_ENTY
14	VTVBARW_DR_OTC	LEGAL_ORG	TB032	LEGAL_ORG
15	VTVBARW_DR_OTC	MANDT	T000	MANDT		C	CN
16	VTVBARW_DR_OTC	NATION	T005	LAND1
17	VTVBARW_DR_OTC	NUMBR	T242Q	NUMBR
18	VTVBARW_DR_OTC	NUMBR_LC	T242Q	NUMBR
19	VTVBARW_DR_OTC	PARTNR	BUT000	PARTNER
20	VTVBARW_DR_OTC	PERIV	T009	PERIV
21	VTVBARW_DR_OTC	RATING	TP06	RATING
22	VTVBARW_DR_OTC	RDEALER	TZDEA	RDEALER
23	VTVBARW_DR_OTC	RFHA	VTBFHA	RFHA
24	VTVBARW_DR_OTC	RPORTB	TWPOB	RPORTB		C	CN
25	VTVBARW_DR_OTC	RREFKONT	T037S	RREFKONT		1	CN
26	VTVBARW_DR_OTC	SANLF	TZAF	SANLF		1	CN
27	VTVBARW_DR_OTC	SBWHR	TCURC	WAERS		C	CN
28	VTVBARW_DR_OTC	SFGTYP	AT01	SFGTYP
29	VTVBARW_DR_OTC	SFGZUSTT	AT02	SFGZUSTT
30	VTVBARW_DR_OTC	SFHAART	AT10	SFHAART
31	VTVBARW_DR_OTC	SOL_INS	TP07	SOL_INS
32	VTVBARW_DR_OTC	STAFF_GRP	TP05	STAFF_GRP
33	VTVBARW_DR_OTC	STATE	T005	LAND1
34	VTVBARW_DR_OTC	SUWHR	TCURC	WAERS		C	CN
35	VTVBARW_DR_OTC	VVRANLWI	TWX1	VVRANLWI
36	VTVBARW_DR_OTC	WAERS	TCURC	WAERS
37	VTVBARW_DR_OTC	WGSCHFT1	TCURC	WAERS
38	VTVBARW_DR_OTC	WGSCHFT2	TCURC	WAERS

History

Last changed by/on	SAP	20131127
SAP Release Created in