Data Element list used by SAP ABAP Table VTVDETA_DV (Foreign Exchange: For a Given Period)
SAP ABAP Table 
VTVDETA_DV (Foreign Exchange: For a Given Period) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
AFW_EVAL_CURRENCY | Evaluation Currency | |
| 2 | Data Element |
AWKEY | Object key | |
| 3 | Data Element |
BELNR_D | Accounting Document Number | |
| 4 | Data Element |
BNOMI3_AW | Nominal amount borrowing/sale start in display currency | |
| 5 | Data Element |
BNOMI4_AW | Nominal amount invest./purchase start in display currency | |
| 6 | Data Element |
BNOMI5_AW | Nominal amount borrowing/sale end in display currency | |
| 7 | Data Element |
BNOMI6_AW | Nominal amount invest./purchase end in display currency | |
| 8 | Data Element |
BP_CNTR_N | Nationality | |
| 9 | Data Element |
BP_CNTR_ST | Citizenship | |
| 10 | Data Element |
BP_COMP_RE | Organization Relationship | |
| 11 | Data Element |
BP_GROUP_D | Target Group | |
| 12 | Data Element |
BP_LEG_ETY_NEW | Legal Form of Organization | |
| 13 | Data Element |
BP_RATING | Rating | |
| 14 | Data Element |
BP_SOLVNCY | Credit Standing | |
| 15 | Data Element |
BP_SOL_INF | Status of Credit Standing Information | |
| 16 | Data Element |
BP_SOL_INS | Institute Providing Credit Standing Information | |
| 17 | Data Element |
BP_SOL_I_D | Date of Credit Standing Information | |
| 18 | Data Element |
BP_STAFF_G | Employee Group | |
| 19 | Data Element |
BP_TYPE_NEW | Business Partner Category | |
| 20 | Data Element |
BUDAT | Posting Date in the Document | |
| 21 | Data Element |
BUKRS | Company Code | |
| 22 | Data Element |
BU_GRP_ID_NEW | Business Partner Grouping | |
| 23 | Data Element |
BU_IND_SECTOR | Industry | |
| 24 | Data Element |
BU_ISTYPE | Industry System | |
| 25 | Data Element |
BU_LEGAL_ORG_NEW | Legal Entity of Organization | |
| 26 | Data Element |
CFNUMBR | Number of translation key in currency translation | |
| 27 | Data Element |
DBISDAT | Date of evaluation end | |
| 28 | Data Element |
DBLFZ | Start of Term | |
| 29 | Data Element |
DELFZ | End of Term | |
| 30 | Data Element |
DFAELL | Due date | |
| 31 | Data Element |
DVONDAT | Start Date of Evaluation | |
| 32 | Data Element |
DZLSCH | Payment method | |
| 33 | Data Element |
D_CASHCW | Payment amount in payment currency | |
| 34 | Data Element |
D_CASHHW | Payment amount in local currency | |
| 35 | Data Element |
EEBETR | Profit/loss amount in profit/loss currency | |
| 36 | Data Element |
EHBETR | Profit/loss amount in local currency | |
| 37 | Data Element |
EHBETR_AW | Profit/loss amount in display currency from local currency | |
| 38 | Data Element |
FTI_ANZGW | Display Currency | |
| 39 | Data Element |
FTI_BANKK | Bank key of house bank | |
| 40 | Data Element |
FTI_BANKKP | Bank key of business partner bank | |
| 41 | Data Element |
FTI_BANKN | Bank account number of house bank | |
| 42 | Data Element |
FTI_BANKNP | Bank account number of business partner | |
| 43 | Data Element |
FTI_BILST | Reference Date | |
| 44 | Data Element |
FTI_BILST2 | Reference Date | |
| 45 | Data Element |
FTI_BILST_REF_B | Positions: Remaining Term/Overdue Period Based On | |
| 46 | Data Element |
FTI_BILST_REF_F | Flows: Remaining Term/Overdue Period Based On | |
| 47 | Data Element |
FTI_BNOMI3 | Nominal amount borrowing/sale start | |
| 48 | Data Element |
FTI_BNOMI4 | Nominal amount invest./purchase start | |
| 49 | Data Element |
FTI_BNOMI5 | Nominal amount borrowing/sale end | |
| 50 | Data Element |
FTI_BNOMI6 | Nominal amount invest./purchase end | |
| 51 | Data Element |
FTI_CASWCW | Payment Amount of Flow in Display Crcy (from Pmnt Crcy) | |
| 52 | Data Element |
FTI_CASWHW | Payment amount of flow in display currency from local curr. | |
| 53 | Data Element |
FTI_CLEAN_PRICE_AW_A | Clean Price in Display Currency: Start | |
| 54 | Data Element |
FTI_CLEAN_PRICE_AW_E | Clean Price in Display Currency: End | |
| 55 | Data Element |
FTI_CLEAN_PRICE_CC_A | Clean Price in Valuation Currency - Start | |
| 56 | Data Element |
FTI_CLEAN_PRICE_CC_E | Clean Price in Evaluation Currency End | |
| 57 | Data Element |
FTI_CLEAN_PRICE_PC_A | Clean Price in Position Currency: Start | |
| 58 | Data Element |
FTI_CLEAN_PRICE_PC_E | Clean Price in Position Currency: End | |
| 59 | Data Element |
FTI_CONDENSE | Summarize Results (for Query) | |
| 60 | Data Element |
FTI_EVALTYPE | Evaluation Type (Risk Management) | |
| 61 | Data Element |
FTI_EXCL_PLAN | Exclude Plan Data (for Query) | |
| 62 | Data Element |
FTI_FDBUC | Relevance to CM | |
| 63 | Data Element |
FTI_GLACC_C | Number of G/L Account: Credit | |
| 64 | Data Element |
FTI_GLACC_D | Number of G/L Account: Debit | |
| 65 | Data Element |
FTI_GVBETR_AW | Change in provisions/unrealized gains and losses in DC(LC) | |
| 66 | Data Element |
FTI_HKONT | General ledger account | |
| 67 | Data Element |
FTI_KBBWHR_AW | Change in nominal purchase in display currency | |
| 68 | Data Element |
FTI_LAND1 | Country key of company code | |
| 69 | Data Element |
FTI_LANDBP | Country of Registered Office of Business Partner | |
| 70 | Data Element |
FTI_LDB_FLG_COUPLING_SECACCGRP | Interpret Assignment of Sec. Account to Sec. Account Group | |
| 71 | Data Element |
FTI_LDB_FLG_HISTORIC_ACCASSREF | Indicator: Historical Account Assignment Reference | |
| 72 | Data Element |
FTI_LDB_FLG_LO | Product Group Loans: Yes/No | |
| 73 | Data Element |
FTI_LDB_FLG_LOF | Product Group Listed Derivatives (Futures): Yes/No | |
| 74 | Data Element |
FTI_LDB_FLG_OTC | Product Group OTC (MM, FX, DE): Yes/No | |
| 75 | Data Element |
FTI_LDB_FLG_SE | Product Group Securities: Yes/No | |
| 76 | Data Element |
FTI_LDB_RISK_COUNTERPARTY | Partner with Whom Commitment Exists | |
| 77 | Data Element |
FTI_MOD_DURATION_A | Modified Duration: Start | |
| 78 | Data Element |
FTI_MOD_DURATION_E | Modified Duration: End | |
| 79 | Data Element |
FTI_MONTH_YEAR | Calendar Month/Year | |
| 80 | Data Element |
FTI_NO_NULL | Hide Zero Records | |
| 81 | Data Element |
FTI_NPV_CC_A | RM Net Present Value in Valuation Currency Start | |
| 82 | Data Element |
FTI_NPV_CC_E | RM Net Present Value in Valuation Currency End | |
| 83 | Data Element |
FTI_NPV_LONG_CC_A | RM Net Present Value Incoming Side in Val. Currency Start | |
| 84 | Data Element |
FTI_NPV_LONG_CC_E | RM Net Present Value Incoming Side in Val. Currency End | |
| 85 | Data Element |
FTI_NPV_LONG_PC_A | RM NPV Incoming Side in Currency Incoming Side Start | |
| 86 | Data Element |
FTI_NPV_LONG_PC_E | RM NPV Incoming Side in Currency Incoming Side End | |
| 87 | Data Element |
FTI_NPV_PC_A | RM NPV in Position Currency: Start | |
| 88 | Data Element |
FTI_NPV_PC_A_AW | RM NPV in Display Currency: Start | |
| 89 | Data Element |
FTI_NPV_PC_E | RM NPV in Position Currency: End | |
| 90 | Data Element |
FTI_NPV_PC_E_AW | RM NPV in Display Currency: End | |
| 91 | Data Element |
FTI_NPV_SHORT_CC_A | RM NPV Outgoing Side in Valuation Currency Start | |
| 92 | Data Element |
FTI_NPV_SHORT_CC_E | RM NPV Outgoing Side in Valuation Currency End | |
| 93 | Data Element |
FTI_NPV_SHORT_PC_A | RM NPV Outgoing Side in Currency Outgoing Side Start | |
| 94 | Data Element |
FTI_NPV_SHORT_PC_E | RM NPV Outgoing Side in Currency Outgoing Side End | |
| 95 | Data Element |
FTI_NUMBR_LC | Translation Type for Currency Translation into Local Crcy | |
| 96 | Data Element |
FTI_PABGERFHW_AW | Revenue accrued/deferred in display currency (local curr.) | |
| 97 | Data Element |
FTI_PABGERFPLW_AW | Revenue Accrued/Deferred in DC (from P/L Currency) | |
| 98 | Data Element |
FTI_REVERSED_FLOWS | Process Reversed Flows (for Query) | |
| 99 | Data Element |
FTI_RLZJA_F | Remaining Term in Years | |
| 100 | Data Element |
FTI_RLZMO_F | Remaining Term in Months | |
| 101 | Data Element |
FTI_RLZTGK_F | Remaining Term in Days (Key Figure) | |
| 102 | Data Element |
FTI_RLZTG_F | Remaining Term in Days | |
| 103 | Data Element |
FTI_SAKTIV | Active status of financial transaction (drilldown reporting) | |
| 104 | Data Element |
FTI_SBWP | Currency of position increase | |
| 105 | Data Element |
FTI_STORNO | Evaluate Reversed Flows | |
| 106 | Data Element |
FTI_STUECKE_A | Number of units / Number of transactions - start | |
| 107 | Data Element |
FTI_STUECKE_E | No. of units/No. of transactions - end | |
| 108 | Data Element |
FTI_UEBJA_F | Overdue Period in Years | |
| 109 | Data Element |
FTI_UEBMO_F | Overdue Period in Months | |
| 110 | Data Element |
FTI_UEBTGK_F | Overdue Period in Days (Key Figure) | |
| 111 | Data Element |
FTI_UEBTG_F | Overdue Period in Days | |
| 112 | Data Element |
FTI_UNRGV1_A | Unrealized Gain/Loss, Sale, in Local Crcy / Start of Period | |
| 113 | Data Element |
FTI_UNRGV1_A_AW | Unrealized Gain/Loss, Sale, in Displ. Crcy / Start of Period | |
| 114 | Data Element |
FTI_UNRGV1_E | Unrealized Gain/Loss, Sale, in Local Crcy / End of Period | |
| 115 | Data Element |
FTI_UNRGV1_E_AW | Unrealized Gain/Loss, Sale, in Displ. Crcy / End of Period | |
| 116 | Data Element |
FTI_UNRGV2_A | Unrealized Gain/Loss, Purchase, in LC / Start of Period | |
| 117 | Data Element |
FTI_UNRGV2_A_AW | Unrealized Gain/Loss, Purchase, in DC / Start of Period | |
| 118 | Data Element |
FTI_UNRGV2_E | Unrealized Gain/Loss, Purchase, in LC / End of Period | |
| 119 | Data Element |
FTI_UNRGV2_E_AW | Unrealized Gain/Loss, Purchase, in DC / End of Period | |
| 120 | Data Element |
FTI_VALBP_AW_A | Basis Point Value in Display Currency: Start | |
| 121 | Data Element |
FTI_VALBP_AW_E | Basis Point Value in Display Currency: End | |
| 122 | Data Element |
FTI_VALBP_CC_A | Basis Point Value in Valuation Currency Start | |
| 123 | Data Element |
FTI_VALBP_CC_E | Basis Point Value in Valuation Currency End | |
| 124 | Data Element |
FTI_VALBP_PC_A | Basis Point Value in Position Currency: Start | |
| 125 | Data Element |
FTI_VALBP_PC_E | Basis Point Value in Position Currency: End | |
| 126 | Data Element |
FTI_VKBBWHR_AW | Change in nominal sale in display currency | |
| 127 | Data Element |
FTI_WEEK_YEAR | Calendar Week/Year | |
| 128 | Data Element |
FTI_WGSCH3 | Currency borr./sale start/end | |
| 129 | Data Element |
FTI_WGSCH4 | Currency investment/purchase start/end | |
| 130 | Data Element |
FTI_WOCHE | Calendar Week | |
| 131 | Data Element |
GJAHR | Fiscal Year | |
| 132 | Data Element |
GVBETR | Delta provisions/unrealized gains and losses LC | |
| 133 | Data Element |
JAHRPER | Period/year | |
| 134 | Data Element |
KBBWHR | Change in nominal purchase value | |
| 135 | Data Element |
MANDT | Client | |
| 136 | Data Element |
MONAT | Fiscal period | |
| 137 | Data Element |
PABGERFHW | Revenue Accrued/Deferred in Local Currency | |
| 138 | Data Element |
PABGERFPLW | Revenue Accrued/Deferred in Profit/Loss Currency | |
| 139 | Data Element |
PERIV | Fiscal Year Variant | |
| 140 | Data Element |
PRQ_KEYNO | Key Number for Payment Request | |
| 141 | Data Element |
RANTYP | Contract Type | |
| 142 | Data Element |
RDEALER | Trader | |
| 143 | Data Element |
RPORTB | Portfolio | |
| 144 | Data Element |
RSTICH | Key date reference | |
| 145 | Data Element |
SANLF | Product Category | |
| 146 | Data Element |
SBEWART | Flow Type | |
| 147 | Data Element |
SCASHFLOW | Indicator for cash flow calculation up to end of term | |
| 148 | Data Element |
SPLWHR | Profit/loss currency | |
| 149 | Data Element |
TB_BWHR | Position Currency/Transaction Currency | |
| 150 | Data Element |
TB_DVTRAB | Contract Conclusion Date | |
| 151 | Data Element |
TB_JAHR | Calendar year | |
| 152 | Data Element |
TB_MERKM | Characteristics | |
| 153 | Data Element |
TB_MONAT | Calendar month | |
| 154 | Data Element |
TB_NORDEXT | External Reference | |
| 155 | Data Element |
TB_REFER | Internal Reference | |
| 156 | Data Element |
TB_REFKONT | Acct Assignment Ref. for Operative Valn Area and Loan | |
| 157 | Data Element |
TB_RFHA | Financial Transaction | |
| 158 | Data Element |
TB_RGARANT_NEW | Guarantor of Financial Transaction | |
| 159 | Data Element |
TB_RHABKI | Short key for own house bank | |
| 160 | Data Element |
TB_RHKTID | Short key for house bank account | |
| 161 | Data Element |
TB_RMAID | Master Agreement | |
| 162 | Data Element |
TB_RPBANK | Partner bank details | |
| 163 | Data Element |
TB_RPZAHL_NEW | Payer/payee | |
| 164 | Data Element |
TB_SBEWEBE | Posting Status of Flow | |
| 165 | Data Element |
TB_SBFREI | Release Given for Flow to Be Posted? | |
| 166 | Data Element |
TB_SFGTYP | Transaction Category | |
| 167 | Data Element |
TB_SFGZUTY | Transaction Activity Category | |
| 168 | Data Element |
TB_SFHAART | Financial Transaction Type | |
| 169 | Data Element |
TB_SPAYIND | Payment Status of Flows | |
| 170 | Data Element |
TB_SPAYRQK | Generate payment request | |
| 171 | Data Element |
TB_SSIGN | Direction of flow | |
| 172 | Data Element |
TB_SZART | Payment transaction | |
| 173 | Data Element |
TB_TFPROJ | Finance Project | |
| 174 | Data Element |
TB_WZBETR | Payment Currency | |
| 175 | Data Element |
TB_ZUOND | Assignment | |
| 176 | Data Element |
VKBBWHR | Change in nominal value: Sale | |
| 177 | Data Element |
VVKURSAUSW | Price type for evaluations | |
| 178 | Data Element |
VVRANLWI | No. of the secondary index description for class data | |
| 179 | Data Element |
VVSART | Product Type | |
| 180 | Data Element |
WAERS | Currency Key |
