dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table FTI_BI_REP_ODS

Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table FTI_BI_REP_ODS (Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW) is a standard table in SAP ERP. It belongs to the package CFM_TR_BIW.

Technical Information

Table FTI_BI_REP_ODS
Short Text Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW
Package CFM_TR_BIW
Table Type Transparent Table

Fields for Table FTI_BI_REP_ODS

Field Name Key Description Data Element Type Length Check Table
MANDT ✔ Client MANDT CLNT 3 T000
VALUATION_AREA ✔ Valuation Area TPM_VAL_AREA CHAR 3 TRGC_VAL_AREA
BUSTRANSID ✔ Identifier of the Distributor Business Transaction TPM_BUSTRANSID RAW 16
TRLFLOWNUMBER ✔ Number of TRL Flow TPM_TRLFLOWNR INT4 10
BUKRS Company Code BUKRS CHAR 4 T001
TR_ACC_CODE Accounting Code TPM_ACC_CODE CHAR 4 TRGC_TR_ACC_CODE
VALUATION_CLASS Valuation Class TPM_VAL_CLASS NUMC 4 TRGC_VAL_CLASS
GSART Product Type VVSART CHAR 3 TZPA
PORTFOLIO Portfolio RPORTB CHAR 10 TWPOB
SECURITY_ID Security ID Number VVRANLW CHAR 13 VWPANLA
LOANS_CONTRACT Contract Number RANL CHAR 13
DEAL_NUMBER Position-Generating Financial Transaction FTI_POSRFHA CHAR 13 *
HEDGE_ID Identification Number of Hedge Item THM_HEDGE_ID NUMC 10 *
ACCOUNT_GROUP Securities Account Group TPM_SEC_ACCT_GRP CHAR 10 TRGT_SECACCGRP
SECURITY_ACCOUNT Securities Account VRLDEPO CHAR 10 TWD01
POSITION_ACCOUNT Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT CHAR 10 TRFT_POS_ACCOUNT
FLAG_LONG_SHORT Indicator: Long or Short Position TPM_FLAG_LONG_SHORT CHAR 1
LOT_ID Identifier of the Lot TPM_LOT_ID RAW 16
DLOTGENERATION Date On Which Lot Was Generated DLOTGENERATION DATS 8
TLOTGENERATION Lot Generation Time TLOTGENERATION TIMS 6
LOTGENERATION_US Lot Entered By FTI_LOTGENERATIONUSER CHAR 12
LOTGENERATION_CT Business Transaction Category Which Generated the Lot FTI_LOTGENERATION_BUSTRANSCAT NUMC 4 *
LOTPOS_INIT_DATE Position Acquisition Date of a Lot FTI_LOTPOSITION_INIT_DATE DATS 8
LOTPOS_ORG_DATE Original Position Acquisition Date of a Lot FTI_LOTPOSITION_ORG_DATE DATS 8
LOTGEN_DEALNR Lot-Generating Transaction Number (Listed Derivatives) FTI_LOTGENERATION_DEALNR CHAR 13 *
HREL_NUMBER Hedging Relationship Number (External/Internal) TPM_HREL_NUMBER CHAR 10
FISCAL_YEAR Fiscal Year GJAHR NUMC 4
HITEM_NUMBER Hedged Item Number TPM_HITEM_NUMBER CHAR 10
HINST_NUMBER Hedging Instrument Number TPM_HINST_NUMBER CHAR 10
FIKRS Financial Management Area FIKRS CHAR 4 *
FUND Fund FM_FUND CHAR 10 *
GRANT_NBR Grant GM_GRANT_NBR CHAR 20
ACC_ASS_REF Account Assignment Reference of Position Management TPM_AA_REF CHAR 12 TRACC_AA_REF
HKONT General ledger account FTI_HKONT CHAR 10 *
DBESTAND Position value date DBESTAND DATS 8
SE_DEAL_NUMBER Securities/Futures Transaction FTI_SE_RFHA CHAR 13 *
RKONTRA Reference to Counterparty RKONTRA_NEW CHAR 10 BUT000
FLOW_TYPE Update Type TPM_DIS_FLOWTYPE CHAR 8 TRDC_DFLOWTYPE
BUSTRANSCAT Business Transaction Category TPM_BUSTRANSCAT NUMC 4 TRDTS_BT_CAT
GEN_BUSTRANSCAT Generating Business Transaction Category FTI_GENERATING_BUSTRANSCAT NUMC 4 TRDTS_BT_CAT
SOURCETARGET_FLG Indicator: Source or Target of a Flow TPM_SOURCE_TARGET_FLG CHAR 1
QUANT_CAT Position Change Category: Quantity FTI_QTY_PM_CAT CHAR 4
AMOUNT_CAT Position Change Category FTI_AMT_PM_CAT CHAR 4 *
TRL_BOOKINGSTATE Posting Status Treasury Ledger Business Transaction TPM_TRL_BOOKINGSTATE CHAR 1
PL_CATEGORY P/L Type TPM_PL_CATEGORY CHAR 3 TRGC_PL_CATE
LEDGER_POST_STAT Ledger Posting Status FTR_LEDGER_POSTING_STATE CHAR 1
BELNR Accounting Document Number BELNR_D CHAR 10
AWKEY Reference Key AWKEY CHAR 20
GL_ACCOUNT_D Number of G/L Account: Debit FTI_GLACC_D CHAR 10 *
GL_ACCOUNT_C Number of G/L Account: Credit FTI_GLACC_C CHAR 10 *
DBUDAT Posting Date in the Document BUDAT DATS 8
DGJAHR Fiscal Year GJAHR NUMC 4
DMONAT Fiscal Period MONAT NUMC 2
PERIO Period/year JAHRPER NUMC 7
SZBMETH Interest Calculation Method SZBMETH CHAR 1
DBERVON Start of Calculation Period DBERVON DATS 8
DBERBIS End of Calculation Period DBERBIS DATS 8
SINCLVON Inclusive indicator for beginning and end of a period VVSINCL NUMC 1
SINCLBIS Inclusive indicator for beginning and end of a period VVSINCL NUMC 1
SSOLHAB Debit/credit indicator VVSSOLHAB CHAR 1
SHWHR Local Currency TB_SHWHR CUKY 5 TCURC
SVWHR Valuation Currency TPM_VALUATION_CURR CUKY 5 TCURC
SBWHR Position Currency/Transaction Currency TB_BWHR CUKY 5 TCURC
PLWHR Profit/loss currency SPLWHR CUKY 5 TCURC
D_UNITS Delta Number of Units FTI_D_UNITS DEC 22
D_NOMINAL_AMT_PC Delta Nominal Amount in Position Currency FTI_D_NOMINAL_AMT_PC CURR 21
D_NOMINAL_ORG_PC Delta: Original Nominal Amount in Position Currency FTI_D_NOMINAL_ORG_AMT_PC CURR 21
D_PURCH_PC Delta Purchase Value in Position Currency FTI_D_PURCH_PC CURR 21
D_PURCH_LC Delta Purchase Value in Local Currency FTI_D_PURCH_LC CURR 21
D_PURCH_VC Delta Purchase Value in Valuation Currency FTI_D_PURCH_VC CURR 21
D_AQU_VAL_PC Delta Acquisition Value in Position Currency FTI_D_AQU_VAL_PC CURR 21
D_AQU_VAL_LC Delta Acquisition Value in Local Currency FTI_D_AQU_VAL_LC CURR 21
D_AQU_VAL_VC Delta Acquisition Value in Valuation Currency FTI_D_AQU_VAL_VC CURR 21
D_BOOK_VAL_PC Delta Book Value in Position Currency FTI_D_BOOK_VAL_PC CURR 21
D_BOOK_VAL_LC Delta Book Value in Local Currency FTI_D_BOOK_VAL_LC CURR 21
D_BOOK_VAL_VC Delta Book Value in Valuation Currency FTI_D_BOOK_VAL_VC CURR 21
D_CHARGE_PC Delta Costs in Position Currency FTI_D_CHARGE_PC CURR 21
D_CHARGE_LC Delta Costs in Local Currency FTI_D_CHARGE_LC CURR 21
D_CHARGE_VC Delta Costs in Valuation Currency FTI_D_CHARGE_VC CURR 21
D_BOOK_VAL_EX_PC Delta Book Value Excl. Costs in Position Currency FTI_D_BOOK_VAL_EX_PC CURR 21
D_BOOK_VAL_EX_LC Delta Book Value Excl. Costs in Local Currency FTI_D_BOOK_VAL_EX_LC CURR 21
D_BOOK_VAL_EX_VC Delta Book Value Excl. Costs in Valuation Currency FTI_D_BOOK_VAL_EX_VC CURR 21
D_VAL_TI_PC Delta Security Valuation in Position Currency FTI_D_VAL_TI_PC CURR 21
D_VAL_TI_LC Delta Security Valuation in Local Currency FTI_D_VAL_TI_LC CURR 21
D_VAL_TI_VC Delta Security Valuation in Valuation Currency FTI_D_VAL_TI_VC CURR 21
D_VAL_FX_LC Delta Foreign Currency Valuation in Local Currency FTI_D_VAL_FX_LC CURR 21
D_VAL_FX_VC Delta Foreign Currency Valuation in Valuation Currency FTI_D_VAL_FX_VC CURR 21
D_VALFXAAQUVL_LC FX Valuation of Amort. Acquisition Value in Local Currency FTI_D_VAL_FX_AMAQU_VAL_LC CURR 21
D_VALFXAAQUVL_VC Delta Valuation of FX, Amort. Acquisition Value in VC FTI_D_VAL_FX_AMAQU_VAL_VC CURR 21
D_VAL_CH_TI_PC Delta Valuation of Capitalized Costs, Security, in PC FTI_D_VAL_CH_TI_PC CURR 21
D_VAL_CH_TI_LC Delta Valuation of Capitalized Costs, Security, in LC FTI_D_VAL_CH_TI_LC CURR 21
D_VAL_CH_TI_VC Delta Valuation of Capitalized Costs, Security, in VC FTI_D_VAL_CH_TI_VC CURR 21
D_VAL_CH_FX_LC Delta Valuation of Capitalized Costs, FX, in Local Currency FTI_D_VAL_CH_FX_LC CURR 21
D_VAL_CH_FX_VC Delta Valuation of Capitalized Costs, FX, in Valuation Crcy FTI_D_VAL_CH_FX_VC CURR 21
D_AMORT_PC Delta Amortization in Position Currency FTI_D_AMORT_PC CURR 21
D_AMORT_LC Delta Amortization in Local Currency FTI_D_AMORT_LC CURR 21
D_AMORT_VC Delta Amortization in Valuation Currency FTI_D_AMORT_VC CURR 21
D_IMPMNT_PC Delta Impairment in Position Currency FTI_D_IMPMNT_PC CURR 21
D_IMPMNT_LC Delta Impairment in Local Currency FTI_D_IMPMNT_LC CURR 21
D_IMPMNT_VC Delta Impairment in Valuation Currency FTI_D_IMPMNT_VC CURR 21
D_IMPMNT_FX_LC Delta FX Impairment in Local Currency FTI_D_IMPMNT_FX_LC CURR 21
D_IMPMNT_FX_VC Delta FX Impairment in Valuation Currency FTI_D_IMPMNT_FX_VC CURR 21
D_REPAYMENT_PC Delta: Cumulative Repayment in Position Currency FTI_D_REPAYMENT_PC CURR 21
D_REPAYMENT_LC Delta: Cumulative Repayment in Local Currency FTI_D_REPAYMENT_LC CURR 21
D_REPAYMENT_VC Delta: Cumulative Repayment in Valuation Currency FTI_D_REPAYMENT_VC CURR 21
D_AMAQU_VAL_PC Delta Amortized Acquisition Value in Position Currency FTI_D_AMAQU_VAL_PC CURR 21
D_AMAQU_VAL_LC Delta Amortized Acquisition Value in Local Currency FTI_D_AMAQU_VAL_LC CURR 21
D_AMAQU_VAL_VC Delta Amortized Acquisition Value in Valuation Currency FTI_D_AMAQU_VAL_VC CURR 21
D_DISAGIO_PC Delta Cleared PD Def./Tax Compensation in Position Currency FTI_D_DISAGIO_PC CURR 21
D_DISAGIO_LC Delta Cleared PD Def./Tax Compensation in Local Currency FTI_D_DISAGIO_LC CURR 21
D_DISAGIO_VC Delta Cleared PD Def./Tax Compensation in Valuation Currency FTI_D_DISAGIO_VC CURR 21
D_VAL_TI_NPL_PC Delta Security Valuation, Not Affecting P/L, in Pos. Crcy FTI_D_VAL_TI_NPL_PC CURR 21
D_VAL_TI_NPL_LC Delta Security Valuation, Not Affecting P/L, in Local Crcy FTI_D_VAL_TI_NPL_LC CURR 21
D_VAL_TI_NPL_VC Delta Security Valuation, Not Affecting P/L, in Val. Crcy FTI_D_VAL_TI_NPL_VC CURR 21
D_VAL_FX_NPL_LC Delta Foreign Currency Valuation, Not Affecting P/L, in LC FTI_D_VAL_FX_NPL_LC CURR 21
D_VAL_FX_NPL_VC Delta Foreign Currency Valuation, Not Affecting P/L, in VC FTI_D_VAL_FX_NPL_VC CURR 21
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
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
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
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
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
D_VARMAR_PC Delta Variation Margin in Position Currency FTI_D_VARMAR_PC CURR 21
D_VARMAR_LC Delta Variation Margin in Local Currency FTI_D_VARMAR_LC CURR 21
D_VARMAR_VC Delta Variation Margin in Valuation Currency FTI_D_VARMAR_VC CURR 21
D_SPOTVALP_LC Delta Spot Valuation of Purchase Crcy in Local Currency FTI_D_SPOTVALP_LC CURR 21
D_SPOTVALP_VC Delta Spot Valuation of Purchase Crcy in Valuation Currency FTI_D_SPOTVALP_VC CURR 21
D_SPOTVALS_LC Delta Spot Valuation of Sale Currency in Local Currency FTI_D_SPOTVALS_LC CURR 21
D_SPOTVALS_VC Delta Spot Valuation of Sale Currency in Valuation Currency FTI_D_SPOTVALS_VC CURR 21
D_SWAPACC_PC Delta Swap/Margin Accrual/Deferral in Position Currency FTI_D_SWAPACC_PC CURR 21
D_SWAPACC_LC Delta Swap/Margin Accrual/Deferral in Local Currency FTI_D_SWAPACC_LC CURR 21
D_SWAPACC_VC Delta Swap/Margin Accrual/Deferral in Valuation Currency FTI_D_SWAPACC_VC CURR 21
D_SWAPVAL_LC Delta Swap Valuation in Local Currency FTI_D_SWAPVAL_LC CURR 21
D_SWAPVAL_VC Delta Swap Valuation in Valuation Currency FTI_D_SWAPVAL_VC CURR 21
AMOUNT_PC Flow Amount in Position Currency FTI_D_AMOUNT_PC CURR 21
AMOUNT_LC Flow Amount in Local Currency FTI_D_AMOUNT_LC CURR 21
AMOUNT_VC Flow Amount in Valuation Currency FTI_D_AMOUNT_VC CURR 21
PLAMOUNT_PLC Profit/loss amount in profit/loss currency FTI_PLAMOUNT_PLC CURR 21
PLAMOUNT_LC Profit/loss amount in local currency FTI_PLAMOUNT_LC CURR 21
D_ORIG_VAD_LC Delta Original Value Adjustment in Local Currency FTI_D_ORIG_VAD_LC CURR 21
D_ORIG_VAD_PC Delta Original Value Adjustment in Position Currency FTI_D_ORIG_VAD_PC CURR 21
D_ORIG_VAD_VC Delta Original Value Adjustment in Valuation Currency FTI_D_ORIG_VAD_VC CURR 21
D_VAD_GAIN_LC Delta Value Adjustment of Gains in Local Currency FTI_D_VAD_GAIN_LC CURR 21
D_VAD_GAIN_PC Delta Value Adjustment of Gains in Position Currency FTI_D_VAD_GAIN_PC CURR 21
D_VAD_GAIN_VC Delta Value Adjustment of Gains in Valuation Currency FTI_D_VAD_GAIN_VC CURR 21
D_VAD_LOSS_LC Delta Value Adjustment of Losses in Local Currency FTI_D_VAD_LOSS_LC CURR 21
D_VAD_LOSS_PC Delta Value Adjustment of Losses in Position Currency FTI_D_VAD_LOSS_PC CURR 21
D_VAD_LOSS_VC Delta Value Adjustment of Losses in Valuation Currency FTI_D_VAD_LOSS_VC CURR 21
D_HADJ_LC Delta Hedge Adjustment in Local Currency FTI_D_HADJ_LC CURR 21
D_HADJ_PC Delta Hedge Adjustment in Position Currency FTI_D_HADJ_PC CURR 21
D_HADJ_VC Delta Hedge Adjustment in Valuation Currency FTI_D_HADJ_VC CURR 21
D_EFFECTIVE_LC Delta Effective Amount in Local Currency FTI_D_EFFECTIVE_LC CURR 21
D_EFFECTIVE_PC Delta Effective Amount in Position Currency FTI_D_EFFECTIVE_PC CURR 21
D_EFFECTIVE_VC Delta Effective Amount in Valuation Currency FTI_D_EFFECTIVE_VC CURR 21
D_EFF_DORMANT_LC Delta Effective Dormant Amount in Local Currency FTI_D_EFFECTIVE_DORMANT_LC CURR 21
D_EFF_DORMANT_PC Delta Effective Dormant Amount in Position Currency FTI_D_EFFECTIVE_DORMANT_PC CURR 21
D_EFF_DORMANT_VC Delta Effective Dormant Amount in Valuation Currency FTI_D_EFFECTIVE_DORMANT_VC CURR 21
D_INEFFECTIVE_LC Delta Ineffective Amount in Local Currency FTI_D_INEFFECTIVE_LC CURR 21
D_INEFFECTIVE_PC Delta Ineffective Amount in Position Currency FTI_D_INEFFECTIVE_PC CURR 21
D_INEFFECTIVE_VC Delta Ineffective Amount in Valuation Currency FTI_D_INEFFECTIVE_VC CURR 21
D_INEFF_DORM_LC Delta Ineffective Dormant Amount in Local Currency FTI_D_INEFFECTIVE_DORMANT_LC CURR 21
D_INEFF_DORM_P Delta Ineffective Dormant Amount in Position Currency FTI_D_INEFFECTIVE_DORMANT_PC CURR 21
D_INEFF_DORM_V Delta Ineffective Dormant Amount in Valuation Currency FTI_D_INEFFECTIVE_DORMANT_VC CURR 21
UPDMOD BW Delta Process: Record Mode RODMUPDMOD CHAR 1
CREATE_NAME Entered by RERF CHAR 12
CREATE_DATE First Entered on DERF DATS 8
CREATE_TIME Time of Initial Entry TERF TIMS 6
REQUEST_ID Request number for the data transfer RSREQUNR CHAR 30
REQUEST_DATE Date of Position Currency Request FTI_BI_REQUEST_DATE DATS 8
REQUEST_TIME Time of Position Currency Request FTI_BI_REQUEST_TIME TIMS 6