FTI_BI_REP_ODS SAP (Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW) Table details
Description: Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW
Related tables to FTI_BI_REP_ODS
Access table FTI_BI_REP_ODS
Table field list including key, data, relationships and ABAP select examples
FTI_BI_REP_ODS is a standard SAP Table which is used to store Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW data and is available within R/3 SAP systems depending on the version and release level.
The FTI_BI_REP_ODS table consists of various fields, each holding specific information or linking keys about Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW data available in SAP. These include VALUATION_AREA (Valuation Area), BUSTRANSID (Identifier of the Distributor Business Transaction), TRLFLOWNUMBER (Number of TRL Flow), BUKRS (Company Code).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FTI_BI_REP_ODS table 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 | |||
VALUATION_AREA | Valuation Area | TPM_VAL_AREA | CHAR | 3 | TRGC_VAL_AREA | TPM_VAL_AREA | TPM_VAL_AREA | TRG_VALUATION_AREA | |
BUSTRANSID | Identifier of the Distributor Business Transaction | TPM_BUSTRANSID | RAW | 16 | SYSUUID | ||||
TRLFLOWNUMBER | Number of TRL Flow | TPM_TRLFLOWNR | INT4 | 10 | TPM_TRLFLOW_NR | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
TR_ACC_CODE | Accounting Code | TPM_ACC_CODE | CHAR | 4 | TRGC_TR_ACC_CODE | TPM_ACC_CODE | TPM_TAC | TRG_ACC_CODE | |
VALUATION_CLASS | Valuation Class | TPM_VAL_CLASS | NUMC | 4 | TRGC_VAL_CLASS | TPM_VAL_CLASS | |||
GSART | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | TWPOB | RPORTB | T50 | H_RPORTB_CORE | |
SECURITY_ID | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
LOANS_CONTRACT | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
DEAL_NUMBER | Position-Generating Financial Transaction | FTI_POSRFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
HEDGE_ID | Identification Number of Hedge Item | THM_HEDGE_ID | NUMC | 10 | Assigned to domain | THM_HEDGE_ID | HEDGEID | ||
ACCOUNT_GROUP | Securities Account Group | TPM_SEC_ACCT_GRP | CHAR | 10 | TRGT_SECACCGRP | TPM_SEC_ACCT_GRP | TPM_SHPL_SEC_ACC_GRP | ||
SECURITY_ACCOUNT | Securities Account | VRLDEPO | CHAR | 10 | TWD01 | RLDEPO | DEP | ||
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 | |
FLAG_LONG_SHORT | Indicator: Long or Short Position | TPM_FLAG_LONG_SHORT | CHAR | 1 | TPM_FLAG_LONG_SHORT | ||||
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
DLOTGENERATION | Date On Which Lot Was Generated | DLOTGENERATION | DATS | 8 | DATUM | ||||
TLOTGENERATION | Lot Generation Time | TLOTGENERATION | TIMS | 6 | UZEIT | ||||
LOTGENERATION_US | Lot Entered By | FTI_LOTGENERATIONUSER | CHAR | 12 | SYCHAR12 | ||||
LOTGENERATION_CT | Business Transaction Category Which Generated the Lot | FTI_LOTGENERATION_BUSTRANSCAT | NUMC | 4 | Assigned to domain | TPM_BUSTRANSCAT | |||
LOTPOS_INIT_DATE | Position Acquisition Date of a Lot | FTI_LOTPOSITION_INIT_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTPOS_ORG_DATE | Original Position Acquisition Date of a Lot | FTI_LOTPOSITION_ORG_DATE | DATS | 8 | TPM_POSITION_DATE | ||||
LOTGEN_DEALNR | Lot-Generating Transaction Number (Listed Derivatives) | FTI_LOTGENERATION_DEALNR | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | F4_TRANS_NO | |
HREL_NUMBER | Hedging Relationship Number (External/Internal) | TPM_HREL_NUMBER | CHAR | 10 | ALPHA | TPM_HREL_NUMBER | |||
FISCAL_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
HITEM_NUMBER | Hedged Item Number | TPM_HITEM_NUMBER | CHAR | 10 | ALPHA | TPM_HITEM_NUMBER | |||
HINST_NUMBER | Hedging Instrument Number | TPM_HINST_NUMBER | CHAR | 10 | ALPHA | TPM_HINST_NUMBER | |||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
FUND | Fund | FM_FUND | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
ACC_ASS_REF | Account Assignment Reference of Position Management | TPM_AA_REF | CHAR | 12 | TRACC_AA_REF | TPM_AA_REF | TRAC_AA_REF | ||
HKONT | General ledger account | FTI_HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
DBESTAND | Position value date | DBESTAND | DATS | 8 | DATUM | ||||
SE_DEAL_NUMBER | Securities/Futures Transaction | FTI_SE_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
RKONTRA | Reference to Counterparty | RKONTRA_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
FLOW_TYPE | Update Type | TPM_DIS_FLOWTYPE | CHAR | 8 | TRDC_DFLOWTYPE | TPM_DIS_FLOWTYPE | |||
BUSTRANSCAT | Business Transaction Category | TPM_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
GEN_BUSTRANSCAT | Generating Business Transaction Category | FTI_GENERATING_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
SOURCETARGET_FLG | Indicator: Source or Target of a Flow | TPM_SOURCE_TARGET_FLG | CHAR | 1 | TPM_SOURCE_TARGET_FLG | ||||
QUANT_CAT | Position Change Category: Quantity | FTI_QTY_PM_CAT | CHAR | 4 | TPM_QTY_PM_CAT | ||||
AMOUNT_CAT | Position Change Category | FTI_AMT_PM_CAT | CHAR | 4 | Assigned to domain | TPM_PM_CAT | |||
TRL_BOOKINGSTATE | Posting Status Treasury Ledger Business Transaction | TPM_TRL_BOOKINGSTATE | CHAR | 1 | TRLBS | TPM_TRL_BOOKINGSTATE | |||
PL_CATEGORY | P/L Type | TPM_PL_CATEGORY | CHAR | 3 | TRGC_PL_CATE | ALPHA | TPM_PL_CATEGORY | ||
LEDGER_POST_STAT | Ledger Posting Status | FTR_LEDGER_POSTING_STATE | CHAR | 1 | FTR_LEDGER_POSTING_STATE | ||||
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 |
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 | |||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
SINCLVON | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
SINCLBIS | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | VVSSOLHAB | ||||
SHWHR | Local Currency | TB_SHWHR | CUKY | 5 | TCURC | WAERS | |||
SVWHR | Valuation Currency | TPM_VALUATION_CURR | CUKY | 5 | TCURC | WAERS | |||
SBWHR | Position Currency/Transaction Currency | TB_BWHR | CUKY | 5 | TCURC | WAERS | |||
PLWHR | Profit/loss currency | SPLWHR | CUKY | 5 | TCURC | WAERS | |||
D_UNITS | Delta Number of Units | FTI_D_UNITS | DEC | 22(6) | TPM_UNITS | ||||
D_NOMINAL_AMT_PC | Delta Nominal Amount in Position Currency | FTI_D_NOMINAL_AMT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_NOMINAL_ORG_PC | Delta: Original Nominal Amount in Position Currency | FTI_D_NOMINAL_ORG_AMT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_PURCH_PC | Delta Purchase Value in Position Currency | FTI_D_PURCH_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_PURCH_LC | Delta Purchase Value in Local Currency | FTI_D_PURCH_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_PURCH_VC | Delta Purchase Value in Valuation Currency | FTI_D_PURCH_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AQU_VAL_PC | Delta Acquisition Value in Position Currency | FTI_D_AQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AQU_VAL_LC | Delta Acquisition Value in Local Currency | FTI_D_AQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AQU_VAL_VC | Delta Acquisition Value in Valuation Currency | FTI_D_AQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_PC | Delta Book Value in Position Currency | FTI_D_BOOK_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_LC | Delta Book Value in Local Currency | FTI_D_BOOK_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_VC | Delta Book Value in Valuation Currency | FTI_D_BOOK_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CHARGE_PC | Delta Costs in Position Currency | FTI_D_CHARGE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CHARGE_LC | Delta Costs in Local Currency | FTI_D_CHARGE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_CHARGE_VC | Delta Costs in Valuation Currency | FTI_D_CHARGE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_EX_PC | Delta Book Value Excl. Costs in Position Currency | FTI_D_BOOK_VAL_EX_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_EX_LC | Delta Book Value Excl. Costs in Local Currency | FTI_D_BOOK_VAL_EX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_BOOK_VAL_EX_VC | Delta Book Value Excl. Costs in Valuation Currency | FTI_D_BOOK_VAL_EX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_PC | Delta Security Valuation in Position Currency | FTI_D_VAL_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_LC | Delta Security Valuation in Local Currency | FTI_D_VAL_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_VC | Delta Security Valuation in Valuation Currency | FTI_D_VAL_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_LC | Delta Foreign Currency Valuation in Local Currency | FTI_D_VAL_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_VC | Delta Foreign Currency Valuation in Valuation Currency | FTI_D_VAL_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VALFXAAQUVL_LC | FX Valuation of Amort. Acquisition Value in Local Currency | FTI_D_VAL_FX_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VALFXAAQUVL_VC | Delta Valuation of FX, Amort. Acquisition Value in VC | FTI_D_VAL_FX_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_PC | Delta Valuation of Capitalized Costs, Security, in PC | FTI_D_VAL_CH_TI_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_LC | Delta Valuation of Capitalized Costs, Security, in LC | FTI_D_VAL_CH_TI_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_VC | Delta Valuation of Capitalized Costs, Security, in VC | FTI_D_VAL_CH_TI_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_LC | Delta Valuation of Capitalized Costs, FX, in Local Currency | FTI_D_VAL_CH_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_VC | Delta Valuation of Capitalized Costs, FX, in Valuation Crcy | FTI_D_VAL_CH_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMORT_PC | Delta Amortization in Position Currency | FTI_D_AMORT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMORT_LC | Delta Amortization in Local Currency | FTI_D_AMORT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMORT_VC | Delta Amortization in Valuation Currency | FTI_D_AMORT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_PC | Delta Impairment in Position Currency | FTI_D_IMPMNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_LC | Delta Impairment in Local Currency | FTI_D_IMPMNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_VC | Delta Impairment in Valuation Currency | FTI_D_IMPMNT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_FX_LC | Delta FX Impairment in Local Currency | FTI_D_IMPMNT_FX_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_IMPMNT_FX_VC | Delta FX Impairment in Valuation Currency | FTI_D_IMPMNT_FX_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_REPAYMENT_PC | Delta: Cumulative Repayment in Position Currency | FTI_D_REPAYMENT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_REPAYMENT_LC | Delta: Cumulative Repayment in Local Currency | FTI_D_REPAYMENT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_REPAYMENT_VC | Delta: Cumulative Repayment in Valuation Currency | FTI_D_REPAYMENT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMAQU_VAL_PC | Delta Amortized Acquisition Value in Position Currency | FTI_D_AMAQU_VAL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMAQU_VAL_LC | Delta Amortized Acquisition Value in Local Currency | FTI_D_AMAQU_VAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_AMAQU_VAL_VC | Delta Amortized Acquisition Value in Valuation Currency | FTI_D_AMAQU_VAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_DISAGIO_PC | Delta Cleared PD Def./Tax Compensation in Position Currency | FTI_D_DISAGIO_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_DISAGIO_LC | Delta Cleared PD Def./Tax Compensation in Local Currency | FTI_D_DISAGIO_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_DISAGIO_VC | Delta Cleared PD Def./Tax Compensation in Valuation Currency | FTI_D_DISAGIO_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_NPL_PC | Delta Security Valuation, Not Affecting P/L, in Pos. Crcy | FTI_D_VAL_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_NPL_LC | Delta Security Valuation, Not Affecting P/L, in Local Crcy | FTI_D_VAL_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_TI_NPL_VC | Delta Security Valuation, Not Affecting P/L, in Val. Crcy | FTI_D_VAL_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_NPL_LC | Delta Foreign Currency Valuation, Not Affecting P/L, in LC | FTI_D_VAL_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_FX_NPL_VC | Delta Foreign Currency Valuation, Not Affecting P/L, in VC | FTI_D_VAL_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_N_PC | Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Position Crcy | FTI_D_VAL_CH_TI_NPL_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_N_LC | Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Local Crcy | FTI_D_VAL_CH_TI_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_TI_N_VC | Delta Val. of Costs, Sec., Not Aff. P/L in Valuation Crcy | FTI_D_VAL_CH_TI_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_N_LC | Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Local Crcy | FTI_D_VAL_CH_FX_NPL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAL_CH_FX_N_VC | Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Val. Crcy | FTI_D_VAL_CH_FX_NPL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VARMAR_PC | Delta Variation Margin in Position Currency | FTI_D_VARMAR_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VARMAR_LC | Delta Variation Margin in Local Currency | FTI_D_VARMAR_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VARMAR_VC | Delta Variation Margin in Valuation Currency | FTI_D_VARMAR_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SPOTVALP_LC | Delta Spot Valuation of Purchase Crcy in Local Currency | FTI_D_SPOTVALP_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SPOTVALP_VC | Delta Spot Valuation of Purchase Crcy in Valuation Currency | FTI_D_SPOTVALP_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SPOTVALS_LC | Delta Spot Valuation of Sale Currency in Local Currency | FTI_D_SPOTVALS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SPOTVALS_VC | Delta Spot Valuation of Sale Currency in Valuation Currency | FTI_D_SPOTVALS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPACC_PC | Delta Swap/Margin Accrual/Deferral in Position Currency | FTI_D_SWAPACC_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPACC_LC | Delta Swap/Margin Accrual/Deferral in Local Currency | FTI_D_SWAPACC_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPACC_VC | Delta Swap/Margin Accrual/Deferral in Valuation Currency | FTI_D_SWAPACC_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPVAL_LC | Delta Swap Valuation in Local Currency | FTI_D_SWAPVAL_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_SWAPVAL_VC | Delta Swap Valuation in Valuation Currency | FTI_D_SWAPVAL_VC | CURR | 21(2) | TPM_AMOUNT | ||||
AMOUNT_PC | Flow Amount in Position Currency | FTI_D_AMOUNT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
AMOUNT_LC | Flow Amount in Local Currency | FTI_D_AMOUNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
AMOUNT_VC | Flow Amount in Valuation Currency | FTI_D_AMOUNT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
PLAMOUNT_PLC | Profit/loss amount in profit/loss currency | FTI_PLAMOUNT_PLC | CURR | 21(2) | TPM_AMOUNT | ||||
PLAMOUNT_LC | Profit/loss amount in local currency | FTI_PLAMOUNT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_ORIG_VAD_LC | Delta Original Value Adjustment in Local Currency | FTI_D_ORIG_VAD_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_ORIG_VAD_PC | Delta Original Value Adjustment in Position Currency | FTI_D_ORIG_VAD_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_ORIG_VAD_VC | Delta Original Value Adjustment in Valuation Currency | FTI_D_ORIG_VAD_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_GAIN_LC | Delta Value Adjustment of Gains in Local Currency | FTI_D_VAD_GAIN_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_GAIN_PC | Delta Value Adjustment of Gains in Position Currency | FTI_D_VAD_GAIN_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_GAIN_VC | Delta Value Adjustment of Gains in Valuation Currency | FTI_D_VAD_GAIN_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_LOSS_LC | Delta Value Adjustment of Losses in Local Currency | FTI_D_VAD_LOSS_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_LOSS_PC | Delta Value Adjustment of Losses in Position Currency | FTI_D_VAD_LOSS_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_VAD_LOSS_VC | Delta Value Adjustment of Losses in Valuation Currency | FTI_D_VAD_LOSS_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_HADJ_LC | Delta Hedge Adjustment in Local Currency | FTI_D_HADJ_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_HADJ_PC | Delta Hedge Adjustment in Position Currency | FTI_D_HADJ_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_HADJ_VC | Delta Hedge Adjustment in Valuation Currency | FTI_D_HADJ_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_LC | Delta Effective Amount in Local Currency | FTI_D_EFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_PC | Delta Effective Amount in Position Currency | FTI_D_EFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFFECTIVE_VC | Delta Effective Amount in Valuation Currency | FTI_D_EFFECTIVE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFF_DORMANT_LC | Delta Effective Dormant Amount in Local Currency | FTI_D_EFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFF_DORMANT_PC | Delta Effective Dormant Amount in Position Currency | FTI_D_EFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_EFF_DORMANT_VC | Delta Effective Dormant Amount in Valuation Currency | FTI_D_EFFECTIVE_DORMANT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_LC | Delta Ineffective Amount in Local Currency | FTI_D_INEFFECTIVE_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_PC | Delta Ineffective Amount in Position Currency | FTI_D_INEFFECTIVE_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFFECTIVE_VC | Delta Ineffective Amount in Valuation Currency | FTI_D_INEFFECTIVE_VC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFF_DORM_LC | Delta Ineffective Dormant Amount in Local Currency | FTI_D_INEFFECTIVE_DORMANT_LC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFF_DORM_P | Delta Ineffective Dormant Amount in Position Currency | FTI_D_INEFFECTIVE_DORMANT_PC | CURR | 21(2) | TPM_AMOUNT | ||||
D_INEFF_DORM_V | Delta Ineffective Dormant Amount in Valuation Currency | FTI_D_INEFFECTIVE_DORMANT_VC | CURR | 21(2) | TPM_AMOUNT | ||||
UPDMOD | BW Delta Process: Record Mode | RODMUPDMOD | CHAR | 1 | RODMUPDMOD | ||||
CREATE_NAME | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
CREATE_DATE | First Entered on | DERF | DATS | 8 | DATUM | ||||
CREATE_TIME | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REQUEST_ID | Request number for the data transfer | RSREQUNR | CHAR | 30 | RSREQUNR | ||||
REQUEST_DATE | Date of Position Currency Request | FTI_BI_REQUEST_DATE | DATS | 8 | DATUM | ||||
REQUEST_TIME | Time of Position Currency Request | FTI_BI_REQUEST_TIME | TIMS | 6 | TIMES |
Key field | Non-key field |
How do I retrieve data from SAP table FTI_BI_REP_ODS using ABAP code
The following ABAP code Example will allow you to do a basic selection on FTI_BI_REP_ODS to SELECT all data from the tableDATA: WA_FTI_BI_REP_ODS TYPE FTI_BI_REP_ODS.
SELECT SINGLE *
FROM FTI_BI_REP_ODS
INTO CORRESPONDING FIELDS OF WA_FTI_BI_REP_ODS
WHERE...
How to access SAP table FTI_BI_REP_ODS
Within an ECC or HANA version of SAP you can also view further information about FTI_BI_REP_ODS 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