VTVDETA_DR SAP (Derivatives (OTC): For a Given Period) Structure details
Dictionary Type: Structure
Description: Derivatives (OTC): For a Given Period
Description: Derivatives (OTC): For a Given Period
Structure field list including key, data, relationships and ABAP select examples
VTVDETA_DR 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 (OTC): For a Given Period" 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_VTVDETA_DR TYPE VTVDETA_DR.
The VTVDETA_DR table consists of various fields, each holding specific information or linking keys about Derivatives (OTC): For a Given Period 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: Can be enhanced (character-type or numeric)
SAP VTVDETA_DR 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 | ||||
| RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | VTBFHA | ALPHA | T_RFHA | FAN | VTBA |
| SANLF | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
| GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
| SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3 | AT01 | T_SFGTYP | |||
| SFHAART | Financial Transaction Type | TB_SFHAART | CHAR | 3 | AT10 | T_SFHAART | T02 | C_AT10 | |
| SAKTIV | Active status of financial transaction (drilldown reporting) | FTI_SAKTIV | CHAR | 1 | FTI_SAKTIV | ||||
| RREFKONT | Acct Assignment Ref. for Operative Valn Area and Loan | TB_REFKONT | CHAR | 8 | T037S | USTRU | |||
| FINPROJ | Finance Project | TB_TFPROJ | CHAR | 13 | T_TFPROJ | ||||
| DBLFZ | Start of Term | DBLFZ | DATS | 8 | DATUM | ||||
| DELFZ | End of Term | DELFZ | DATS | 8 | DATUM | ||||
| SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | NUMC | 2 | AT02 | T_SFGZUTY | C_AT02 | ||
| RDEALER | Trader | RDEALER | CHAR | 12 | TZDEA | RDEALER | |||
| NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | FTI_CHAR16LOW | ||||
| ZUOND | Assignment | TB_ZUOND | CHAR | 18 | TEXT18 | ||||
| REFER | Internal Reference | TB_REFER | CHAR | 16 | CHAR16 | ||||
| MERKM | Characteristics | TB_MERKM | CHAR | 25 | CHAR25 | ||||
| SPUTCALL | Put/call indicator | TI_SPUTCAL | NUMC | 1 | T_SPUTCAL | ||||
| RMAID | Master Agreement | TB_RMAID | CHAR | 10 | VTBMA | ALPHA | T_RMAID | TMA | VTMA |
| RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
| 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 | |||
| VONDAT | Start Date of Evaluation | DVONDAT | DATS | 8 | DATUM | ||||
| BISDAT | Date of evaluation end | DBISDAT | DATS | 8 | DATUM | ||||
| RSTICH | Key date reference | RSTICH | CHAR | 1 | RSTICH | ||||
| DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| DGJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| DMONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
| PERIO | Period/year | JAHRPER | NUMC | 7 | PERI7 | JAHRPER | |||
| DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
| RPBANK | Partner bank details | TB_RPBANK | CHAR | 4 | BVTYP | ||||
| RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
| JFDBUC | Relevance to CM | FTI_FDBUC | CHAR | 1 | FTI_FDBUC | ||||
| LAND1 | Country key of company code | FTI_LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
| ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
| BANKK_HB | Bank key of house bank | FTI_BANKK | CHAR | 15 | BANKK | BNK | |||
| BANKN_HB | Bank account number of house bank | FTI_BANKN | CHAR | 18 | BANKN | ||||
| BANKK_BP | Bank key of business partner bank | FTI_BANKKP | CHAR | 15 | BANKK | BNK | |||
| BANKN_BP | Bank account number of business partner | FTI_BANKNP | CHAR | 18 | BANKN | ||||
| SSIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
| JAHR | Calendar year | TB_JAHR | NUMC | 4 | GJAHR | GJAHR | |||
| MONAT | Calendar month | TB_MONAT | NUMC | 2 | TB_MONAT | ||||
| WOCHE | Calendar Week | FTI_WOCHE | NUMC | 2 | NUMC2 | ||||
| MONAT_JAHR | Calendar Month/Year | FTI_MONTH_YEAR | NUMC | 6 | PERI | MCPERIOD | |||
| WOCHE_JAHR | Calendar Week/Year | FTI_WEEK_YEAR | NUMC | 6 | PERI | MCPERIOD | |||
| SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
| SPAYRQ | Generate payment request | TB_SPAYRQK | CHAR | 1 | XFELD | ||||
| PRKEY | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | PAYRQ | ALPHA | PRQ_KEYNO | ||
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
| GL_ACCOUNT_D | Number of G/L Account: Debit | FTI_GLACC_D | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
| GL_ACCOUNT_C | Number of G/L Account: Credit | FTI_GLACC_C | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
| SBEWEBE | Posting Status of Flow | TB_SBEWEBE | CHAR | 1 | T_SBEWEBE | ||||
| SBEWART | Flow Type | SBEWART | CHAR | 4 | TZB0A | SBEWART | |||
| SBFREI | Release Given for Flow to Be Posted? | TB_SBFREI | CHAR | 1 | XFELD | ||||
| RAHABKI | Short key for own house bank | TB_RHABKI | CHAR | 5 | T012 | HBKID | |||
| RAHKTID | Short key for house bank account | TB_RHKTID | CHAR | 5 | T012K | HKTID | |||
| GSTRAT | Business Strategy Combination: Product Type/Trans.Type/PC ID | FTI_GSTRAT | NUMC | 1 | T_SPUTCAL | ||||
| RKONDGR | Direction of Transaction | TB_RKONDGR | NUMC | 1 | T_RKONDGR | ||||
| PAYIND | Payment Status of Flows | TB_SPAYIND | CHAR | 1 | T_SPAYIND | ||||
| SBWHR | Position Currency/Transaction Currency | TB_BWHR | CUKY | 5 | TCURC | WAERS | |||
| SUWHR | Underlying currency | SUWHR | CUKY | 5 | TCURC | WAERS | |||
| WGSCHFT3 | Currency Borr./Sale Start/End | FTI_WGSCH3 | CUKY | 5 | TCURC | WAERS | |||
| WGSCHFT4 | Currency investment/purchase start/end | FTI_WGSCH4 | CUKY | 5 | TCURC | WAERS | |||
| RLZTG_K_F | Remaining Term in Days (Key Figure) | FTI_RLZTGK_F | DEC | 7 | DEC7 | ||||
| UEBTG_K_F | Overdue Period in Days (Key Figure) | FTI_UEBTGK_F | DEC | 7 | DEC7 | ||||
| RLZTG_F | Remaining Term in Days | FTI_RLZTG_F | NUMC | 5 | NUMC5 | ||||
| RLZMO_F | Remaining Term in Months | FTI_RLZMO_F | NUMC | 4 | NUMC4 | ||||
| RLZJA_F | Remaining Term in Years | FTI_RLZJA_F | NUMC | 3 | NUMC3 | ||||
| UEBTG_F | Overdue Period in Days | FTI_UEBTG_F | NUMC | 5 | NUMC5 | ||||
| UEBMO_F | Overdue Period in Months | FTI_UEBMO_F | NUMC | 3 | NUMC3 | ||||
| UEBJA_F | Overdue Period in Years | FTI_UEBJA_F | NUMC | 2 | NUMC2 | ||||
| BZBETR | Payment amount in payment currency | D_CASHCW | CURR | 15(2) | WERTV8_TR | ||||
| BHWBETR | Payment amount in local currency | D_CASHHW | CURR | 15(2) | WERTV8_TR | ||||
| EHBETR | Profit/loss amount in local currency | EHBETR | CURR | 13(2) | WERTV7 | ||||
| EEBETR | Profit/loss amount in profit/loss currency | EEBETR | CURR | 13(2) | WERTV7 | ||||
| PABGERFHW | Revenue Accrued/Deferred in Local Currency | PABGERFHW | CURR | 15(2) | WERTV8_TR | ||||
| PABGERFPL | Revenue Accrued/Deferred in Profit/Loss Currency | PABGERFPLW | CURR | 15(2) | WERTV8_TR | ||||
| WZBETR | Payment Currency | TB_WZBETR | CUKY | 5 | TCURC | WAERS | |||
| SPLWHR | Profit/loss currency | SPLWHR | CUKY | 5 | TCURC | WAERS | |||
| D_AKTBWBW | Asset: Change in book value in position/transaction curr. | D_AKTBWBW | CURR | 15(2) | WERTV8_TR | ||||
| D_AKTBWHW | Asset: Change in book value in local currency | D_AKTBWHW | CURR | 15(2) | WERTV8_TR | ||||
| D_PASBWBW | Liability: Change in book value in position/trans. curr. | D_PASBWBW | CURR | 15(2) | WERTV8_TR | ||||
| D_PASBWHW | Liability: Change in book value in local currency | D_PASBWHW | CURR | 15(2) | WERTV8_TR | ||||
| D_BEW_PAS_OPR | Liability: Delta Eval. Option Premium (Borrow/Sale) in PC/TC | FTI_D_BEW_PAS_OPR | CURR | 15(2) | WERTV8_TR | ||||
| D_BEW_PAS_OPR_HW | Liability: Delta Eval. Option Premium (Borrowing/Sale) in LC | FTI_D_BEW_PAS_OPR_HW | CURR | 15(2) | WERTV8_TR | ||||
| D_FXBEW_PAS_OPR_HW | Delta Evaluation Forex Liability Option Premium in LC | FTI_D_FXBEW_PAS_OPR_HW | CURR | 15(2) | WERTV8_TR | ||||
| D_BEW_AKT_OPR | Asset: Delta Eval. Option Premium (Borrowing/Sale in PC/TC | FTI_D_BEW_AKT_OPR | CURR | 15(2) | WERTV8_TR | ||||
| D_BEW_AKT_OPR_HW | Asset: Delta Eval. Option Premium (Borrowing/Sale) in LC | FTI_D_BEW_AKT_OPR_HW | CURR | 15(2) | WERTV8_TR | ||||
| D_FXBEW_AKT_OPR_HW | Delta Evaluation Forex Capitalized Option Premium in LC | FTI_D_FXBEW_AKT_OPR_HW | CURR | 15(2) | WERTV8_TR | ||||
| D_BNOMBW | Delta Nominal Value of Underlying in Underlying Currency | D_BNOMUNDERLYING_UW | CURR | 15(2) | WERTV8_TR | ||||
| D_BNOMBW1 | Delta Nominal Value Outgoing Side in Crcy of Outgoing Side | D_BNOMBW_AS | CURR | 15(2) | WERTV8_TR | ||||
| D_BNOMBW2 | Delta Nominal Value Incoming Side in Crcy of Incoming Side | D_BNOMBW_ES | CURR | 15(2) | WERTV8_TR | ||||
| CALC_CCY | Evaluation Currency | AFW_EVAL_CURRENCY | CUKY | 5 | TCURC | WAERS | |||
| BNOMI_AS_A | Nominal amount of outgoing side in outgoing PC - start | FTI_NOM_AUSGS_A | CURR | 15(2) | WERTV8 | ||||
| BNOMI_AS_E | Nominal amount of outgoing side in outgoing PC - end | FTI_NOM_AUSGS_E | CURR | 15(2) | WERTV8 | ||||
| BNOMI_ES_A | Nominal amount of incoming side in incoming PC - start | FTI_NOM_EINGS_A | CURR | 15(2) | WERTV8 | ||||
| BNOMI_ES_E | Nominal amount of incoming side in incoming PC - end | FTI_NOM_EINGS_E | CURR | 15(2) | WERTV8 | ||||
| BNOMI_UNDERLYING_A | Nominal Amount of Underlying in Crcy of Underlying: Start | FTI_NOM_UNDERLYING_A | CURR | 15(2) | WERTV8 | ||||
| BNOMI_UNDERLYING_E | Nominal Amount of Underlying in Crcy of Underlying: End | FTI_NOM_UNDERLYING_E | CURR | 15(2) | WERTV8 | ||||
| BOPRAKTWR_A | Asset: Option premium (investment/purchase) in PC - start | FTI_AKT_OPR_A | CURR | 15(2) | WERTV8_TR | ||||
| BOPRAKTWR_E | Asset: Option premium (investment/purchase) in PC - end | FTI_AKT_OPR_E | CURR | 15(2) | WERTV8_TR | ||||
| BOPRAKTHW_A | Asset: Option premium (investment/purchase) in LC - start | FTI_AKT_OPR_HW_A | CURR | 15(2) | WERTV8_TR | ||||
| BOPRAKTHW_E | Asset: Option premium (investment/purchase) in LC - end | FTI_AKT_OPR_HW_E | CURR | 15(2) | WERTV8_TR | ||||
| BOPRPASWR_A | Liability: Option premium (borrowing/sale) in PC - start | FTI_PAS_OPR_A | CURR | 15(2) | WERTV8_TR | ||||
| BOPRPASWR_E | Liability: Option premium (borrowing/sale) in PC - end | FTI_PAS_OPR_E | CURR | 15(2) | WERTV8_TR | ||||
| BOPRPASHW_A | Liability: Option premium (borrowing/sale) in LC - start | FTI_PAS_OPR_HW_A | CURR | 15(2) | WERTV8_TR | ||||
| BOPRPASHW_E | Liability: Option premium (borrowing/sale) in LC - end | FTI_PAS_OPR_HW_E | CURR | 15(2) | WERTV8_TR | ||||
| BOPRWR_A | Option premium affecting income in PC/TC - start | FTI_OPR_A | CURR | 15(2) | WERTV8_TR | ||||
| BOPRWR_E | Option premium affecting income in PC(TC) - end | FTI_OPR_E | CURR | 15(2) | WERTV8_TR | ||||
| BOPRHW_A | Option premium affecting income in local currency - start | FTI_OPR_HW_A | CURR | 15(2) | WERTV8_TR | ||||
| BOPRHW_E | Option premium affecting income in local currency - end | FTI_OPR_HW_E | CURR | 15(2) | WERTV8_TR | ||||
| BEW_PAS_OPR_A | Liability: Option Premium Eval. (Borr./Sale) PC/TC - Start | FTI_BEW_PAS_OPR_A | CURR | 15(2) | WERTV8_TR | ||||
| BEW_PAS_OPR_E | Liability: Option Premium Eval. (Borr./Sale) in PC/TC - End | FTI_BEW_PAS_OPR_E | CURR | 15(2) | WERTV8_TR | ||||
| BEW_PAS_OPR_HW_A | Liability: Option Premium Eval. (Borrow/Sale) in LC - Start | FTI_BEW_PAS_OPR_HW_A | CURR | 15(2) | WERTV8_TR | ||||
| BEW_PAS_OPR_HW_E | Liability: Option Premium Eval. (Borrowing/Sale) in LC - End | FTI_BEW_PAS_OPR_HW_E | CURR | 15(2) | WERTV8_TR | ||||
| FXBEW_PAS_OPR_HW_A | Evaluation Forex of Option Premium (Liability) in LC Start | FTI_FXBEW_PAS_OPR_HW_A | CURR | 15(2) | WERTV8_TR | ||||
| FXBEW_PAS_OPR_HW_E | Evaluation Forex of Option Premium (Liability) in LC End | FTI_FXBEW_PAS_OPR_HW_E | CURR | 15(2) | WERTV8_TR | ||||
| BEW_AKT_OPR_A | Asset: Opt. Premium Evaluation (Inv./Purc.) in PC/TC Start | FTI_BEW_AKT_OPR_A | CURR | 15(2) | WERTV8_TR | ||||
| BEW_AKT_OPR_E | Asset: Opt. Premium Evaluation (Inv./Purc.) in PC/TC End | FTI_BEW_AKT_OPR_E | CURR | 15(2) | WERTV8_TR | ||||
| BEW_AKT_OPR_HW_A | Asset: Opt. Premium Evaluation (Invest./Purc.) in LC Start | FTI_BEW_AKT_OPR_HW_A | CURR | 15(2) | WERTV8_TR | ||||
| BEW_AKT_OPR_HW_E | Asset: Opt. Premium Evaluation (Investment/Purc.) in LC End | FTI_BEW_AKT_OPR_HW_E | CURR | 15(2) | WERTV8_TR | ||||
| FXBEW_AKT_OPR_HW_A | Evaluation Forex of Capitalized Option Premium in LC Start | FTI_FXBEW_AKT_OPR_HW_A | CURR | 15(2) | WERTV8_TR | ||||
| FXBEW_AKT_OPR_HW_E | Evaluation Forex of Capitalized Option Premium in LC End | FTI_FXBEW_AKT_OPR_HW_E | CURR | 15(2) | WERTV8_TR | ||||
| NPV_PC_A | RM NPV in Position Currency: Start | FTI_NPV_PC_A | CURR | 15(2) | WERTV8_TR | ||||
| NPV_PC_E | RM NPV in Position Currency: End | FTI_NPV_PC_E | CURR | 15(2) | WERTV8_TR | ||||
| NPV_CC_A | RM Net Present Value in Valuation Currency Start | FTI_NPV_CC_A | CURR | 15(2) | WERTV8_TR | ||||
| NPV_CC_E | RM Net Present Value in Valuation Currency End | FTI_NPV_CC_E | CURR | 15(2) | WERTV8_TR | ||||
| NPV_LONG_PC_A | RM NPV Incoming Side in Currency Incoming Side Start | FTI_NPV_LONG_PC_A | CURR | 15(2) | WERTV8_TR | ||||
| NPV_LONG_PC_E | RM NPV Incoming Side in Currency Incoming Side End | FTI_NPV_LONG_PC_E | CURR | 15(2) | WERTV8_TR | ||||
| NPV_SHORT_PC_A | RM NPV Outgoing Side in Currency Outgoing Side Start | FTI_NPV_SHORT_PC_A | CURR | 15(2) | WERTV8_TR | ||||
| NPV_SHORT_PC_E | RM NPV Outgoing Side in Currency Outgoing Side End | FTI_NPV_SHORT_PC_E | CURR | 15(2) | WERTV8_TR | ||||
| NPV_LONG_CC_A | RM Net Present Value Incoming Side in Val. Currency Start | FTI_NPV_LONG_CC_A | CURR | 15(2) | WERTV8_TR | ||||
| NPV_LONG_CC_E | RM Net Present Value Incoming Side in Val. Currency End | FTI_NPV_LONG_CC_E | CURR | 15(2) | WERTV8_TR | ||||
| NPV_SHORT_CC_A | RM NPV Outgoing Side in Valuation Currency Start | FTI_NPV_SHORT_CC_A | CURR | 15(2) | WERTV8_TR | ||||
| NPV_SHORT_CC_E | RM NPV Outgoing Side in Valuation Currency End | FTI_NPV_SHORT_CC_E | CURR | 15(2) | WERTV8_TR | ||||
| CLEAN_PRICE_PC_A | Clean Price in Position Currency: Start | FTI_CLEAN_PRICE_PC_A | CURR | 15(2) | WERTV8_TR | ||||
| CLEAN_PRICE_PC_E | Clean Price in Position Currency: End | FTI_CLEAN_PRICE_PC_E | CURR | 15(2) | WERTV8_TR | ||||
| CLEAN_PRICE_CC_A | Clean Price in Valuation Currency - Start | FTI_CLEAN_PRICE_CC_A | CURR | 15(2) | WERTV8_TR | ||||
| CLEAN_PRICE_CC_E | Clean Price in Evaluation Currency End | FTI_CLEAN_PRICE_CC_E | CURR | 15(2) | WERTV8_TR | ||||
| BPVALUE_PC_A | Basis Point Value in Position Currency: Start | FTI_VALBP_PC_A | CURR | 15(2) | WERTV8_TR | ||||
| BPVALUE_PC_E | Basis Point Value in Position Currency: End | FTI_VALBP_PC_E | CURR | 15(2) | WERTV8_TR | ||||
| BPVALUE_CC_A | Basis Point Value in Valuation Currency Start | FTI_VALBP_CC_A | CURR | 15(2) | WERTV8_TR | ||||
| BPVALUE_CC_E | Basis Point Value in Valuation Currency End | FTI_VALBP_CC_E | CURR | 15(2) | WERTV8_TR | ||||
| MAC_DURATION_A | Macaulay Duration: Start | FTI_MAC_DURATION_A | DEC | 12(3) | DEC9_3 | ||||
| MAC_DURATION_E | Macaulay Duration: End | FTI_MAC_DURATION_E | DEC | 12(3) | DEC9_3 | ||||
| MOD_DURATION_A | Modified Duration: Start | FTI_MOD_DURATION_A | DEC | 12(3) | DEC9_3 | ||||
| MOD_DURATION_E | Modified Duration: End | FTI_MOD_DURATION_E | DEC | 12(3) | DEC9_3 | ||||
| STUECKE_A | Number of units / Number of transactions - start | FTI_STUECKE_A | DEC | 15(5) | ASTUECK | ||||
| STUECKE_E | No. of units/No. of transactions - end | FTI_STUECKE_E | DEC | 15(5) | ASTUECK | ||||
| BZBETR_AW | Payment Amount of Flow in Display Crcy (from Pmnt Crcy) | FTI_CASWCW | CURR | 15(2) | WERTV8 | ||||
| BHWBETR_AW | Payment amount of flow in display currency from local curr. | FTI_CASWHW | CURR | 15(2) | WERTV8 | ||||
| EHBETR_AW | Profit/loss amount in display currency from local currency | EHBETR_AW | CURR | 15(2) | WERTV8_TR | ||||
| EEBETR_AW | Profit/Loss Amount in DC (from P/L Currency) | EEBETR_AW | CURR | 15(2) | WERTV8_TR | ||||
| PABGERFPL_AW | Revenue Accrued/Deferred in DC (from P/L Currency) | FTI_PABGERFPLW_AW | CURR | 15(2) | WERTV8_TR | ||||
| PABGERFHW_AW | Revenue accrued/deferred in display currency (local curr.) | FTI_PABGERFHW_AW | CURR | 15(2) | WERTV8_TR | ||||
| D_AKTBWBW_AW | Asset: Change in book value in display currency | FTI_D_AKTBWBW_AW | CURR | 15(2) | WERTV8_TR | ||||
| D_AKTBWHW_AW | Asset: Change in book value in disp. curr. from local curr. | FTI_D_AKTBWHW_AW | CURR | 15(2) | WERTV8_TR | ||||
| D_PASBWBW_AW | Liability: Change in book value in display currency | FTI_D_PASBWBW_AW | CURR | 15(2) | WERTV8_TR | ||||
| D_PASBWHW_AW | Liability: Change in book val. in disp.curr.from local curr. | FTI_D_PASBWHW_AW | CURR | 15(2) | WERTV8_TR | ||||
| D_BNOMBW_AW | Delta Nominal Value of Underlying in Display Currency | FTI_D_BNOMUNDERLYING_UW_AW | CURR | 15(2) | WERTV8_TR | ||||
| D_BNOMBW1_AW | Delta Nominal Value Outgoing Side in Display Currency | FTI_D_BNOMBW_AS_AW | CURR | 15(2) | WERTV8_TR | ||||
| D_BNOMBW2_AW | Delta Nominal Value Incoming Side in Display Currency | FTI_D_BNOMBW_ES_AW | CURR | 15(2) | WERTV8_TR | ||||
| ANZGW | Display Currency | FTI_ANZGW | CUKY | 5 | TCURC | WAERS | FFZ | ||
| BNOMI_AS_A_AW | Nominal amount of outgoing side in DC - start | FTI_NOM_AUSGS_A_AW | CURR | 15(2) | WERTV8 | ||||
| BNOMI_AS_E_AW | Nominal amount of outgoing side in DC - end | FTI_NOM_AUSGS_E_AW | CURR | 15(2) | WERTV8 | ||||
| BNOMI_ES_A_AW | Nominal amount of incoming side in display currency - start | FTI_NOM_EINGS_A_AW | CURR | 15(2) | WERTV8 | ||||
| BNOMI_ES_E_AW | Nominal amount of incoming side in display currency - end | FTI_NOM_EINGS_E_AW | CURR | 15(2) | WERTV8 | ||||
| BNOMI_UNDERLYING_A_AW | Nominal Amount of Underlying in Display Currency: Start | FTI_NOM_UNDERLYING_A_AW | CURR | 15(2) | WERTV8 | ||||
| BNOMI_UNDERLYING_E_AW | Nominal Amount of Underlying in Display Currency: End | FTI_NOM_UNDERLYING_E_AW | CURR | 15(2) | WERTV8 | ||||
| BOPRAKTWR_A_AW | Asset: Option premium (investment/purchase) in DC - start | FTI_AKT_OPR_A_AW | CURR | 15(2) | WERTV8_TR | ||||
| BOPRAKTWR_E_AW | Asset: Option premium (investment/purchase) in DC - end | FTI_AKT_OPR_E_AW | CURR | 15(2) | WERTV8_TR | ||||
| BOPRAKTHW_A_AW | Asset: Option premium (invest./purchase) in DC(LC)- start | FTI_AKT_OPR_HW_A_AW | CURR | 15(2) | WERTV8_TR | ||||
| BOPRAKTHW_E_AW | Asset: Option premium (investment/purchase) in DC(LC) - end | FTI_AKT_OPR_HW_E_AW | CURR | 15(2) | WERTV8_TR | ||||
| BOPRPASWR_A_AW | Liability: Option premium (investment/purchase) in DC- start | FTI_PAS_OPR_A_AW | CURR | 15(2) | WERTV8_TR | ||||
| BOPRPASWR_E_AW | Liability: Option premium (investment/purchase) in DC - end | FTI_PAS_OPR_E_AW | CURR | 15(2) | WERTV8_TR | ||||
| BOPRPASHW_A_AW | Liability: Option premium (invest./purch.) in DC(LC) - start | FTI_PAS_OPR_HW_A_AW | CURR | 15(2) | WERTV8_TR | ||||
| BOPRPASHW_E_AW | Liability: Option premium (invest./purch.) in DC(LC) - end | FTI_PAS_OPR_HW_E_AW | CURR | 15(2) | WERTV8_TR | ||||
| BOPRWR_A_AW | Option premium affecting income in DC(PC) - start | FTI_OPR_A_AW | CURR | 15(2) | |||||
| BOPRWR_E_AW | Option premium affecting income in DC(PC) - end | FTI_OPR_E_AW | CURR | 15(2) | |||||
| BOPRHW_A_AW | Option premium affecting income in DC(LC) - start | FTI_OPR_HW_A_AW | CURR | 15(2) | |||||
| BOPRHW_E_AW | Option premium affecting income in DC(LC) - end | FTI_OPR_HW_E_AW | CURR | 15(2) | |||||
| NPV_PC_A_AW | RM NPV in Display Currency: Start | FTI_NPV_PC_A_AW | CURR | 15(2) | WERTV8_TR | ||||
| NPV_PC_E_AW | RM NPV in Display Currency: End | FTI_NPV_PC_E_AW | CURR | 15(2) | WERTV8_TR | ||||
| CLEAN_PRICE_PC_A_AW | Clean Price in Display Currency: Start | FTI_CLEAN_PRICE_AW_A | CURR | 15(2) | WERTV8_TR | ||||
| CLEAN_PRICE_PC_E_AW | Clean Price in Display Currency: End | FTI_CLEAN_PRICE_AW_E | CURR | 15(2) | WERTV8_TR | ||||
| BPVALUE_PC_A_AW | Basis Point Value in Display Currency: Start | FTI_VALBP_AW_A | CURR | 15(2) | WERTV8_TR | ||||
| BPVALUE_PC_E_AW | Basis Point Value in Display Currency: End | FTI_VALBP_AW_E | CURR | 15(2) | WERTV8_TR | ||||
| 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 VTVDETA_DR using ABAP code?
As VTVDETA_DR 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 VTVDETA_DR as there is no data to select.How to access SAP table VTVDETA_DR
Within an ECC or HANA version of SAP you can also view further information about VTVDETA_DR 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