ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	IDCFM_FRIM_DATA	110	2	Impairment Main Data	Transaction Manager

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	VALUATION_CLASS	Valuation Class	nvarchar	4	0	NUMC	(N'0000')	No	TRGC_VAL_CLASS	TPM_VAL_CLASS	Allow NULL?
4	COMPANY_CODE	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
5	SECURITY_ACCOUNT	Securities Account	nvarchar	10	0	CHAR	(N' ')	No	TWD01	RLDEPO	Allow NULL?
6	SECURITY_ID	Security ID Number	nvarchar	13	0	CHAR	(N' ')	No	VWPANLA	VVRANLW	Allow NULL?
7	PORTFOLIO	Portfolio	nvarchar	10	0	CHAR	(N' ')	No	TWPOB	RPORTB	Allow NULL?
8	ACCOUNT_GROUP	Securities Account Group	nvarchar	10	0	CHAR	(N' ')	No	TRGT_SECACCGRP	TPM_SEC_ACCT_GRP	Allow NULL?
9	LOANS_CONTRACT	Contract Number	nvarchar	13	0	CHAR	(N' ')	No		RANL	Allow NULL?
10	KEY_DATE	Key Date for Valuation	nvarchar	8	0	DATS	(N'00000000')	No		TPM_VAL_KEYDATE	Allow NULL?
11	PRICE_TYPE	Rate/Price Type - Treasury Instruments	nvarchar	2	0	CHAR	(N' ')	No	TW56	TI_KURSART	Allow NULL?
12	OKUART	Price/NPV Type for OTC Transactions	nvarchar	3	0	CHAR	(N' ')	No	ATVOK	TV_OKUART	Allow NULL?
13	LOT_ID	Identifier of the Lot	varbinary	16	0	RAW		No		TPM_LOT_ID
14	FUND	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	FM_FUND	Allow NULL?
15	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	No		GM_GRANT_NBR	Allow NULL?
16	RUN_KEY	Technical Key for a Background Run	char	1	0	CHAR	(N' ')	No		IDCFM_FRIM_RUN_KEY	Allow NULL?
17	RUN_DATE	Date of Impairment Run	nvarchar	8	0	DATS	(N'00000000')	Yes		IDCFM_FRIM_RUN_DATE	Allow NULL?
18	RUN_ID	Unique ID of Impairment Run on Date Specified	nvarchar	8	0	NUMC	(N'00000000')	Yes		IDCFM_FRIM_RUN_ID	Allow NULL?
19	PFUND	Partner Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_PFUND	Allow NULL?
20	SP_VAL_SEC_CAT	Special Valuation Category	char	1	0	CHAR	(N' ')	Yes		TPM_SP_VAL_SEC_CAT	Allow NULL?
21	PRICE_CURR	Quotation currency (which prices are in)	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	VVNOTWAERS	Allow NULL?
22	SECURITY_PRICE	Price of Unit- or Percentage-Quoted Security	decimal	15	6	DEC	((0))	Yes		VVPKTKUR
23	PRESENT_VALUE	NPV in Transaction Currency for Special Valuation	decimal	15	2	CURR	((0))	Yes		TPM_PRES_VAL_FOR_AMT
24	PV_CURR	Transaction Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TPM_FOREIGN_CURR	Allow NULL?
25	PV_VAL_AMT	NPV in Valuation Currency for Special Valuation	decimal	15	2	CURR	((0))	Yes		TPM_PRES_VAL_VAL_AMT
26	PV_VAL_CURR	Valuation Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TPM_VALUATION_CURR	Allow NULL?
27	GSART	Product Type	nvarchar	3	0	CHAR	(N' ')	Yes	TZPA	VVSART	Allow NULL?
28	PERIOD_BEGIN	Date for Period Start of Selection Report Impairment	nvarchar	8	0	DATS	(N'00000000')	Yes		FTI_IMPAIR_PERIOD_BEGIN	Allow NULL?
29	PERIOD_END	Date for Period End of Selection Report Impairment	nvarchar	8	0	DATS	(N'00000000')	Yes		FTI_IMPAIR_PERIOD_END	Allow NULL?
30	KEY_DATE_REF	Key Date Reference for Parallel Books	char	1	0	CHAR	(N' ')	Yes		FTI_RSTICH_PB	Allow NULL?
31	PC_CURRENCY	Position Currency (Currency of Position Amount)	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	SBWHR	Allow NULL?
32	VC_CURRENCY	Valuation Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TPM_VALUATION_CURR	Allow NULL?
33	EXCHANGE_PC_VC	Rate Type Translation from Position Crcy to Valtn Crcy	nvarchar	4	0	CHAR	(N' ')	Yes	TCURV	FTI_IMPAIR_KURST_BEWW	Allow NULL?
34	UNITS	Number of units	decimal	22	6	DEC	((0))	Yes		FTI_UNITS
35	NOMINAL_AMT_PC	Nominal Amount in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_NOMINAL_AMT_PC
36	AQU_VAL_PC	Acquisition Value in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_AQU_VAL_PC
37	AQU_VAL_VC	Acquisition Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_AQU_VAL_VC
38	AQU_VAL_PC_RP	Acquisition Price for Percentage-Quoted Securities in %	decimal	15	6	DEC	((0))	Yes		FTI_ANKUPR
39	AQU_VAL_PC_RU	Acquisition Price f. Unit-Quoted Securities in Position Crcy	decimal	15	6	DEC	((0))	Yes		FTI_ANKSBW
40	AQU_VAL_VC_RU	Acquisition Price for Unit-Quoted SEC in Valuation Currency	decimal	15	6	DEC	((0))	Yes		FTI_IMPAIR_AQU_VC_RATE_UNITS
41	RATE_MATURITY	Maximum Age of a Market Price for Impairment	decimal	3	0	DEC	((0))	Yes		FTI_IMPAIR_RATE_MATURITY
42	RATE_INDICATOR	Price Type for Securities (Optional Entry)	nvarchar	2	0	CHAR	(N' ')	Yes	TW56	FTI_KURSART	Allow NULL?
43	EXCHANGE_NC_PC	Rate Type for Translation from Quotation Currency to PC	nvarchar	4	0	CHAR	(N' ')	Yes	TCURV	FTI_IMPAIR_KURST_CURR	Allow NULL?
44	RATE_KEY_DATE	Rate/Price Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DKURS	Allow NULL?
45	MARKET_PLACE	Exchange	nvarchar	10	0	CHAR	(N' ')	Yes	TWH01	VVRHANDPL	Allow NULL?
46	NPV_INDICATOR	Price/NPV Type for OTC Transactions	nvarchar	3	0	CHAR	(N' ')	Yes	ATVOK	TV_OKUART	Allow NULL?
47	MARKET_PC	Market Value in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_MARKET_PC
48	MARKET_VC	Market Value (SE Only) in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_IMPAIR_MARKET_VC
49	MARKET_PC_RP	Market Price / % (Percentage-Quoted Securities)	decimal	15	6	DEC	((0))	Yes		FTI_KURSPR
50	MARKET_PC_RU	Market Price/Unit in Position Crcy (Unit-Quoted Securities)	decimal	15	6	DEC	((0))	Yes		FTI_KURSBW
51	MARKET_VC_RU	Market Price / Unit in Valuation Currency	decimal	15	6	DEC	((0))	Yes		FTI_IMPAIR_MARKET_VC_RATE_UNIT
52	MARKET_PC_MEAN	Mean Market Value (only SEC) in Postion Currency	decimal	21	2	CURR	((0))	Yes		FTI_IMPAIR_MARKET_PC_MEAN
53	MARKET_PC_MEANP	Mean Market Price / % (for Percentage-Quoted SEC)	decimal	15	6	DEC	((0))	Yes		FTI_IMPAIR_KURSPR_MEAN
54	MARKET_PC_MEANU	Mean Market Price/Unit in Postion Currency (Unit-Quoted SEC)	decimal	15	6	DEC	((0))	Yes		FTI_IMPAIR_KURSBW_MEAN
55	KEY_DATE_FLAG	Flag Selection Criteria 1: Compare on Key Date	char	1	0	CHAR	(N' ')	Yes		FTI_IMPAIR_KEY_DATE_FLAG	Allow NULL?
56	KEY_DATE_FLAGTXT	Flag Selection Criteria 1: Compare on Key Date	nvarchar	16	0	CHAR	(N' ')	Yes		FTI_IMPAIR_KEY_DATE_FLAG_TEXT	Allow NULL?
57	KEY_DATE_BARRIER	Selection Criteria 1: Limit in % (Impairment)	decimal	6	2	DEC	((0))	Yes		FTI_IMPAIR_BARRIER
58	KEY_DATE_RESULT	Selection Criteria 1: Relation in %	decimal	6	2	DEC	((0))	Yes		FTI_IMPAIR_BARRIER_RES
59	KEY_DATE_FLAGM	Flag Selection Criteria 2: Compare Average Val.and Key Date	char	1	0	CHAR	(N' ')	Yes		FTI_IMPAIR_KEY_DATE_FLAG_M	Allow NULL?
60	KEY_DATE_FLAGMTX	Flag Selection Criteria 2: Compare Average Val.and Key Date	nvarchar	16	0	CHAR	(N' ')	Yes		FTI_IMPAIR_KEY_DATE_FLAG_M_TEX	Allow NULL?
61	KEY_DATE_BARR_M	Selection Criteria 2: Limit Averaged in % (Impairment)	decimal	6	2	DEC	((0))	Yes		FTI_IMPAIR_BARRIER_MEAN
62	KEY_DATE_RESU_M	Selection Criteria 2: Relation Averaged Market Value in %	decimal	6	2	DEC	((0))	Yes		FTI_IMPAIR_BARRIER_RES_MEAN
63	PERIOD_FLAG	Indicator Selection Criteria 3: Comparison for Period	char	1	0	CHAR	(N' ')	Yes		FTI_IMPAIR_PERIOD_FLAG	Allow NULL?
64	PERIOD_FLAG_TEXT	Indicator Selection Criteria 3: Comparison for Period	nvarchar	16	0	CHAR	(N' ')	Yes		FTI_IMPAIR_PERIOD_FLAG_TEXT	Allow NULL?
65	PERIOD_BARRIER	Selection Criteria 3: Limit Maximum in % (Impairment)	decimal	6	2	DEC	((0))	Yes		FTI_IMPAIR_BARRIER_MAX
66	PERIOD_RESULT	Selection Criteria 3: Relation Maximum in %	decimal	6	2	DEC	((0))	Yes		FTI_IMPAIR_BARRIER_RES_MAX
67	WARN	Result for Selection Report Impairment	char	1	0	CHAR	(N' ')	Yes		FTI_IMPAIR_WARN	Allow NULL?
68	EXPORT	Flag for Exporting Positions for Impairment	char	1	0	CHAR	(N' ')	Yes		FTI_IMPAIR_EXPORT	Allow NULL?
69	AMAQU_VAL_PC	Amortized Acquisition Value in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_AMAQU_VAL_PC
70	AMAQU_VAL_LC	Amortized Acquisition Value in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_AMAQU_VAL_LC
71	AMAQU_VAL_VC	Amortized Acquisition Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_AMAQU_VAL_VC
72	AMAQU_VAL_DC	Amortized Acquisition Value in Display Currency (From PC)	decimal	21	2	CURR	((0))	Yes		FTI_AMAQU_VAL_DC
73	BOOK_VAL_PC	Book Value in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_BOOK_VAL_PC
74	BOOK_VAL_LC	Book Value in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_BOOK_VAL_LC
75	BOOK_VAL_VC	Book Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_BOOK_VAL_VC
76	BOOK_VAL_DC	Book Value in Display Currency (From Position Currency)	decimal	21	2	CURR	((0))	Yes		FTI_BOOK_VAL_DC
77	IMPMNT_PC	Impairment in Position Currency	decimal	21	2	CURR	((0))	Yes		FTI_IMPMNT_PC
78	IMPMNT_LC	Impairment in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_IMPMNT_LC
79	IMPMNT_VC	Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_IMPMNT_VC
80	IMPMNT_DC	Impairment in Display Currency	decimal	21	2	CURR	((0))	Yes		FTI_IMPMNT_DC
81	IMPMNT_FX_LC	FX Impairment in Local Currency	decimal	21	2	CURR	((0))	Yes		FTI_IMPMNT_FX_LC
82	IMPMNT_FX_VC	FX Impairment in Valuation Currency	decimal	21	2	CURR	((0))	Yes		FTI_IMPMNT_FX_VC
83	XALKZ	Short name	nvarchar	15	0	CHAR	(N' ')	Yes		XALKZ	Allow NULL?
84	VVRANLWI	No. of the secondary index description for class data	nvarchar	2	0	NUMC	(N'00')	Yes	TWX1	VVRANLWI	Allow NULL?
85	VVRANLWX	Secondary index class data	nvarchar	20	0	CHAR	(N' ')	Yes		VVRANLWX	Allow NULL?
86	MAX_RATE	Maximum Rate of Unit/Percentage-Quoted Security	decimal	15	6	DEC	((0))	Yes		VVPKTKUR_MAX
87	MAX_RATE_DATE	Rate Date: Maximum Rate	nvarchar	8	0	DATS	(N'00000000')	Yes		DKURS_MAX	Allow NULL?
88	MIN_RATE	Minimum Rate of Unit/Percentage-Quoted Security	decimal	15	6	DEC	((0))	Yes		VVPKTKUR_MIN
89	MIN_RATE_DATE	Rate Date: Minimum Rate	nvarchar	8	0	DATS	(N'00000000')	Yes		DKURS_MIN	Allow NULL?
90	MARKET_VC_MEAN	Average Market Value in Valuation Currency (Securities Only)	decimal	21	2	CURR	((0))	Yes		FTI_IMPAIR_MARKET_VC_MEAN
91	MARKET_VC_MEANU	Average Market Price/Unit in VC (Unit-Quoted Securities)	decimal	15	6	DEC	((0))	Yes		FTI_MARKET_VC_RATE_UNIT_MEAN
92	BUSTRANSCAT_INIT	Generating Business Transaction Category	nvarchar	4	0	NUMC	(N'0000')	Yes	*	FTI_GENERATING_BUSTRANSCAT	Allow NULL?
93	TRLDATE_INIT	Creation Date of the Operative Business Transaction	nvarchar	8	0	DATS	(N'00000000')	Yes		TPM_BT_CREATE_DATE	Allow NULL?
94	BUSTRANSCAT_INTT	Name of Business Transaction Category	nvarchar	60	0	CHAR	(N' ')	Yes		TPM_BUSTRANSCAT_TEXT	Allow NULL?
95	PORTF_DIST_PC	Portfolio Distribution in Position Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_PORTFOLIO_DIST_PC
96	PORTF_DIST_VC	Portfolio Distribution in Valuation Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_PORTFOLIO_DIST_VC
97	MARKET_VAL_PC	Market Value in Position Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_MARKET_VAL_PC
98	MARKET_VAL_LC	Market Value in Local Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_MARKET_VAL_LC
99	MARKET_VAL_VC	Market Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_MARKET_VAL_VC
100	MARKET_VAL_DC	Market Value in Display Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_MARKET_VAL_DC
101	EXPERT_VAL_PC	Expert Value in Position Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_EXPERT_VAL_PC
102	EXPERT_VAL_LC	Expert Value in Local Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_EXPERT_VAL_LC
103	EXPERT_VAL_VC	Expert Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_EXPERT_VAL_VC
104	EXPERT_VAL_DC	Expert Value in Display Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_EXPERT_VAL_DC
105	EXPECTED_VAL_PC	Expected Value in Position Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_EXPECTED_VAL_PC
106	EXPECTED_VAL_LC	Expected Value in Local Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_EXPECTED_VAL_LC
107	EXPECTED_VAL_VC	Expected Value in Valuation Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_EXPECTED_VAL_VC
108	EXPECTED_VAL_DC	Expected Value in Display Currency	decimal	21	2	CURR	((0))	Yes		IDCFM_FRIM_EXPECTED_VAL_DC
109	DATA_STATUS	Status of Impairment Item	char	1	0	CHAR	(N' ')	Yes		IDCFM_FRIM_DATA_STATUS	Allow NULL?
110	POS_MAN_PROC	Position Management Procedure	nvarchar	4	0	CHAR	(N' ')	Yes	*	TPM_POS_MAN_PROC	Allow NULL?

