VTVBARW_DR_BOE SAP (Derivatives (Listed Transactions): For a Given Date) Structure details
Description: Derivatives (Listed Transactions): For a Given Date
Related tables to VTVBARW_DR_BOE
Access table VTVBARW_DR_BOE
Structure field list including key, data, relationships and ABAP select examples
VTVBARW_DR_BOE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Derivatives (Listed Transactions): For a Given Date" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VTVBARW_DR_BOE TYPE VTVBARW_DR_BOE.
The VTVBARW_DR_BOE table consists of various fields, each holding specific information or linking keys about Derivatives (Listed Transactions): For a Given Date data available in SAP. These include MANDT (Client), BUKRS (Company Code), RPORTB (Portfolio), WAERS (Currency Key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP VTVBARW_DR_BOE structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RPORTB | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
POSITION_ACCOUNT | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | CHAR | 10 | TRFT_POS_ACCOUNT | TPM_POS_ACCOUNT_FUT | TRF_PAC | TRFC_F4_POS_ACCOUNT | |
RANL | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
RLOT | Single position number for TR position management | TPM_RLOT | NUMC | 10 | TPM_RLOT | ||||
SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | T037S | USTRU | KRE | ||
PARTNR | Partner with Whom Commitment Exists | FTI_LDB_RISK_COUNTERPARTY | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BUPA | |
TYPE | Business Partner Category | BP_TYPE_NEW | CHAR | 1 | BU_TYPE | ||||
ISTYPE | Industry System | BU_ISTYPE | CHAR | 4 | TB038 | BU_ISTYPE | |||
IND_SECTOR | Industry | BU_IND_SECTOR | CHAR | 10 | TB038A | BU_INDSECTOR | |||
CNTRY_COMP | Country of Registered Office of Business Partner | FTI_LANDBP | CHAR | 3 | T005 | LAND1 | |||
LEGAL_ENTY | Legal Form of Organization | BP_LEG_ETY_NEW | CHAR | 2 | TB019 | BU_LEGENTY | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG_NEW | CHAR | 2 | TB032 | BU_LEGAL_ORG | |||
NATION | Nationality | BP_CNTR_N | CHAR | 3 | T005 | LAND1 | |||
STATE | Citizenship | BP_CNTR_ST | CHAR | 3 | T005 | LAND1 | |||
GROUP_ID | Business Partner Grouping | BU_GRP_ID_NEW | CHAR | 4 | TB001 | BU_GROUP | BPP | ||
GROUP_D | Target Group | BP_GROUP_D | CHAR | 4 | TP13 | BP_GROUP_D | |||
STAFF_GRP | Employee Group | BP_STAFF_G | CHAR | 4 | TP05 | BP_STAFF_G | |||
COMP_RE | Organization Relationship | BP_COMP_RE | CHAR | 1 | BP_COMP_RE | ||||
GRADE | Valuation | FTI_BP_GRADE | CHAR | 10 | TPZ22 | BP_GRADE | |||
GRADE_METHOD | Valuation Procedure | FTI_BP_GRADE_METHOD | CHAR | 10 | TPZ21 | BP_GRADE_METHOD | |||
SOLVNCY | Credit Standing | BP_SOLVNCY | CHAR | 1 | BP_SOLVNCY | ||||
SOL_INF | Status of Credit Standing Information | BP_SOL_INF | CHAR | 1 | BP_SOL_INF | ||||
SOL_I_D | Date of Credit Standing Information | BP_SOL_I_D | DATS | 8 | DATUM | ||||
RATING | Rating | FTI_BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
SOL_INS | Institute providing credit standing information | FTI_BP_SOL_INS | CHAR | 4 | Assigned to domain | BP_SOL_INS | |||
STICHTAG | Key date | VVSTDAT | DATS | 8 | VVSTDAT | KEYDATE | |||
RSTICH | Key date reference | RSTICH | CHAR | 1 | RSTICH | ||||
SLOTCATEGORY | Long/short ID for single position | TPM_SLOTCATEGORY | CHAR | 1 | TPM_SLOTCATEGORY | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
SNOTTYPE | Quotation type for option, future, security etc. | TB_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
REWHR | Issue currency | REWHR | CUKY | 5 | TCURC | WAERS | |||
LAND1 | Country key of company code | FTI_LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
SBWHR | Position Currency/Transaction Currency | TB_BWHR | CUKY | 5 | TCURC | WAERS | |||
SBWHRUL | Position currency of underlying | SBWHRUL | CUKY | 5 | TCURC | WAERS | |||
WWTICK | Tick Value Currency | TI_WWTICK | CUKY | 5 | TCURC | WAERS | |||
RLZTG | Remaining Term in Days | FTI_RLZTG | NUMC | 5 | NUMC5 | ||||
RLZMO | Remaining Term in Months | FTI_RLZMO | NUMC | 4 | NUMC4 | ||||
RLZJA | Remaining Term in Years | FTI_RLZJA | NUMC | 3 | NUMC3 | ||||
UEBTG | Overdue Period in Days | FTI_UEBTG | NUMC | 5 | NUMC5 | ||||
UEBMO | Overdue Period in Months | FTI_UEBMO | NUMC | 3 | NUMC3 | ||||
UEBJA | Overdue Period in Years | FTI_UEBJA | NUMC | 2 | NUMC2 | ||||
RLZTG_K | Remaining Term in Days (Key Figure) | FTI_RLZTGK | DEC | 7 | DEC7 | ||||
UEBTG_K | Overdue Period in Days (Key Figure) | FTI_UEBTGK | DEC | 7 | DEC7 | ||||
KURSABS | Price of a unit-quoted security in quotation currency | VVKURSABS | DEC | 15(6) | VVPKTKUR | ||||
TICK | Tick in percentage points | TI_PPTICK | DEC | 10(7) | DECV3_7 | ||||
TICKVALUE | Tick value | TI_BWTICK | CURR | 13(2) | WERTV7 | ||||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
ASTUECK_LONG | Number of units - long | ASTUECK_LONG | DEC | 15(5) | ASTUECK | ||||
ASTUECK_SHORT | Number of units - short | ASTUECK_SHORT | DEC | 15(5) | ASTUECK | ||||
BNOMINAL_UL | Total nominal amount of underlying in underl. pos. currency | BNOMINAL_UL | CURR | 15(2) | WERTV8_TR | ||||
BNOMINAL_LONG | Total nominal amount of underlying - long (UL pos. currency) | BNOMINAL_LONG | CURR | 15(2) | WERTV8_TR | ||||
BNOMINAL_SHORT | Total nominal amount of underlying - short (UL pos.currency) | BNOMINAL_SHORT | CURR | 15(2) | WERTV8_TR | ||||
BKAUFWR_UL | Acquisition value of underlying in underlying pos. currency | BKAUFWR_UL | CURR | 15(2) | WERTV8_TR | ||||
BKAUFWR_LONG | Acquisition value of underlying - long (UL pos. currency) | B_AQ_VAL_FOREIGN_LONG | CURR | 15(2) | WERTV8_TR | ||||
BKAUFWR_SHORT | Acquisition value of underlying - short (UL pos. currency) | B_AQ_VAL_FOREIGN_SHORT | CURR | 15(2) | WERTV8_TR | ||||
BKAUFHW_UL | Acquisition value of underlying in local currency | BKAUFHW_UL | CURR | 15(2) | WERTV8_TR | ||||
BKAUFHW_LONG | Acquisition value of underlying - long (local currency) | B_AQ_VAL_LOCAL_LONG | CURR | 15(2) | WERTV8_TR | ||||
BKAUFHW_SHORT | Acquisition value of underlying - short (local currency) | B_AQ_VAL_LOCAL_SHORT | CURR | 15(2) | WERTV8_TR | ||||
BBUCHWR_UL | Book value of underlying in underlying position currency | BBUCHWR_UL | CURR | 15(2) | WERTV8_TR | ||||
BBUCHWR_LONG | Book value of underlying - long (underlying pos. currency) | BBUCHWR_LONG | CURR | 15(2) | WERTV8_TR | ||||
BBUCHWR_SHORT | Book value of underlying - short (underlying pos. currency) | BBUCHWR_SHORT | CURR | 15(2) | WERTV8_TR | ||||
BBUCHHW_UL | Book value of underlying in local currency | BBUCHHW_UL | CURR | 15(2) | WERTV8_TR | ||||
BBUCHHW_LONG | Book value of underlying - long (local currency) | BBUCHHW_LONG | CURR | 15(2) | WERTV8_TR | ||||
BBUCHHW_SHORT | Book value of underlying - short (local currency) | BBUCHHW_SHORT | CURR | 15(2) | WERTV8_TR | ||||
VAMA_LONG_BW | Accumulated variation margin - long (position currency) | B_VAMA_LONG_BW | CURR | 15(2) | WERTV8_TR | ||||
VAMA_SHORT_BW | Accumulated variation margin - short (position currency) | B_VAMA_SHORT_BW | CURR | 15(2) | WERTV8_TR | ||||
VAMA_HW_LONG | Accumulated variation margin - long (local currency) | B_VAMA_LONG_HW | CURR | 15(2) | WERTV8_TR | ||||
VAMA_HW_SHORT | Accumulated variation margin - short (local currency) | B_VAMA_SHORT_HW | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEFW_LONG | Current market value of underlying - long (UL posit. curr.) | TB_BKURSWR_LONG | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEFW_SHORT | Current market value of underlying - short (UL posit. curr.) | TB_BKURSWR_SHORT | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEHW_LONG | Current market value of underlying - long (local currency) | TB_BKURSHW_LONG | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEHW_SHORT | Current market value of underlying - short (local currency) | TB_BKURSHW_SHORT | CURR | 15(2) | WERTV8_TR | ||||
NPV_PC | RM Net Present Value in Position Currency | TV_NPV_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_LONG_PC | RM NPV of Incoming Side in Currency of Incoming Side | TV_NPV_LONG_PC | CURR | 15(2) | WERTV8_TR | ||||
NPV_SHORT_PC | RM NPV of Outgoing Side in Currency of Outgoing Side | TV_NPV_SHORT_PC | CURR | 15(2) | WERTV8_TR | ||||
CLEAN_PRICE_PC | Clean Price in Position Currency | TV_CLEAN_PRICE_PC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_PC | Basis Point Value in Position Currency | TV_VALBP_PC | CURR | 17(2) | T_PRESVAL | ||||
MAC_DURATION | Macaulay Duration | TV_MAC_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
MOD_DURATION | Fisher/Weil Duration | TV_FISHER_WEIL_DURATION | DEC | 12(3) | DEC9_3SIGN | ||||
CONVEXITY | 100*Convexity (With 5 Decimal Places) | FTI_CONVEXITY_MUL | DEC | 11(5) | DEC6_5 | ||||
DELTA | 100*Delta, 1st Underlying Price Derivative of Premium | FTI_DELTA_MUL | DEC | 15(10) | T_SENSI | ||||
GAMMA | 100*Gamma, 2nd Underlying Price Derivative of Premium | FTI_GAMMA_MUL | DEC | 14(8) | T_GAMMA | ||||
THETA | 100*Theta, 1st Time Derivative of Premium | FTI_THETA_MUL | DEC | 15(10) | T_SENSI | ||||
VEGA | 100*Vega, 1st Volatility Derivative | FTI_VEGA_MUL | DEC | 15(10) | T_SENSI | ||||
ANZGW | Display Currency | FTI_ANZGW | CUKY | 5 | TCURC | WAERS | FFZ | ||
TICKVALUE_AW | Tick value in display currency | FTI_BWTICK_AW | CURR | 13(2) | WERTV7 | ||||
BNOMINAL_UL_AW | Total Nominal Amount of Underlying in DC (UL Position Crcy) | FTI_BNOMINAL_AW | CURR | 15(2) | WERTV8_TR | ||||
BNOMINAL_LONG_AW | Total nominal amount of underlying - long DC (UL pos. curr.) | FTI_BNOMINAL_LONG_AW | CURR | 15(2) | WERTV8_TR | ||||
BNOMINAL_SHORT_AW | Total nominal amount of underlying - short DC(UL pos. curr.) | FTI_BNOMINAL_SHORT_AW | CURR | 15(2) | WERTV8_TR | ||||
BKAUFWR_UL_AW | Acquisition Value of UL in DC from Postion Currency of UL | FTI_BKAUFWR_UL_AW | CURR | 15(2) | WERTV8_TR | ||||
BKAUFWR_LONG_AW | Acquisition value of underlying - long DC(UL position curr.) | FTI_AQ_VAL_FOREIGN_LONG_AW | CURR | 15(2) | WERTV8_TR | ||||
BKAUFWR_SHORT_AW | Acquisition value of underlying - short DC (UL pos. curr.) | FTI_AQ_VAL_FOREIGN_SHORT_AW | CURR | 15(2) | WERTV8_TR | ||||
BKAUFHW_UL_AW | Acquisition Value of Underlying in Display Currency from LC | FTI_BKAUFHW_UL_AW | CURR | 15(2) | WERTV8_TR | ||||
BKAUFHW_LONG_AW | Acquisition value of underlying - long DC (local currency) | FTI_AQ_VAL_LOCAL_LONG_AW | CURR | 15(2) | WERTV8_TR | ||||
BKAUFHW_SHORT_AW | Acquisition value of underlying - short DC (local currency) | FTI_AQ_VAL_LOCAL_SHORT_AW | CURR | 15(2) | WERTV8_TR | ||||
BBUCHWR_UL_AW | Book Value of Underlying in Display Currency (Underlying PC) | FTI_BBUCHWR_UL_AW | CURR | 15(2) | WERTV8_TR | ||||
BBUCHWR_LONG_AW | Book value of underlying - long DC (UL position currency) | FTI_BBUCHWR_LONG_AW | CURR | 15(2) | WERTV8_TR | ||||
BBUCHWR_SHORT_AW | Book value of underlying - short DC (UL position currency) | FTI_BBUCHWR_SHORT_AW | CURR | 15(2) | WERTV8_TR | ||||
BBUCHHW_UL_AW | Book Value of Underlying in Display Currency (Local Crcy) | FTI_BBUCHHW_UL_AW | CURR | 15(2) | WERTV8_TR | ||||
BBUCHHW_LONG_AW | Book value of underlying - long DC (local currency) | FTI_BBUCHHW_LONG_AW | CURR | 15(2) | WERTV8_TR | ||||
BBUCHHW_SHORT_AW | Book value of underlying - short DC (local currency) | FTI_BBUCHHW_SHORT_AW | CURR | 15(2) | WERTV8_TR | ||||
VAMA_LONG_BW_AW | Accumulated variation margin - long DC (position currency) | FTI_VAMA_LONG_BW_AW | CURR | 15(2) | WERTV8_TR | ||||
VAMA_SHORT_BW_AW | Accumulated variation margin - short DC (position currency) | FTI_VAMA_SHORT_BW_AW | CURR | 15(2) | WERTV8_TR | ||||
VAMA_HW_LONG_AW | Accumulated variation margin - long DC (local currency) | FTI_VAMA_LONG_HW_AW | CURR | 15(2) | WERTV8_TR | ||||
VAMA_HW_SHORT_AW | Accumulated variation margin - short DC (local currency) | FTI_VAMA_SHORT_HW_AW | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEFW_LONG_AW | Current market value of underlying -long in DC(UL pos.curr.) | FTI_BKURSWR_LONG_AW | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEFW_SHORT_AW | Current market value of underlying -short DC (UL pos. curr.) | FTI_BKURSWR_SHORT_AW | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEHW_LONG_AW | Current market value of underlying - long in DC(local curr.) | FTI_BKURSHW_LONG_AW | CURR | 15(2) | WERTV8_TR | ||||
BKURSWEHW_SHORT_AW | Current market value of underlying -short in DC(local curr.) | FTI_BKURSHW_SHORT_AW | CURR | 15(2) | WERTV8_TR | ||||
NPV_PC_AW | RM NPV in Display Currency | FTI_NPV_PC | CURR | 23(2) | |||||
NPV_LONG_PC_AW | RM NPV Incoming Side in Display Currency Incoming Side | FTI_NPV_LONG_PC | CURR | 23(2) | |||||
NPV_SHORT_PC_AW | RM NPV Outgoing Side in Display Currency Outgoing Side | FTI_NPV_SHORT_PC | CURR | 23(2) | |||||
CLEAN_PRICE_PC_AW | Clean Price in Position Currency | FTI_CLEAN_PRICE_PC | CURR | 17(2) | T_PRESVAL | ||||
BPVALUE_PC_AW | Basis Point Value in Display Currency | FTI_VALBP_PC | CURR | 17(2) | T_PRESVAL | ||||
NUMBR | Number of translation key in currency translation | CFNUMBR | NUMC | 3 | T242Q | CFNUMBR | NBR | ||
NUMBR_LC | Translation Type for Currency Translation into Local Crcy | FTI_NUMBR_LC | NUMC | 3 | T242Q | CFNUMBR | NBR_LC | ||
KURSA | Price type for evaluations | VVKURSAUSW | CHAR | 2 | TW56 | VVSKURSART | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
VVRANLWI | No. of the secondary index description for class data | VVRANLWI | NUMC | 2 | TWX1 | VVRANLWI | |||
CASHF | Indicator for cash flow calculation up to end of term | SCASHFLOW | CHAR | 1 | XFELD | ||||
BILST | Reference Date | FTI_BILST | DATS | 8 | DATUM | ||||
BILST2 | Reference Date | FTI_BILST2 | DATS | 8 | DATUM | ||||
BILST_REF_B | Positions: Remaining Term/Overdue Period Based On | FTI_BILST_REF_B | CHAR | 1 | FTI_BILST_REF_B | FTI_BILST_REF_POS | |||
BILST_REF_F | Flows: Remaining Term/Overdue Period Based On | FTI_BILST_REF_F | CHAR | 1 | FTI_BILST_REF_F | FTI_BILST_REF_FLOWS | |||
STORNO | Evaluate Reversed Flows | FTI_STORNO | CHAR | 1 | XFELD | ||||
AUSWT | Evaluation Type (Risk Management) | FTI_EVALTYPE | CHAR | 4 | JBREVAL | JBREVAL | FTI_EVALTYPE | ||
FLG_SE | Product Group Securities: Yes/No | FTI_LDB_FLG_SE | CHAR | 1 | XFELD | FTI_FLG_SE | |||
FLG_LO | Product Group Loans: Yes/No | FTI_LDB_FLG_LO | CHAR | 1 | XFELD | FTI_FLG_LO | |||
FLG_OTC | Product Group OTC (MM, FX, DE): Yes/No | FTI_LDB_FLG_OTC | CHAR | 1 | XFELD | FTI_FLG_OTC | |||
FLG_LOF | Product Group Listed Derivatives (Futures): Yes/No | FTI_LDB_FLG_LOF | CHAR | 1 | XFELD | FTI_FLG_LOF | |||
FLG_COUPLING_SECACCGRP | Interpret Assignment of Sec. Account to Sec. Account Group | FTI_LDB_FLG_COUPLING_SECACCGRP | CHAR | 1 | XFELD | FTI_FLG_SECACCGRP | |||
FLG_HISTORIC_ACCASSREF | Indicator: Historical Account Assignment Reference | FTI_LDB_FLG_HISTORIC_ACCASSREF | CHAR | 1 | XFELD | FTI_FLG_HISTKR | |||
FLG_CONDENSE | Summarize Results (for Query) | FTI_CONDENSE | CHAR | 1 | XFELD | FTI_CONDENSE_ID | |||
FLG_NO_NULL | Hide Zero Records | FTI_NO_NULL | CHAR | 1 | XFELD | FTI_NO_NULL_ID | |||
FLG_EXCLUDING_PLAN | Exclude Plan Data (for Query) | FTI_EXCL_PLAN | CHAR | 1 | XFELD | FTI_CONDENSE_ID | |||
FLG_REVERSED_FLOWS | Process Reversed Flows (for Query) | FTI_REVERSED_FLOWS | CHAR | 1 | XFELD | FTI_CONDENSE_ID |
Key field | Non-key field |
How do I retrieve data from SAP structure VTVBARW_DR_BOE using ABAP code?
As VTVBARW_DR_BOE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VTVBARW_DR_BOE as there is no data to select.How to access SAP table VTVBARW_DR_BOE
Within an ECC or HANA version of SAP you can also view further information about VTVBARW_DR_BOE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects