SAP ABAP Table VTVBARW_DR_BOE (Derivatives (Listed Transactions): 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_BOE   Table Relationship Diagram
Short Description Derivatives (Listed Transactions): 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   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 STICHTAG VVSTDAT VVSTDAT DATS 8   0   Key date  
36 RSTICH RSTICH RSTICH CHAR 1   0   Key date reference  
37 SLOTCATEGORY TPM_SLOTCATEGORY TPM_SLOTCATEGORY CHAR 1   0   Long/short ID for single position  
38 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account SKB1
39 SNOTTYPE TB_NOTTYPE T_NOTTYPE CHAR 1   0   Quotation type for option, future, security etc.  
40 DELFZ DELFZ DATUM DATS 8   0   End of Term  
41 REWHR REWHR WAERS CUKY 5   0   Issue currency TCURC
42 LAND1 FTI_LAND1 LAND1 CHAR 3   0   Country key of company code T005
43 SBWHR TB_BWHR WAERS CUKY 5   0   Position Currency/Transaction Currency TCURC
44 SBWHRUL SBWHRUL WAERS CUKY 5   0   Position currency of underlying TCURC
45 WWTICK TI_WWTICK WAERS CUKY 5   0   Tick Value Currency TCURC
46 RLZTG FTI_RLZTG NUMC5 NUMC 5   0   Remaining Term in Days  
47 RLZMO FTI_RLZMO NUMC4 NUMC 4   0   Remaining Term in Months  
48 RLZJA FTI_RLZJA NUMC3 NUMC 3   0   Remaining Term in Years  
49 UEBTG FTI_UEBTG NUMC5 NUMC 5   0   Overdue Period in Days  
50 UEBMO FTI_UEBMO NUMC3 NUMC 3   0   Overdue Period in Months  
51 UEBJA FTI_UEBJA NUMC2 NUMC 2   0   Overdue Period in Years  
52 RLZTG_K FTI_RLZTGK DEC7 DEC 7   0   Remaining Term in Days (Key Figure)  
53 UEBTG_K FTI_UEBTGK DEC7 DEC 7   0   Overdue Period in Days (Key Figure)  
54 KURSABS VVKURSABS VVPKTKUR DEC 15   6   Price of a unit-quoted security in quotation currency  
55 TICK TI_PPTICK DECV3_7 DEC 10   7   Tick in percentage points  
56 TICKVALUE TI_BWTICK WERTV7 CURR 13   2   Tick value  
57 ASTUECK ASTUECK ASTUECK DEC 15   5   Number of units for unit-quoted securities  
58 ASTUECK_LONG ASTUECK_LONG ASTUECK DEC 15   5   Number of units - long  
59 ASTUECK_SHORT ASTUECK_SHORT ASTUECK DEC 15   5   Number of units - short  
60 BNOMINAL_UL BNOMINAL_UL WERTV8_TR CURR 15   2   Total nominal amount of underlying in underl. pos. currency  
61 BNOMINAL_LONG BNOMINAL_LONG WERTV8_TR CURR 15   2   Total nominal amount of underlying - long (UL pos. currency)  
62 BNOMINAL_SHORT BNOMINAL_SHORT WERTV8_TR CURR 15   2   Total nominal amount of underlying - short (UL pos.currency)  
63 BKAUFWR_UL BKAUFWR_UL WERTV8_TR CURR 15   2   Acquisition value of underlying in underlying pos. currency  
64 BKAUFWR_LONG B_AQ_VAL_FOREIGN_LONG WERTV8_TR CURR 15   2   Acquisition value of underlying - long (UL pos. currency)  
65 BKAUFWR_SHORT B_AQ_VAL_FOREIGN_SHORT WERTV8_TR CURR 15   2   Acquisition value of underlying - short (UL pos. currency)  
66 BKAUFHW_UL BKAUFHW_UL WERTV8_TR CURR 15   2   Acquisition value of underlying in local currency  
67 BKAUFHW_LONG B_AQ_VAL_LOCAL_LONG WERTV8_TR CURR 15   2   Acquisition value of underlying - long (local currency)  
68 BKAUFHW_SHORT B_AQ_VAL_LOCAL_SHORT WERTV8_TR CURR 15   2   Acquisition value of underlying - short (local currency)  
69 BBUCHWR_UL BBUCHWR_UL WERTV8_TR CURR 15   2   Book value of underlying in underlying position currency  
70 BBUCHWR_LONG BBUCHWR_LONG WERTV8_TR CURR 15   2   Book value of underlying - long (underlying pos. currency)  
71 BBUCHWR_SHORT BBUCHWR_SHORT WERTV8_TR CURR 15   2   Book value of underlying - short (underlying pos. currency)  
72 BBUCHHW_UL BBUCHHW_UL WERTV8_TR CURR 15   2   Book value of underlying in local currency  
73 BBUCHHW_LONG BBUCHHW_LONG WERTV8_TR CURR 15   2   Book value of underlying - long (local currency)  
74 BBUCHHW_SHORT BBUCHHW_SHORT WERTV8_TR CURR 15   2   Book value of underlying - short (local currency)  
75 VAMA_LONG_BW B_VAMA_LONG_BW WERTV8_TR CURR 15   2   Accumulated variation margin - long (position currency)  
76 VAMA_SHORT_BW B_VAMA_SHORT_BW WERTV8_TR CURR 15   2   Accumulated variation margin - short (position currency)  
77 VAMA_HW_LONG B_VAMA_LONG_HW WERTV8_TR CURR 15   2   Accumulated variation margin - long (local currency)  
78 VAMA_HW_SHORT B_VAMA_SHORT_HW WERTV8_TR CURR 15   2   Accumulated variation margin - short (local currency)  
79 BKURSWEFW_LONG TB_BKURSWR_LONG WERTV8_TR CURR 15   2   Current market value of underlying - long (UL posit. curr.)  
80 BKURSWEFW_SHORT TB_BKURSWR_SHORT WERTV8_TR CURR 15   2   Current market value of underlying - short (UL posit. curr.)  
81 BKURSWEHW_LONG TB_BKURSHW_LONG WERTV8_TR CURR 15   2   Current market value of underlying - long (local currency)  
82 BKURSWEHW_SHORT TB_BKURSHW_SHORT WERTV8_TR CURR 15   2   Current market value of underlying - short (local currency)  
83 NPV_PC TV_NPV_PC WERTV8_TR CURR 15   2   RM Net Present Value in Position Currency  
84 NPV_LONG_PC TV_NPV_LONG_PC WERTV8_TR CURR 15   2   RM NPV of Incoming Side in Currency of Incoming Side  
85 NPV_SHORT_PC TV_NPV_SHORT_PC WERTV8_TR CURR 15   2   RM NPV of Outgoing Side in Currency of Outgoing Side  
86 CLEAN_PRICE_PC TV_CLEAN_PRICE_PC T_PRESVAL CURR 17   2   Clean Price in Position Currency  
87 BPVALUE_PC TV_VALBP_PC T_PRESVAL CURR 17   2   Basis Point Value in Position Currency  
88 MAC_DURATION TV_MAC_DURATION DEC9_3SIGN DEC 12   3   Macaulay Duration  
89 MOD_DURATION TV_MOD_DURATION DEC9_3SIGN DEC 12   3   Fisher-Weil Duration  
90 CONVEXITY FTI_CONVEXITY_MUL DEC6_5 DEC 11   5   100*Convexity (With 5 Decimal Places)  
91 DELTA FTI_DELTA_MUL T_SENSI DEC 15   10   100*Delta, 1st Underlying Price Derivative of Premium  
92 GAMMA FTI_GAMMA_MUL T_GAMMA DEC 14   8   100*Gamma, 2nd Underlying Price Derivative of Premium  
93 THETA FTI_THETA_MUL T_SENSI DEC 15   10   100*Theta, 1st Time Derivative of Premium  
94 VEGA FTI_VEGA_MUL T_SENSI DEC 15   10   100*Vega, 1st Volatility Derivative  
95 ANZGW FTI_ANZGW WAERS CUKY 5   0   Display Currency TCURC
96 TICKVALUE_AW FTI_BWTICK_AW WERTV7 CURR 13   2   Tick value in display currency  
97 BNOMINAL_UL_AW FTI_BNOMINAL_AW WERTV8_TR CURR 15   2   Total Nominal Amount of Underlying in DC (UL Position Crcy)  
98 BNOMINAL_LONG_AW FTI_BNOMINAL_LONG_AW WERTV8_TR CURR 15   2   Total nominal amount of underlying - long DC (UL pos. curr.)  
99 BNOMINAL_SHORT_AW FTI_BNOMINAL_SHORT_AW WERTV8_TR CURR 15   2   Total nominal amount of underlying - short DC(UL pos. curr.)  
100 BKAUFWR_UL_AW FTI_BKAUFWR_UL_AW WERTV8_TR CURR 15   2   Acquisition Value of UL in DC from Postion Currency of UL  
101 BKAUFWR_LONG_AW FTI_AQ_VAL_FOREIGN_LONG_AW WERTV8_TR CURR 15   2   Acquisition value of underlying - long DC(UL position curr.)  
102 BKAUFWR_SHORT_AW FTI_AQ_VAL_FOREIGN_SHORT_AW WERTV8_TR CURR 15   2   Acquisition value of underlying - short DC (UL pos. curr.)  
103 BKAUFHW_UL_AW FTI_BKAUFHW_UL_AW WERTV8_TR CURR 15   2   Acquisition Value of Underlying in Display Currency from LC  
104 BKAUFHW_LONG_AW FTI_AQ_VAL_LOCAL_LONG_AW WERTV8_TR CURR 15   2   Acquisition value of underlying - long DC (local currency)  
105 BKAUFHW_SHORT_AW FTI_AQ_VAL_LOCAL_SHORT_AW WERTV8_TR CURR 15   2   Acquisition value of underlying - short DC (local currency)  
106 BBUCHWR_UL_AW FTI_BBUCHWR_UL_AW WERTV8_TR CURR 15   2   Book Value of Underlying in Display Currency (Underlying PC)  
107 BBUCHWR_LONG_AW FTI_BBUCHWR_LONG_AW WERTV8_TR CURR 15   2   Book value of underlying - long DC (UL position currency)  
108 BBUCHWR_SHORT_AW FTI_BBUCHWR_SHORT_AW WERTV8_TR CURR 15   2   Book value of underlying - short DC (UL position currency)  
109 BBUCHHW_UL_AW FTI_BBUCHHW_UL_AW WERTV8_TR CURR 15   2   Book Value of Underlying in Display Currency (Local Crcy)  
110 BBUCHHW_LONG_AW FTI_BBUCHHW_LONG_AW WERTV8_TR CURR 15   2   Book value of underlying - long DC (local currency)  
111 BBUCHHW_SHORT_AW FTI_BBUCHHW_SHORT_AW WERTV8_TR CURR 15   2   Book value of underlying - short DC (local currency)  
112 VAMA_LONG_BW_AW FTI_VAMA_LONG_BW_AW WERTV8_TR CURR 15   2   Accumulated variation margin - long DC (position currency)  
113 VAMA_SHORT_BW_AW FTI_VAMA_SHORT_BW_AW WERTV8_TR CURR 15   2   Accumulated variation margin - short DC (position currency)  
114 VAMA_HW_LONG_AW FTI_VAMA_LONG_HW_AW WERTV8_TR CURR 15   2   Accumulated variation margin - long DC (local currency)  
115 VAMA_HW_SHORT_AW FTI_VAMA_SHORT_HW_AW WERTV8_TR CURR 15   2   Accumulated variation margin - short DC (local currency)  
116 BKURSWEFW_LONG_AW FTI_BKURSWR_LONG_AW WERTV8_TR CURR 15   2   Current market value of underlying -long in DC(UL pos.curr.)  
117 BKURSWEFW_SHORT_AW FTI_BKURSWR_SHORT_AW WERTV8_TR CURR 15   2   Current market value of underlying -short DC (UL pos. curr.)  
118 BKURSWEHW_LONG_AW FTI_BKURSHW_LONG_AW WERTV8_TR CURR 15   2   Current market value of underlying - long in DC(local curr.)  
119 BKURSWEHW_SHORT_AW FTI_BKURSHW_SHORT_AW WERTV8_TR CURR 15   2   Current market value of underlying -short in DC(local curr.)  
120 NPV_PC_AW FTI_NPV_PC   CURR 23   2   RM NPV in Display Currency  
121 NPV_LONG_PC_AW FTI_NPV_LONG_PC   CURR 23   2   RM NPV Incoming Side in Display Currency Incoming Side  
122 NPV_SHORT_PC_AW FTI_NPV_SHORT_PC   CURR 23   2   RM NPV Outgoing Side in Display Currency Outgoing Side  
123 CLEAN_PRICE_PC_AW FTI_CLEAN_PRICE_PC T_PRESVAL CURR 17   2   Clean Price in Position Currency  
124 BPVALUE_PC_AW FTI_VALBP_PC T_PRESVAL CURR 17   2   Basis Point Value in Display Currency  
125 .INCLUDE       0   0   Additional Treasury Selections  
126 NUMBR CFNUMBR CFNUMBR NUMC 3   0   Number of translation key in currency translation T242Q
127 NUMBR_LC FTI_NUMBR_LC CFNUMBR NUMC 3   0   Translation Type for Currency Translation into Local Crcy T242Q
128 KURSA VVKURSAUSW VVSKURSART CHAR 2   0   Price type for evaluations TW56
129 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant T009
130 VVRANLWI VVRANLWI VVRANLWI NUMC 2   0   No. of the secondary index description for class data TWX1
131 CASHF SCASHFLOW XFELD CHAR 1   0   Indicator for cash flow calculation up to end of term  
132 BILST FTI_BILST DATUM DATS 8   0   Reference Date  
133 BILST2 FTI_BILST2 DATUM DATS 8   0   Reference Date  
134 BILST_REF_B FTI_BILST_REF_B FTI_BILST_REF_B CHAR 1   0   Positions: Remaining Term/Overdue Period Based On  
135 BILST_REF_F FTI_BILST_REF_F FTI_BILST_REF_F CHAR 1   0   Flows: Remaining Term/Overdue Period Based On  
136 STORNO FTI_STORNO XFELD CHAR 1   0   Evaluate Reversed Flows  
137 AUSWT FTI_EVALTYPE JBREVAL CHAR 4   0   Evaluation Type (Risk Management) JBREVAL
138 FLG_SE FTI_LDB_FLG_SE XFELD CHAR 1   0   Product Group Securities: Yes/No  
139 FLG_LO FTI_LDB_FLG_LO XFELD CHAR 1   0   Product Group Loans: Yes/No  
140 FLG_OTC FTI_LDB_FLG_OTC XFELD CHAR 1   0   Product Group OTC (MM, FX, DE): Yes/No  
141 FLG_LOF FTI_LDB_FLG_LOF XFELD CHAR 1   0   Product Group Listed Derivatives (Futures): Yes/No  
142 FLG_COUPLING_SECACCGRP FTI_LDB_FLG_COUPLING_SECACCGRP XFELD CHAR 1   0   Interpret Assignment of Sec. Account to Sec. Account Group  
143 FLG_HISTORIC_ACCASSREF FTI_LDB_FLG_HISTORIC_ACCASSREF XFELD CHAR 1   0   Indicator: Historical Account Assignment Reference  
144 FLG_CONDENSE FTI_CONDENSE XFELD CHAR 1   0   Summarize Results (for Query)  
145 FLG_NO_NULL FTI_NO_NULL XFELD CHAR 1   0   Hide Zero Records  
146 FLG_EXCLUDING_PLAN FTI_EXCL_PLAN XFELD CHAR 1   0   Exclude Plan Data (for Query)  
147 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_BOE ANZGW TCURC WAERS    
2 VTVBARW_DR_BOE AUSWT JBREVAL AUSWERTUNG    
3 VTVBARW_DR_BOE BUKRS T001 BUKRS C CN
4 VTVBARW_DR_BOE CNTRY_COMP T005 LAND1    
5 VTVBARW_DR_BOE GROUP_D TP13 GROUP_D    
6 VTVBARW_DR_BOE GROUP_ID TB001 BU_GROUP    
7 VTVBARW_DR_BOE GSART TZPA GSART    
8 VTVBARW_DR_BOE HKONT SKB1 SAKNR    
9 VTVBARW_DR_BOE IND_SECTOR TB038A IND_SECTOR    
10 VTVBARW_DR_BOE ISTYPE TB038 ISTYPE    
11 VTVBARW_DR_BOE KURSA TW56 SKURSART    
12 VTVBARW_DR_BOE LAND1 T005 LAND1    
13 VTVBARW_DR_BOE LEGAL_ENTY TB019 LEGAL_ENTY    
14 VTVBARW_DR_BOE LEGAL_ORG TB032 LEGAL_ORG    
15 VTVBARW_DR_BOE MANDT T000 MANDT C CN
16 VTVBARW_DR_BOE NATION T005 LAND1    
17 VTVBARW_DR_BOE NUMBR T242Q NUMBR    
18 VTVBARW_DR_BOE NUMBR_LC T242Q NUMBR    
19 VTVBARW_DR_BOE PARTNR BUT000 PARTNER    
20 VTVBARW_DR_BOE PERIV T009 PERIV    
21 VTVBARW_DR_BOE POSITION_ACCOUNT TRFT_POS_ACCOUNT POS_ACCOUNT C CN
22 VTVBARW_DR_BOE RANL VWPANLA RANL    
23 VTVBARW_DR_BOE RATING TP06 RATING    
24 VTVBARW_DR_BOE REWHR TCURC WAERS C CN
25 VTVBARW_DR_BOE RPORTB TWPOB RPORTB C CN
26 VTVBARW_DR_BOE RREFKONT T037S RREFKONT    
27 VTVBARW_DR_BOE SANLF TZAF SANLF 1 CN
28 VTVBARW_DR_BOE SBWHR TCURC WAERS C CN
29 VTVBARW_DR_BOE SBWHRUL TCURC WAERS    
30 VTVBARW_DR_BOE SOL_INS TP07 SOL_INS    
31 VTVBARW_DR_BOE STAFF_GRP TP05 STAFF_GRP    
32 VTVBARW_DR_BOE STATE T005 LAND1    
33 VTVBARW_DR_BOE VVRANLWI TWX1 VVRANLWI    
34 VTVBARW_DR_BOE WAERS TCURC WAERS    
35 VTVBARW_DR_BOE WWTICK TCURC WAERS C CN
History
Last changed by/on SAP  20131127 
SAP Release Created in