FTI_BI_REP_ODS

Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | #transactional | Component: Information System
Column Name Description
MANDT FK Client
VALUATION_AREA FK Treasury Valuation Area
BUSTRANSID Identifier of the Distributor Business Transaction
TRLFLOWNUMBER Number of TRL Flow
Column Name Description
💲 Position Currency/Transaction Currency (SBWHR):
D_NOMINAL_AMT_PC Delta Nominal Amount in Position Currency
D_NOMINAL_ORG_PC Delta: Original Nominal Amount in Position Currency
D_PURCH_PC Delta Purchase Value in Position Currency
D_AQU_VAL_PC Delta Acquisition Value in Position Currency
D_BOOK_VAL_PC Delta Book Value in Position Currency
D_CHARGE_PC Delta Costs in Position Currency
D_BOOK_VAL_EX_PC Delta Book Value Excl. Costs in Position Currency
D_VAL_TI_PC Delta Security Valuation in Position Currency
D_VAL_CH_TI_PC Delta Valuation of Capitalized Costs, Security, in PC
D_AMORT_PC Delta Amortization in Position Currency
D_IMPMNT_PC Delta Impairment in Position Currency
D_REPAYMENT_PC Delta: Cumulative Repayment in Position Currency
D_AMAQU_VAL_PC Delta Amortized Acquisition Value in Position Currency
D_DISAGIO_PC Delta Cleared PD Def./Tax Compensation in Position Currency
D_VAL_TI_NPL_PC Delta Security Valuation, Not Affecting P/L, in Pos. Crcy
D_VAL_CH_TI_N_PC Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Position Crcy
D_VARMAR_PC Delta Variation Margin in Position Currency
D_SWAPACC_PC Delta Swap/Margin Accrual/Deferral in Position Currency
AMOUNT_PC Flow Amount in Position Currency
D_ORIG_VAD_PC Delta Original Value Adjustment in Position Currency
D_VAD_GAIN_PC Delta Value Adjustment of Gains in Position Currency
D_VAD_LOSS_PC Delta Value Adjustment of Losses in Position Currency
D_HADJ_PC Delta Hedge Adjustment in Position Currency
D_EFFECTIVE_PC Delta Effective Amount in Position Currency
D_EFF_DORMANT_PC Delta Effective Dormant Amount in Position Currency
D_INEFFECTIVE_PC Delta Ineffective Amount in Position Currency
D_INEFF_DORM_P Delta Ineffective Dormant Amount in Position Currency
💲 Local Currency (SHWHR):
D_PURCH_LC Delta Purchase Value in Local Currency
D_AQU_VAL_LC Delta Acquisition Value in Local Currency
D_BOOK_VAL_LC Delta Book Value in Local Currency
D_CHARGE_LC Delta Costs in Local Currency
D_BOOK_VAL_EX_LC Delta Book Value Excl. Costs in Local Currency
D_VAL_TI_LC Delta Security Valuation in Local Currency
D_VAL_FX_LC Delta Foreign Currency Valuation in Local Currency
D_VALFXAAQUVL_LC FX Valuation of Amort. Acquisition Value in Local Currency
D_VAL_CH_TI_LC Delta Valuation of Capitalized Costs, Security, in LC
D_VAL_CH_FX_LC Delta Valuation of Capitalized Costs, FX, in Local Currency
D_AMORT_LC Delta Amortization in Local Currency
D_IMPMNT_LC Delta Impairment in Local Currency
D_IMPMNT_FX_LC Delta FX Impairment in Local Currency
D_REPAYMENT_LC Delta: Cumulative Repayment in Local Currency
D_AMAQU_VAL_LC Delta Amortized Acquisition Value in Local Currency
D_DISAGIO_LC Delta Cleared PD Def./Tax Compensation in Local Currency
D_VAL_TI_NPL_LC Delta Security Valuation, Not Affecting P/L, in Local Crcy
D_VAL_FX_NPL_LC Delta Foreign Currency Valuation, Not Affecting P/L, in LC
D_VAL_CH_TI_N_LC Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Local Crcy
D_VAL_CH_FX_N_LC Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Local Crcy
D_VARMAR_LC Delta Variation Margin in Local Currency
D_SPOTVALP_LC Delta Spot Valuation of Purchase Crcy in Local Currency
D_SPOTVALS_LC Delta Spot Valuation of Sale Currency in Local Currency
D_SWAPACC_LC Delta Swap/Margin Accrual/Deferral in Local Currency
D_SWAPVAL_LC Delta Swap Valuation in Local Currency
AMOUNT_LC Flow Amount in Local Currency
PLAMOUNT_LC Profit/loss amount in local currency
D_ORIG_VAD_LC Delta Original Value Adjustment in Local Currency
D_VAD_GAIN_LC Delta Value Adjustment of Gains in Local Currency
D_VAD_LOSS_LC Delta Value Adjustment of Losses in Local Currency
D_HADJ_LC Delta Hedge Adjustment in Local Currency
D_EFFECTIVE_LC Delta Effective Amount in Local Currency
D_EFF_DORMANT_LC Delta Effective Dormant Amount in Local Currency
D_INEFFECTIVE_LC Delta Ineffective Amount in Local Currency
D_INEFF_DORM_LC Delta Ineffective Dormant Amount in Local Currency
💲 Valuation Currency (SVWHR):
D_PURCH_VC Delta Purchase Value in Valuation Currency
D_AQU_VAL_VC Delta Acquisition Value in Valuation Currency
D_BOOK_VAL_VC Delta Book Value in Valuation Currency
D_CHARGE_VC Delta Costs in Valuation Currency
D_BOOK_VAL_EX_VC Delta Book Value Excl. Costs in Valuation Currency
D_VAL_TI_VC Delta Security Valuation in Valuation Currency
D_VAL_FX_VC Delta Foreign Currency Valuation in Valuation Currency
D_VALFXAAQUVL_VC Delta Valuation of FX, Amort. Acquisition Value in VC
D_VAL_CH_TI_VC Delta Valuation of Capitalized Costs, Security, in VC
D_VAL_CH_FX_VC Delta Valuation of Capitalized Costs, FX, in Valuation Crcy
D_AMORT_VC Delta Amortization in Valuation Currency
D_IMPMNT_VC Delta Impairment in Valuation Currency
D_IMPMNT_FX_VC Delta FX Impairment in Valuation Currency
D_REPAYMENT_VC Delta: Cumulative Repayment in Valuation Currency
D_AMAQU_VAL_VC Delta Amortized Acquisition Value in Valuation Currency
D_DISAGIO_VC Delta Cleared PD Def./Tax Compensation in Valuation Currency
D_VAL_TI_NPL_VC Delta Security Valuation, Not Affecting P/L, in Val. Crcy
D_VAL_FX_NPL_VC Delta Foreign Currency Valuation, Not Affecting P/L, in VC
D_VAL_CH_TI_N_VC Delta Val. of Costs, Sec., Not Aff. P/L in Valuation Crcy
D_VAL_CH_FX_N_VC Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Val. Crcy
D_VARMAR_VC Delta Variation Margin in Valuation Currency
D_SPOTVALP_VC Delta Spot Valuation of Purchase Crcy in Valuation Currency
D_SPOTVALS_VC Delta Spot Valuation of Sale Currency in Valuation Currency
D_SWAPACC_VC Delta Swap/Margin Accrual/Deferral in Valuation Currency
D_SWAPVAL_VC Delta Swap Valuation in Valuation Currency
AMOUNT_VC Flow Amount in Valuation Currency
D_ORIG_VAD_VC Delta Original Value Adjustment in Valuation Currency
D_VAD_GAIN_VC Delta Value Adjustment of Gains in Valuation Currency
D_VAD_LOSS_VC Delta Value Adjustment of Losses in Valuation Currency
D_HADJ_VC Delta Hedge Adjustment in Valuation Currency
D_EFFECTIVE_VC Delta Effective Amount in Valuation Currency
D_EFF_DORMANT_VC Delta Effective Dormant Amount in Valuation Currency
D_INEFFECTIVE_VC Delta Ineffective Amount in Valuation Currency
D_INEFF_DORM_V Delta Ineffective Dormant Amount in Valuation Currency
💲 Profit/loss currency (PLWHR):
PLAMOUNT_PLC Profit/loss amount in profit/loss currency
Column Name Description
Column Name Description
DLOTGENERATION Date On Which Lot Was Generated
TLOTGENERATION Lot Generation Time
LOTPOS_INIT_DATE Position Acquisition Date of a Lot
LOTPOS_ORG_DATE Original Position Acquisition Date of a Lot
DBESTAND Position value date
DBUDAT Posting Date in the Document
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
CREATE_DATE First Entered On
CREATE_TIME Time of Creation
REQUEST_DATE Date of Position Currency Request
REQUEST_TIME Time of Position Currency Request
Column Name Description
FLAG_LONG_SHORT Indicates whether it is a long or a short position Show values
SOURCETARGET_FLG Indicator: Source or Target of a Flow Show values
QUANT_CAT Position Change Category: Quantity Show values
TRL_BOOKINGSTATE Posting Status Treasury Ledger Business Transaction Show values
LEDGER_POST_STAT Ledger Posting Status Show values
SZBMETH Interest Calculation Method Show values
SINCLVON Inclusive indicator for beginning and end of a period Show values
SINCLBIS Inclusive indicator for beginning and end of a period Show values
SSOLHAB Debit/credit indicator Show values
UPDMOD BW Delta Process: Record Mode Show values
Column Name Description Domain name
LOANS_CONTRACT Contract Number RANL
DEAL_NUMBER Position-Generating Financial Transaction T_RFHA
HEDGE_ID Identification Number of Hedged Item THM_HEDGE_ID
LOT_ID Identifier of the Lot SYSUUID
LOTGENERATION_US Lot Entered By SYCHAR12
LOTGENERATION_CT Business Transaction Category Which Generated the Lot TPM_BUSTRANSCAT
LOTGEN_DEALNR Lot-Generating Transaction Number (Listed Derivatives) T_RFHA
HREL_NUMBER Hedging Relationship Number (External/Internal) TPM_HREL_NUMBER
FISCAL_YEAR Fiscal Year GJAHR
HITEM_NUMBER Hedged Item Number TPM_HITEM_NUMBER
HINST_NUMBER Hedging Instrument Number TPM_HINST_NUMBER
FIKRS Financial Management Area FIKRS
FUND Fund BP_GEBER
GRANT_NBR Grant GM_GRANT_NBR
HKONT General ledger account SAKNR
SE_DEAL_NUMBER Securities/Futures Transaction T_RFHA
AMOUNT_CAT Position Change Category TPM_PM_CAT
BELNR Document Number of an Accounting Document BELNR
AWKEY Reference Key AWKEY
GL_ACCOUNT_D Number of G/L Account: Debit SAKNR
GL_ACCOUNT_C Number of G/L Account: Credit SAKNR
DGJAHR Fiscal Year GJAHR
DMONAT Fiscal period MONAT
PERIO Period/Year JAHRPER
D_UNITS Delta Number of Units TPM_UNITS
CREATE_NAME Entered By SYCHAR12
REQUEST_ID Request number for the data transfer RSREQUNR
Master Data Relations | to Other Relations ↓ Join Conditions
Account Assignment Reference of Position Management
Company Code
  • FTI_BI_REP_ODS.MANDT == T001.MANDT
  • FTI_BI_REP_ODS.BUKRS == T001.BUKRS
