SAP ABAP Table FTI_BI_REP_ODS (Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ CFM_TR_BIW (Package) CFM: Connection to BW

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FTI_BI_REP_ODS	Table Relationship Diagram
Short Description	Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VALUATION_AREA	☑	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
3	BUSTRANSID	☑	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
4	TRLFLOWNUMBER	☑	TPM_TRLFLOWNR	TPM_TRLFLOW_NR	INT4	10	0	Number of TRL Flow
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
7	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
8	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
9	PORTFOLIO	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
10	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
11	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number
12	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	*
13	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
14	SECURITY_ACCOUNT	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
15	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
16	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
17	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
18	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
19	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
20	LOTGENERATION_US	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
21	LOTGENERATION_CT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	*
22	ACC_ASS_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management	TRACC_AA_REF
23	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	*
24	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
25	SE_DEAL_NUMBER	☐	FTI_SE_RFHA	T_RFHA	CHAR	13	0	Securities/Futures Transaction	*
26	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	BUT000
27	FLOW_TYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
28	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
29	GEN_BUSTRANSCAT	☐	FTI_GENERATING_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Generating Business Transaction Category	TRDTS_BT_CAT
30	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
31	QUANT_CAT	☐	FTI_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
32	AMOUNT_CAT	☐	FTI_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category	*
33	TRL_BOOKINGSTATE	☐	TPM_TRL_BOOKINGSTATE	TPM_TRL_BOOKINGSTATE	CHAR	1	0	Posting Status Treasury Ledger Business Transaction
34	PL_CATEGORY	☐	TPM_PL_CATEGORY	TPM_PL_CATEGORY	CHAR	3	0	P/L Type	TRGC_PL_CATE
35	LEDGER_POST_STAT	☐	FTR_LEDGER_POSTING_STATE	FTR_LEDGER_POSTING_STATE	CHAR	1	0	Ledger Posting Status
36	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
37	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
38	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	*
39	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	*
40	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
41	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
42	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
43	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
44	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
45	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
46	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
47	SINCLVON	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
48	SINCLBIS	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
49	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
50	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	TCURC
51	SVWHR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	TCURC
52	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
53	PLWHR	☐	SPLWHR	WAERS	CUKY	5	0	Profit/loss currency	TCURC
54	D_UNITS	☐	FTI_D_UNITS	TPM_UNITS	DEC	22	6	Delta Number of Units
55	D_NOMINAL_AMT_PC	☐	FTI_D_NOMINAL_AMT_PC	TPM_AMOUNT	CURR	21	2	Delta Nominal Amount in Position Currency
56	D_NOMINAL_ORG_PC	☐	FTI_D_NOMINAL_ORG_AMT_PC	TPM_AMOUNT	CURR	21	2	Delta: Original Nominal Amount in Position Currency
57	D_PURCH_PC	☐	FTI_D_PURCH_PC	TPM_AMOUNT	CURR	21	2	Delta Purchase Value in Position Currency
58	D_PURCH_LC	☐	FTI_D_PURCH_LC	TPM_AMOUNT	CURR	21	2	Delta Purchase Value in Local Currency
59	D_PURCH_VC	☐	FTI_D_PURCH_VC	TPM_AMOUNT	CURR	21	2	Delta Purchase Value in Valuation Currency
60	D_AQU_VAL_PC	☐	FTI_D_AQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Delta Acquisition Value in Position Currency
61	D_AQU_VAL_LC	☐	FTI_D_AQU_VAL_LC	TPM_AMOUNT	CURR	21	2	Delta Acquisition Value in Local Currency
62	D_AQU_VAL_VC	☐	FTI_D_AQU_VAL_VC	TPM_AMOUNT	CURR	21	2	Delta Acquisition Value in Valuation Currency
63	D_BOOK_VAL_PC	☐	FTI_D_BOOK_VAL_PC	TPM_AMOUNT	CURR	21	2	Delta Book Value in Position Currency
64	D_BOOK_VAL_LC	☐	FTI_D_BOOK_VAL_LC	TPM_AMOUNT	CURR	21	2	Delta Book Value in Local Currency
65	D_BOOK_VAL_VC	☐	FTI_D_BOOK_VAL_VC	TPM_AMOUNT	CURR	21	2	Delta Book Value in Valuation Currency
66	D_CHARGE_PC	☐	FTI_D_CHARGE_PC	TPM_AMOUNT	CURR	21	2	Delta Costs in Position Currency
67	D_CHARGE_LC	☐	FTI_D_CHARGE_LC	TPM_AMOUNT	CURR	21	2	Delta Costs in Local Currency
68	D_CHARGE_VC	☐	FTI_D_CHARGE_VC	TPM_AMOUNT	CURR	21	2	Delta Costs in Valuation Currency
69	D_BOOK_VAL_EX_PC	☐	FTI_D_BOOK_VAL_EX_PC	TPM_AMOUNT	CURR	21	2	Delta Book Value Excl. Costs in Position Currency
70	D_BOOK_VAL_EX_LC	☐	FTI_D_BOOK_VAL_EX_LC	TPM_AMOUNT	CURR	21	2	Delta Book Value Excl. Costs in Local Currency
71	D_BOOK_VAL_EX_VC	☐	FTI_D_BOOK_VAL_EX_VC	TPM_AMOUNT	CURR	21	2	Delta Book Value Excl. Costs in Valuation Currency
72	D_VAL_TI_PC	☐	FTI_D_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation in Position Currency
73	D_VAL_TI_LC	☐	FTI_D_VAL_TI_LC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation in Local Currency
74	D_VAL_TI_VC	☐	FTI_D_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation in Valuation Currency
75	D_VAL_FX_LC	☐	FTI_D_VAL_FX_LC	TPM_AMOUNT	CURR	21	2	Delta Foreign Currency Valuation in Local Currency
76	D_VAL_FX_VC	☐	FTI_D_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Delta Foreign Currency Valuation in Valuation Currency
77	D_VAL_CH_TI_PC	☐	FTI_D_VAL_CH_TI_PC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, Security, in PC
78	D_VAL_CH_TI_LC	☐	FTI_D_VAL_CH_TI_LC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, Security, in LC
79	D_VAL_CH_TI_VC	☐	FTI_D_VAL_CH_TI_VC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, Security, in VC
80	D_VAL_CH_FX_LC	☐	FTI_D_VAL_CH_FX_LC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, FX, in Local Currency
81	D_VAL_CH_FX_VC	☐	FTI_D_VAL_CH_FX_VC	TPM_AMOUNT	CURR	21	2	Delta Valuation of Capitalized Costs, FX, in Valuation Crcy
82	D_AMORT_PC	☐	FTI_D_AMORT_PC	TPM_AMOUNT	CURR	21	2	Delta Amortization in Position Currency
83	D_AMORT_LC	☐	FTI_D_AMORT_LC	TPM_AMOUNT	CURR	21	2	Delta Amortization in Local Currency
84	D_AMORT_VC	☐	FTI_D_AMORT_VC	TPM_AMOUNT	CURR	21	2	Delta Amortization in Valuation Currency
85	D_IMPMNT_PC	☐	FTI_D_IMPMNT_PC	TPM_AMOUNT	CURR	21	2	Delta Impairment in Position Currency
86	D_IMPMNT_LC	☐	FTI_D_IMPMNT_LC	TPM_AMOUNT	CURR	21	2	Delta Impairment in Local Currency
87	D_IMPMNT_VC	☐	FTI_D_IMPMNT_VC	TPM_AMOUNT	CURR	21	2	Delta Impairment in Valuation Currency
88	D_REPAYMENT_PC	☐	FTI_D_REPAYMENT_PC	TPM_AMOUNT	CURR	21	2	Delta: Cumulative Repayment in Position Currency
89	D_REPAYMENT_LC	☐	FTI_D_REPAYMENT_LC	TPM_AMOUNT	CURR	21	2	Delta: Cumulative Repayment in Local Currency
90	D_REPAYMENT_VC	☐	FTI_D_REPAYMENT_VC	TPM_AMOUNT	CURR	21	2	Delta: Cumulative Repayment in Valuation Currency
91	D_AMAQU_VAL_PC	☐	FTI_D_AMAQU_VAL_PC	TPM_AMOUNT	CURR	21	2	Delta Amortized Acquisition Value in Position Currency
92	D_AMAQU_VAL_LC	☐	FTI_D_AMAQU_VAL_LC	TPM_AMOUNT	CURR	21	2	Delta Amortized Acquisition Value in Local Currency
93	D_AMAQU_VAL_VC	☐	FTI_D_AMAQU_VAL_VC	TPM_AMOUNT	CURR	21	2	Delta Amortized Acquisition Value in Valuation Currency
94	D_DISAGIO_PC	☐	FTI_D_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Delta Cleared PD Def./Tax Compensation in Position Currency
95	D_DISAGIO_LC	☐	FTI_D_DISAGIO_LC	TPM_AMOUNT	CURR	21	2	Delta Cleared PD Def./Tax Compensation in Local Currency
96	D_DISAGIO_VC	☐	FTI_D_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Delta Cleared PD Def./Tax Compensation in Valuation Currency
97	D_VAL_TI_NPL_PC	☐	FTI_D_VAL_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation, Not Affecting P/L, in Pos. Crcy
98	D_VAL_TI_NPL_LC	☐	FTI_D_VAL_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation, Not Affecting P/L, in Local Crcy
99	D_VAL_TI_NPL_VC	☐	FTI_D_VAL_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Delta Security Valuation, Not Affecting P/L, in Val. Crcy
100	D_VAL_FX_NPL_LC	☐	FTI_D_VAL_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Delta Foreign Currency Valuation, Not Affecting P/L, in LC
101	D_VAL_FX_NPL_VC	☐	FTI_D_VAL_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Delta Foreign Currency Valuation, Not Affecting P/L, in VC
102	D_VAL_CH_TI_N_PC	☐	FTI_D_VAL_CH_TI_NPL_PC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Position Crcy
103	D_VAL_CH_TI_N_LC	☐	FTI_D_VAL_CH_TI_NPL_LC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Local Crcy
104	D_VAL_CH_TI_N_VC	☐	FTI_D_VAL_CH_TI_NPL_VC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, Valuation Crcy
105	D_VAL_CH_FX_N_LC	☐	FTI_D_VAL_CH_FX_NPL_LC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Local Crcy
106	D_VAL_CH_FX_N_VC	☐	FTI_D_VAL_CH_FX_NPL_VC	TPM_AMOUNT	CURR	21	2	Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Val. Crcy
107	D_VARMAR_PC	☐	FTI_D_VARMAR_PC	TPM_AMOUNT	CURR	21	2	Delta Variation Margin in Position Currency
108	D_VARMAR_LC	☐	FTI_D_VARMAR_LC	TPM_AMOUNT	CURR	21	2	Delta Variation Margin in Local Currency
109	D_VARMAR_VC	☐	FTI_D_VARMAR_VC	TPM_AMOUNT	CURR	21	2	Delta Variation Margin in Valuation Currency
110	D_SPOTVALP_LC	☐	FTI_D_SPOTVALP_LC	TPM_AMOUNT	CURR	21	2	Delta Spot Valuation of Purchase Crcy in Local Currency
111	D_SPOTVALP_VC	☐	FTI_D_SPOTVALP_VC	TPM_AMOUNT	CURR	21	2	Delta Spot Valuation of Purchase Crcy in Valuation Currency
112	D_SPOTVALS_LC	☐	FTI_D_SPOTVALS_LC	TPM_AMOUNT	CURR	21	2	Delta Spot Valuation of Sale Currency in Local Currency
113	D_SPOTVALS_VC	☐	FTI_D_SPOTVALS_VC	TPM_AMOUNT	CURR	21	2	Delta Spot Valuation of Sale Currency in Valuation Currency
114	D_SWAPACC_PC	☐	FTI_D_SWAPACC_PC	TPM_AMOUNT	CURR	21	2	Delta Swap/Margin Accrual/Deferral in Position Currency
115	D_SWAPACC_LC	☐	FTI_D_SWAPACC_LC	TPM_AMOUNT	CURR	21	2	Delta Swap/Margin Accrual/Deferral in Local Currency
116	D_SWAPACC_VC	☐	FTI_D_SWAPACC_VC	TPM_AMOUNT	CURR	21	2	Delta Swap/Margin Accrual/Deferral in Valuation Currency
117	D_SWAPVAL_LC	☐	FTI_D_SWAPVAL_LC	TPM_AMOUNT	CURR	21	2	Delta Swap Valuation in Local Currency
118	D_SWAPVAL_VC	☐	FTI_D_SWAPVAL_VC	TPM_AMOUNT	CURR	21	2	Delta Swap Valuation in Valuation Currency
119	AMOUNT_PC	☐	FTI_D_AMOUNT_PC	TPM_AMOUNT	CURR	21	2	Flow Amount in Position Currency
120	AMOUNT_LC	☐	FTI_D_AMOUNT_LC	TPM_AMOUNT	CURR	21	2	Flow Amount in Local Currency
121	AMOUNT_VC	☐	FTI_D_AMOUNT_VC	TPM_AMOUNT	CURR	21	2	Flow Amount in Valuation Currency
122	PLAMOUNT_PLC	☐	FTI_PLAMOUNT_PLC	TPM_AMOUNT	CURR	21	2	Profit/loss amount in profit/loss currency
123	PLAMOUNT_LC	☐	FTI_PLAMOUNT_LC	TPM_AMOUNT	CURR	21	2	Profit/loss amount in local currency
124	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
125	CREATE_NAME	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
126	CREATE_DATE	☐	DERF	DATUM	DATS	8	0	First Entered on
127	CREATE_TIME	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
128	REQUEST_ID	☐	RSREQUNR	RSREQUNR	CHAR	30	0	Request number for the data transfer
129	REQUEST_DATE	☐	FTI_BI_REQUEST_DATE	DATUM	DATS	8	0	Date of Position Currency Request
130	REQUEST_TIME	☐	FTI_BI_REQUEST_TIME	TIMES	TIMS	6	0	Time of Position Currency Request

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FTI_BI_REP_ODS	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
2	FTI_BI_REP_ODS	ACC_ASS_REF	TRACC_AA_REF	AA_REF
3	FTI_BI_REP_ODS	BUKRS	T001	BUKRS
4	FTI_BI_REP_ODS	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
5	FTI_BI_REP_ODS	FLOW_TYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE
6	FTI_BI_REP_ODS	GEN_BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
7	FTI_BI_REP_ODS	GSART	TZPA	GSART
8	FTI_BI_REP_ODS	MANDT	T000	MANDT
9	FTI_BI_REP_ODS	PLWHR	TCURC	WAERS
10	FTI_BI_REP_ODS	PL_CATEGORY	TRGC_PL_CATE	PL_CATEGORY
11	FTI_BI_REP_ODS	PORTFOLIO	TWPOB	RPORTB
12	FTI_BI_REP_ODS	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT
13	FTI_BI_REP_ODS	RKONTRA	BUT000	PARTNER
14	FTI_BI_REP_ODS	SBWHR	TCURC	WAERS
15	FTI_BI_REP_ODS	SECURITY_ACCOUNT	TWD01	RLDEPO
16	FTI_BI_REP_ODS	SECURITY_ID	VWPANLA	RANL
17	FTI_BI_REP_ODS	SHWHR	TCURC	WAERS
18	FTI_BI_REP_ODS	SVWHR	TCURC	WAERS
19	FTI_BI_REP_ODS	TR_ACC_CODE	TRGC_TR_ACC_CODE	TR_ACC_CODE
20	FTI_BI_REP_ODS	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA
21	FTI_BI_REP_ODS	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS

History

Last changed by/on	SAP	20130529
SAP Release Created in	600