FTI_BI_REP_ODS - Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW

Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW information is stored in SAP table FTI_BI_REP_ODS.
It is part of development package CFM_TR_BIW in software component FIN-FSCM-TRM-TM-IS. This development package consists of objects that can be grouped under "Transaction Management: Connection to BW".

Fields for table FTI_BI_REP_ODS

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