Business Transaction Category FTI_BI_REP_ODS.BUSTRANSCAT == TRDTS_BT_CAT.BUSTRANSCAT
Update Type
Generating Business Transaction Category FTI_BI_REP_ODS.GEN_BUSTRANSCAT == TRDTS_BT_CAT.BUSTRANSCAT
Product Type
  • Product Type
  • Client
  • FTI_BI_REP_ODS.GSART == TZPA.GSART
  • FTI_BI_REP_ODS.MANDT == TZPA.MANDT
Client FTI_BI_REP_ODS.MANDT == T000.MANDT
Profit/loss currency
  • FTI_BI_REP_ODS.MANDT == TCURC.MANDT
  • FTI_BI_REP_ODS.PLWHR == TCURC.WAERS
P/L Type
Portfolio
  • Company Code
  • Portfolio
  • Client
  • FTI_BI_REP_ODS.BUKRS == TWPOB.BUKRS
  • FTI_BI_REP_ODS.PORTFOLIO == TWPOB.RPORTB
  • FTI_BI_REP_ODS.MANDT == TWPOB.MANDT
Futures Account for Listed Options and Futures
  • Futures Account for Listed Options and Futures
  • Client
  • Company Code
Reference to Counterparty
  • Reference to Counterparty
  • Client
  • FTI_BI_REP_ODS.RKONTRA == BUT000.PARTNER
  • FTI_BI_REP_ODS.MANDT == BUT000.CLIENT
Position Currency/Transaction Currency
  • FTI_BI_REP_ODS.MANDT == TCURC.MANDT
  • FTI_BI_REP_ODS.SBWHR == TCURC.WAERS
Securities Account
  • Securities Account
  • Company Code
  • FTI_BI_REP_ODS.MANDT == TWD01.MANDT
  • FTI_BI_REP_ODS.SECURITY_ACCOUNT == TWD01.RLDEPO
  • FTI_BI_REP_ODS.BUKRS == TWD01.BUKRS
Security Class ID Number
  • FTI_BI_REP_ODS.MANDT == VWPANLA.MANDT
  • FTI_BI_REP_ODS.SECURITY_ID == VWPANLA.RANL
Local Currency
  • FTI_BI_REP_ODS.MANDT == TCURC.MANDT
  • FTI_BI_REP_ODS.SHWHR == TCURC.WAERS
Valuation Currency
  • FTI_BI_REP_ODS.MANDT == TCURC.MANDT
  • FTI_BI_REP_ODS.SVWHR == TCURC.WAERS
Valuation Class
  • Treasury Valuation Area
  • Valuation Class
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Company Code
  • Securities Account Group
  • Client
Accounting Code
  • Accounting Code
  • Client
Treasury Valuation Area