Name	Primary	Unique	Type	Columns
IDCFM_FRIM_DATA~0	Yes	Yes	CLUSTERED	RUN_KEY, GRANT_NBR, FUND, LOT_ID, OKUART, PRICE_TYPE, KEY_DATE, LOANS_CONTRACT, ACCOUNT_GROUP, PORTFOLIO, SECURITY_ID, SECURITY_ACCOUNT, COMPANY_CODE, VALUATION_CLASS, VALUATION_AREA, MANDT
IDCFM_FRIM_DATA~RU	No	No	NONCLUSTERED	RUN_ID, RUN_DATE, MANDT

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

110 COLUMNS | 2 INDEXES | ERP 6.0 | IDCFM_FRIM_DATA TABLE

TOP ERP 6.0 | IDCFM_FRIM_DATA COLUMNS

TOP ERP 6.0 | IDCFM_FRIM_DATA 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

110 COLUMNS | 2 INDEXES | ERP 6.0 | IDCFM_FRIM_DATA TABLE

TOPERP 6.0 | IDCFM_FRIM_DATA COLUMNS

TOPERP 6.0 | IDCFM_FRIM_DATA INDEXES

TOP ERP 6.0 | IDCFM_FRIM_DATA COLUMNS

TOP ERP 6.0 | IDCFM_FRIM_DATA INDEXES