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
⤷ 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
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |