	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

169 COLUMNS | 2 INDEXES | ERP 6.0 | FTI_BI_REP_ODS TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Information System
1	ERP EHP7	6.0	FTI_BI_REP_ODS	169	2	Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW	Information System

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, VALUATION_AREA, BUSTRANSID, TRLFLOWNUMBER, BUKRS, TR_ACC_CODE, VALUATION_CLASS, GSART, PORTFOLIO, SECURITY_ID, LOANS_CONTRACT, DEAL_NUMBER, HEDGE_ID, ACCOUNT_GROUP, SECURITY_ACCOUNT, POSITION_ACCOUNT, FLAG_LONG_SHORT, LOT_ID, DLOTGENERATION, TLOTGENERATION, LOTGENERATION_US, LOTGENERATION_CT, LOTPOS_INIT_DATE, LOTPOS_ORG_DATE, LOTGEN_DEALNR, HREL_NUMBER, FISCAL_YEAR, HITEM_NUMBER, HINST_NUMBER, FIKRS, FUND, GRANT_NBR, ACC_ASS_REF, HKONT, DBESTAND, SE_DEAL_NUMBER, RKONTRA, FLOW_TYPE, BUSTRANSCAT, GEN_BUSTRANSCAT, SOURCETARGET_FLG, QUANT_CAT, AMOUNT_CAT, TRL_BOOKINGSTATE, PL_CATEGORY, LEDGER_POST_STAT, BELNR, AWKEY, GL_ACCOUNT_D, GL_ACCOUNT_C, DBUDAT, DGJAHR, DMONAT, PERIO, SZBMETH, DBERVON, DBERBIS, SINCLVON, SINCLBIS, SSOLHAB, SHWHR, SVWHR, SBWHR, PLWHR, D_UNITS, D_NOMINAL_AMT_PC, D_NOMINAL_ORG_PC, D_PURCH_PC, D_PURCH_LC, D_PURCH_VC, D_AQU_VAL_PC, D_AQU_VAL_LC, D_AQU_VAL_VC, D_BOOK_VAL_PC, D_BOOK_VAL_LC, D_BOOK_VAL_VC, D_CHARGE_PC, D_CHARGE_LC, D_CHARGE_VC, D_BOOK_VAL_EX_PC, D_BOOK_VAL_EX_LC, D_BOOK_VAL_EX_VC, D_VAL_TI_PC, D_VAL_TI_LC, D_VAL_TI_VC, D_VAL_FX_LC, D_VAL_FX_VC, D_VALFXAAQUVL_LC, D_VALFXAAQUVL_VC, D_VAL_CH_TI_PC, D_VAL_CH_TI_LC, D_VAL_CH_TI_VC, D_VAL_CH_FX_LC, D_VAL_CH_FX_VC, D_AMORT_PC, D_AMORT_LC, D_AMORT_VC, D_IMPMNT_PC, D_IMPMNT_LC, D_IMPMNT_VC, D_IMPMNT_FX_LC, D_IMPMNT_FX_VC, D_REPAYMENT_PC, D_REPAYMENT_LC, D_REPAYMENT_VC, D_AMAQU_VAL_PC, D_AMAQU_VAL_LC, D_AMAQU_VAL_VC, D_DISAGIO_PC, D_DISAGIO_LC, D_DISAGIO_VC, D_VAL_TI_NPL_PC, D_VAL_TI_NPL_LC, D_VAL_TI_NPL_VC, D_VAL_FX_NPL_LC, D_VAL_FX_NPL_VC, D_VAL_CH_TI_N_PC, D_VAL_CH_TI_N_LC, D_VAL_CH_TI_N_VC, D_VAL_CH_FX_N_LC, D_VAL_CH_FX_N_VC, D_VARMAR_PC, D_VARMAR_LC, D_VARMAR_VC, D_SPOTVALP_LC, D_SPOTVALP_VC, D_SPOTVALS_LC, D_SPOTVALS_VC, D_SWAPACC_PC, D_SWAPACC_LC, D_SWAPACC_VC, D_SWAPVAL_LC, D_SWAPVAL_VC, AMOUNT_PC, AMOUNT_LC, AMOUNT_VC, PLAMOUNT_PLC, PLAMOUNT_LC, D_ORIG_VAD_LC, D_ORIG_VAD_PC, D_ORIG_VAD_VC, D_VAD_GAIN_LC, D_VAD_GAIN_PC, D_VAD_GAIN_VC, D_VAD_LOSS_LC, D_VAD_LOSS_PC, D_VAD_LOSS_VC, D_HADJ_LC, D_HADJ_PC, D_HADJ_VC, D_EFFECTIVE_LC, D_EFFECTIVE_PC, D_EFFECTIVE_VC, D_EFF_DORMANT_LC, D_EFF_DORMANT_PC, D_EFF_DORMANT_VC, D_INEFFECTIVE_LC, D_INEFFECTIVE_PC, D_INEFFECTIVE_VC, D_INEFF_DORM_LC, D_INEFF_DORM_P, D_INEFF_DORM_V, UPDMOD, CREATE_NAME, CREATE_DATE, CREATE_TIME, REQUEST_ID, REQUEST_DATE, REQUEST_TIME FROM FTI_BI_REP_ODS

TOP ERP 6.0 | FTI_BI_REP_ODS COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	VALUATION_AREA	Valuation Area	nvarchar	3	0	CHAR	(N' ')	No	TRGC_VAL_AREA	TPM_VAL_AREA	Allow NULL?
3	BUSTRANSID	Identifier of the Distributor Business Transaction	varbinary	16	0	RAW		No		TPM_BUSTRANSID
4	TRLFLOWNUMBER	Number of TRL Flow	int	10	0	INT4	((0))	No		TPM_TRLFLOWNR	Allow NULL?
5	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
6	TR_ACC_CODE	Accounting Code	nvarchar	4	0	CHAR	(N' ')	Yes	TRGC_TR_ACC_CODE	TPM_ACC_CODE	Allow NULL?
7	VALUATION_CLASS	Valuation Class	nvarchar	4	0	NUMC	(N'0000')	Yes	TRGC_VAL_CLASS	TPM_VAL_CLASS	Allow NULL?
8	GSART	Product Type	nvarchar	3	0	CHAR	(N' ')	Yes	TZPA	VVSART	Allow NULL?
9	PORTFOLIO	Portfolio	nvarchar	10	0	CHAR	(N' ')	Yes	TWPOB	RPORTB	Allow NULL?
10	SECURITY_ID	Security ID Number	nvarchar	13	0	CHAR	(N' ')	Yes	VWPANLA	VVRANLW	Allow NULL?
11	LOANS_CONTRACT	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RANL	Allow NULL?
12	DEAL_NUMBER	Position-Generating Financial Transaction	nvarchar	13	0	CHAR	(N' ')	Yes	*	FTI_POSRFHA	Allow NULL?
13	HEDGE_ID	Identification Number of Hedge Item	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	THM_HEDGE_ID	Allow NULL?
14	ACCOUNT_GROUP	Securities Account Group	nvarchar	10	0	CHAR	(N' ')	Yes	TRGT_SECACCGRP	TPM_SEC_ACCT_GRP	Allow NULL?
15	SECURITY_ACCOUNT	Securities Account	nvarchar	10	0	CHAR	(N' ')	Yes	TWD01	VRLDEPO	Allow NULL?
16	POSITION_ACCOUNT	Futures Account for Listed Options and Futures	nvarchar	10	0	CHAR	(N' ')	Yes	TRFT_POS_ACCOUNT	TPM_POS_ACCOUNT_FUT	Allow NULL?
17	FLAG_LONG_SHORT	Indicator: Long or Short Position	char	1	0	CHAR	(N' ')	Yes		TPM_FLAG_LONG_SHORT	Allow NULL?
18	LOT_ID	Identifier of the Lot	varbinary	16	0	RAW		Yes		TPM_LOT_ID
19	DLOTGENERATION	Date On Which Lot Was Generated	nvarchar	8	0	DATS	(N'00000000')	Yes		DLOTGENERATION	Allow NULL?
20	TLOTGENERATION	Lot Generation Time	nvarchar	6	0	TIMS	(N'000000')	Yes		TLOTGENERATION	Allow NULL?
21	LOTGENERATION_US	Lot Entered By	nvarchar	12	0	CHAR	(N' ')	Yes		FTI_LOTGENERATIONUSER	Allow NULL?
22	LOTGENERATION_CT	Business Transaction Category Which Generated the Lot	nvarchar	4	0	NUMC	(N'0000')	Yes	*	FTI_LOTGENERATION_BUSTRANSCAT	Allow NULL?
23	LOTPOS_INIT_DATE	Position Acquisition Date of a Lot	nvarchar	8	0	DATS	(N'00000000')	Yes		FTI_LOTPOSITION_INIT_DATE	Allow NULL?
24	LOTPOS_ORG_DATE	Original Position Acquisition Date of a Lot	nvarchar	8	0	DATS	(N'00000000')	Yes		FTI_LOTPOSITION_ORG_DATE	Allow NULL?
25	LOTGEN_DEALNR	Lot-Generating Transaction Number (Listed Derivatives)	nvarchar	13	0	CHAR	(N' ')	Yes	*	FTI_LOTGENERATION_DEALNR	Allow NULL?
26	HREL_NUMBER	Hedging Relationship Number (External/Internal)	nvarchar	10	0	CHAR	(N' ')	Yes		TPM_HREL_NUMBER	Allow NULL?
27	FISCAL_YEAR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
28	HITEM_NUMBER	Hedged Item Number	nvarchar	10	0	CHAR	(N' ')	Yes		TPM_HITEM_NUMBER	Allow NULL?
29	HINST_NUMBER	Hedging Instrument Number	nvarchar	10	0	CHAR	(N' ')	Yes		TPM_HINST_NUMBER	Allow NULL?
30	FIKRS	Financial Management Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	FIKRS	Allow NULL?
31	FUND	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_FUND	Allow NULL?
32	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
33	ACC_ASS_REF	Account Assignment Reference of Position Management	nvarchar	12	0	CHAR	(N' ')	Yes	TRACC_AA_REF	TPM_AA_REF	Allow NULL?
34	HKONT	General ledger account	nvarchar	10	0	CHAR	(N' ')	Yes	*	FTI_HKONT	Allow NULL?
35	DBESTAND	Position value date	nvarchar	8	0	DATS	(N'00000000')	Yes		DBESTAND	Allow NULL?
36	SE_DEAL_NUMBER	Securities/Futures Transaction	nvarchar	13	0	CHAR	(N' ')	Yes	*	FTI_SE_RFHA	Allow NULL?
37	RKONTRA	Reference to Counterparty	nvarchar	10	0	CHAR	(N' ')	Yes	BUT000	RKONTRA_NEW	Allow NULL?
38	FLOW_TYPE	Update Type	nvarchar	8	0	CHAR	(N' ')	Yes	TRDC_DFLOWTYPE	TPM_DIS_FLOWTYPE	Allow NULL?
39	BUSTRANSCAT	Business Transaction Category	nvarchar	4	0	NUMC	(N'0000')	Yes	TRDTS_BT_CAT	TPM_BUSTRANSCAT	Allow NULL?
40	GEN_BUSTRANSCAT	Generating Business Transaction Category	nvarchar	4	0	NUMC	(N'0000')	Yes	TRDTS_BT_CAT	FTI_GENERATING_BUSTRANSCAT	Allow NULL?
41	SOURCETARGET_FLG	Indicator: Source or Target of a Flow	char	1	0	CHAR	(N' ')	Yes		TPM_SOURCE_TARGET_FLG	Allow NULL?
42	QUANT_CAT	Position Change Category: Quantity	nvarchar	4	0	CHAR	(N' ')	Yes		FTI_QTY_PM_CAT	Allow NULL?
43	AMOUNT_CAT	Position Change Category	nvarchar	4	0	CHAR	(N' ')	Yes	*	FTI_AMT_PM_CAT	Allow NULL?
44	TRL_BOOKINGSTATE	Posting Status Treasury Ledger Business Transaction	char	1	0	CHAR	(N' ')	Yes		TPM_TRL_BOOKINGSTATE	Allow NULL?
45	PL_CATEGORY	P/L Type	nvarchar	3	0	CHAR	(N' ')	Yes	TRGC_PL_CATE	TPM_PL_CATEGORY	Allow NULL?
46	LEDGER_POST_STAT	Ledger Posting Status	char	1	0	CHAR	(N' ')	Yes		FTR_LEDGER_POSTING_STATE	Allow NULL?
47	BELNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
48	AWKEY	Reference Key	nvarchar	20	0	CHAR	(N' ')	Yes		AWKEY	Allow NULL?
49	GL_ACCOUNT_D	Number of G/L Account: Debit	nvarchar	10	0	CHAR	(N' ')	Yes	*	FTI_GLACC_D	Allow NULL?
50	GL_ACCOUNT_C	Number of G/L Account: Credit	nvarchar	10	0	CHAR	(N' ')	Yes	*	FTI_GLACC_C	Allow NULL?
51	DBUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
52	DGJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
53	DMONAT	Fiscal Period	nvarchar	2	0	NUMC	(N'00')	Yes		MONAT	Allow NULL?
54	PERIO	Period/year	nvarchar	7	0	NUMC	(N'0000000')	Yes		JAHRPER	Allow NULL?
55	SZBMETH	Interest Calculation Method	char	1	0	CHAR	(N' ')	Yes		SZBMETH	Allow NULL?
56	DBERVON	Start of Calculation Period	nvarchar	8	0	DATS	(N'00000000')	Yes		DBERVON	Allow NULL?
57	DBERBIS	End of Calculation Period	nvarchar	8	0	DATS	(N'00000000')	Yes		DBERBIS	Allow NULL?
58	SINCLVON	Inclusive indicator for beginning and end of a period	char	1	0	NUMC	(N'0')	Yes		VVSINCL	Allow NULL?
59	SINCLBIS	Inclusive indicator for beginning and end of a period	char	1	0	NUMC	(N'0')	Yes		VVSINCL	Allow NULL?
60	SSOLHAB	Debit/credit indicator	char	1	0	CHAR	(N' ')	Yes		VVSSOLHAB	Allow NULL?
61	SHWHR	Local Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TB_SHWHR	Allow NULL?
62	SVWHR	Valuation Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TPM_VALUATION_CURR	Allow NULL?
63	SBWHR	Position Currency/Transaction Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TB_BWHR	Allow NULL?
64	PLWHR	Profit/loss currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	SPLWHR	Allow NULL?
65	D_UNITS	Delta Number of Units	decimal	22	6	DEC	((0))	Yes		FTI_D_UNITS
66	D_NOMINAL_AMT_PC	Delta Nominal Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_NOMINAL_AMT_PC
67	D_NOMINAL_ORG_PC	Delta: Original Nominal Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_NOMINAL_ORG_AMT_PC
68	D_PURCH_PC	Delta Purchase Value in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_PURCH_PC
69	D_PURCH_LC	Delta Purchase Value in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_PURCH_LC
70	D_PURCH_VC	Delta Purchase Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_PURCH_VC
71	D_AQU_VAL_PC	Delta Acquisition Value in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AQU_VAL_PC
72	D_AQU_VAL_LC	Delta Acquisition Value in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AQU_VAL_LC
73	D_AQU_VAL_VC	Delta Acquisition Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AQU_VAL_VC
74	D_BOOK_VAL_PC	Delta Book Value in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_BOOK_VAL_PC
75	D_BOOK_VAL_LC	Delta Book Value in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_BOOK_VAL_LC
76	D_BOOK_VAL_VC	Delta Book Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_BOOK_VAL_VC
77	D_CHARGE_PC	Delta Costs in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_CHARGE_PC
78	D_CHARGE_LC	Delta Costs in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_CHARGE_LC
79	D_CHARGE_VC	Delta Costs in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_CHARGE_VC
80	D_BOOK_VAL_EX_PC	Delta Book Value Excl. Costs in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_BOOK_VAL_EX_PC
81	D_BOOK_VAL_EX_LC	Delta Book Value Excl. Costs in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_BOOK_VAL_EX_LC
82	D_BOOK_VAL_EX_VC	Delta Book Value Excl. Costs in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_BOOK_VAL_EX_VC
83	D_VAL_TI_PC	Delta Security Valuation in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_TI_PC
84	D_VAL_TI_LC	Delta Security Valuation in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_TI_LC
85	D_VAL_TI_VC	Delta Security Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_TI_VC
86	D_VAL_FX_LC	Delta Foreign Currency Valuation in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_FX_LC
87	D_VAL_FX_VC	Delta Foreign Currency Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_FX_VC
88	D_VALFXAAQUVL_LC	FX Valuation of Amort. Acquisition Value in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_FX_AMAQU_VAL_LC
89	D_VALFXAAQUVL_VC	Delta Valuation of FX, Amort. Acquisition Value in VC	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_FX_AMAQU_VAL_VC
90	D_VAL_CH_TI_PC	Delta Valuation of Capitalized Costs, Security, in PC	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_TI_PC
91	D_VAL_CH_TI_LC	Delta Valuation of Capitalized Costs, Security, in LC	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_TI_LC
92	D_VAL_CH_TI_VC	Delta Valuation of Capitalized Costs, Security, in VC	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_TI_VC
93	D_VAL_CH_FX_LC	Delta Valuation of Capitalized Costs, FX, in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_FX_LC
94	D_VAL_CH_FX_VC	Delta Valuation of Capitalized Costs, FX, in Valuation Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_FX_VC
95	D_AMORT_PC	Delta Amortization in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMORT_PC
96	D_AMORT_LC	Delta Amortization in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMORT_LC
97	D_AMORT_VC	Delta Amortization in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMORT_VC
98	D_IMPMNT_PC	Delta Impairment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_IMPMNT_PC
99	D_IMPMNT_LC	Delta Impairment in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_IMPMNT_LC
100	D_IMPMNT_VC	Delta Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_IMPMNT_VC
101	D_IMPMNT_FX_LC	Delta FX Impairment in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_IMPMNT_FX_LC
102	D_IMPMNT_FX_VC	Delta FX Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_IMPMNT_FX_VC
103	D_REPAYMENT_PC	Delta: Cumulative Repayment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_REPAYMENT_PC
104	D_REPAYMENT_LC	Delta: Cumulative Repayment in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_REPAYMENT_LC
105	D_REPAYMENT_VC	Delta: Cumulative Repayment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_REPAYMENT_VC
106	D_AMAQU_VAL_PC	Delta Amortized Acquisition Value in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMAQU_VAL_PC
107	D_AMAQU_VAL_LC	Delta Amortized Acquisition Value in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMAQU_VAL_LC
108	D_AMAQU_VAL_VC	Delta Amortized Acquisition Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMAQU_VAL_VC
109	D_DISAGIO_PC	Delta Cleared PD Def./Tax Compensation in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_DISAGIO_PC
110	D_DISAGIO_LC	Delta Cleared PD Def./Tax Compensation in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_DISAGIO_LC
111	D_DISAGIO_VC	Delta Cleared PD Def./Tax Compensation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_DISAGIO_VC
112	D_VAL_TI_NPL_PC	Delta Security Valuation, Not Affecting P/L, in Pos. Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_TI_NPL_PC
113	D_VAL_TI_NPL_LC	Delta Security Valuation, Not Affecting P/L, in Local Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_TI_NPL_LC
114	D_VAL_TI_NPL_VC	Delta Security Valuation, Not Affecting P/L, in Val. Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_TI_NPL_VC
115	D_VAL_FX_NPL_LC	Delta Foreign Currency Valuation, Not Affecting P/L, in LC	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_FX_NPL_LC
116	D_VAL_FX_NPL_VC	Delta Foreign Currency Valuation, Not Affecting P/L, in VC	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_FX_NPL_VC
117	D_VAL_CH_TI_N_PC	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Position Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_TI_NPL_PC
118	D_VAL_CH_TI_N_LC	Delta Val.of Cap.Costs, Sec., Not Aff. P/L, in Local Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_TI_NPL_LC
119	D_VAL_CH_TI_N_VC	Delta Val. of Costs, Sec., Not Aff. P/L in Valuation Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_TI_NPL_VC
120	D_VAL_CH_FX_N_LC	Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Local Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_FX_NPL_LC
121	D_VAL_CH_FX_N_VC	Delta Val.of Cap.Costs, FX, Not Affecting P/L, in Val. Crcy	decimal	21	2	CURR	((0))	Yes		FTI_D_VAL_CH_FX_NPL_VC
122	D_VARMAR_PC	Delta Variation Margin in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VARMAR_PC
123	D_VARMAR_LC	Delta Variation Margin in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VARMAR_LC
124	D_VARMAR_VC	Delta Variation Margin in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VARMAR_VC
125	D_SPOTVALP_LC	Delta Spot Valuation of Purchase Crcy in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SPOTVALP_LC
126	D_SPOTVALP_VC	Delta Spot Valuation of Purchase Crcy in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SPOTVALP_VC
127	D_SPOTVALS_LC	Delta Spot Valuation of Sale Currency in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SPOTVALS_LC
128	D_SPOTVALS_VC	Delta Spot Valuation of Sale Currency in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SPOTVALS_VC
129	D_SWAPACC_PC	Delta Swap/Margin Accrual/Deferral in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SWAPACC_PC
130	D_SWAPACC_LC	Delta Swap/Margin Accrual/Deferral in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SWAPACC_LC
131	D_SWAPACC_VC	Delta Swap/Margin Accrual/Deferral in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SWAPACC_VC
132	D_SWAPVAL_LC	Delta Swap Valuation in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SWAPVAL_LC
133	D_SWAPVAL_VC	Delta Swap Valuation in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_SWAPVAL_VC
134	AMOUNT_PC	Flow Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMOUNT_PC
135	AMOUNT_LC	Flow Amount in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMOUNT_LC
136	AMOUNT_VC	Flow Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_AMOUNT_VC
137	PLAMOUNT_PLC	Profit/loss amount in profit/loss currency	decimal	21	2	CURR	((0))	Yes		FTI_PLAMOUNT_PLC
138	PLAMOUNT_LC	Profit/loss amount in local currency	decimal	21	2	CURR	((0))	Yes		FTI_PLAMOUNT_LC
139	D_ORIG_VAD_LC	Delta Original Value Adjustment in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_ORIG_VAD_LC
140	D_ORIG_VAD_PC	Delta Original Value Adjustment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_ORIG_VAD_PC
141	D_ORIG_VAD_VC	Delta Original Value Adjustment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_ORIG_VAD_VC
142	D_VAD_GAIN_LC	Delta Value Adjustment of Gains in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAD_GAIN_LC
143	D_VAD_GAIN_PC	Delta Value Adjustment of Gains in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAD_GAIN_PC
144	D_VAD_GAIN_VC	Delta Value Adjustment of Gains in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAD_GAIN_VC
145	D_VAD_LOSS_LC	Delta Value Adjustment of Losses in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAD_LOSS_LC
146	D_VAD_LOSS_PC	Delta Value Adjustment of Losses in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAD_LOSS_PC
147	D_VAD_LOSS_VC	Delta Value Adjustment of Losses in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_VAD_LOSS_VC
148	D_HADJ_LC	Delta Hedge Adjustment in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_HADJ_LC
149	D_HADJ_PC	Delta Hedge Adjustment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_HADJ_PC
150	D_HADJ_VC	Delta Hedge Adjustment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_HADJ_VC
151	D_EFFECTIVE_LC	Delta Effective Amount in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_EFFECTIVE_LC
152	D_EFFECTIVE_PC	Delta Effective Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_EFFECTIVE_PC
153	D_EFFECTIVE_VC	Delta Effective Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_EFFECTIVE_VC
154	D_EFF_DORMANT_LC	Delta Effective Dormant Amount in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_EFFECTIVE_DORMANT_LC
155	D_EFF_DORMANT_PC	Delta Effective Dormant Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_EFFECTIVE_DORMANT_PC
156	D_EFF_DORMANT_VC	Delta Effective Dormant Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_EFFECTIVE_DORMANT_VC
157	D_INEFFECTIVE_LC	Delta Ineffective Amount in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_INEFFECTIVE_LC
158	D_INEFFECTIVE_PC	Delta Ineffective Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_INEFFECTIVE_PC
159	D_INEFFECTIVE_VC	Delta Ineffective Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_INEFFECTIVE_VC
160	D_INEFF_DORM_LC	Delta Ineffective Dormant Amount in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_INEFFECTIVE_DORMANT_LC
161	D_INEFF_DORM_P	Delta Ineffective Dormant Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_INEFFECTIVE_DORMANT_PC
162	D_INEFF_DORM_V	Delta Ineffective Dormant Amount in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_D_INEFFECTIVE_DORMANT_VC
163	UPDMOD	BW Delta Process: Record Mode	char	1	0	CHAR	(N' ')	Yes		RODMUPDMOD	Allow NULL?
164	CREATE_NAME	Entered by	nvarchar	12	0	CHAR	(N' ')	Yes		RERF	Allow NULL?
165	CREATE_DATE	First Entered on	nvarchar	8	0	DATS	(N'00000000')	Yes		DERF	Allow NULL?
166	CREATE_TIME	Time of Initial Entry	nvarchar	6	0	TIMS	(N'000000')	Yes		TERF	Allow NULL?
167	REQUEST_ID	Request number for the data transfer	nvarchar	30	0	CHAR	(N' ')	Yes		RSREQUNR	Allow NULL?
168	REQUEST_DATE	Date of Position Currency Request	nvarchar	8	0	DATS	(N'00000000')	Yes		FTI_BI_REQUEST_DATE	Allow NULL?
169	REQUEST_TIME	Time of Position Currency Request	nvarchar	6	0	TIMS	(N'000000')	Yes		FTI_BI_REQUEST_TIME	Allow NULL?

TOP ERP 6.0 | FTI_BI_REP_ODS INDEXES

Name	Primary	Unique	Type	Columns
FTI_BI_REP_ODS~0	Yes	Yes	CLUSTERED	TRLFLOWNUMBER, BUSTRANSID, VALUATION_AREA, MANDT
FTI_BI_REP_ODS~001	No	No	NONCLUSTERED	REQUEST_ID, BUKRS, VALUATION_AREA

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

169 COLUMNS | 2 INDEXES | ERP 6.0 | FTI_BI_REP_ODS TABLE

TOP ERP 6.0 | FTI_BI_REP_ODS COLUMNS

TOP ERP 6.0 | FTI_BI_REP_ODS INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

169 COLUMNS | 2 INDEXES | ERP 6.0 | FTI_BI_REP_ODS TABLE

TOPERP 6.0 | FTI_BI_REP_ODS COLUMNS

TOPERP 6.0 | FTI_BI_REP_ODS INDEXES

TOP ERP 6.0 | FTI_BI_REP_ODS COLUMNS

TOP ERP 6.0 | FTI_BI_REP_ODS INDEXES