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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
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	OINM	101	Whse Journal

	Product	Version	Table	Columns	Indexes	Description	Module
Controlling :: Product Cost Controlling :: Actual CostingMaterial Ledger :: Alternative Valuation Run
1	ERP EHP7	6.0	MLAVRSCALEKEPH	106	1	Cost Component Split of Re-scaling Amounts AVR	Alternative Valuation Run

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	*	MANDT	Allow NULL?
2	RUN_ID	Number of Costing Runs for Material Ledger	nvarchar	12	0	NUMC	(N'000000000000')	No	*	CKML_RUN_ID	Allow NULL?
3	KALNR_OUT	Cost Estimate Number - Product Costing	nvarchar	12	0	NUMC	(N'000000000000')	No	*	CK_KALNR1	Allow NULL?
4	KALNR_IN	Cost Estimate Number - Product Costing	nvarchar	12	0	NUMC	(N'000000000000')	No	*	CK_KALNR1	Allow NULL?
5	KALNR_BA	Cost Estimate Number for Procurement Alt./Consumption Alt.	nvarchar	12	0	NUMC	(N'000000000000')	No	*	CK_KALNR_BVALT	Allow NULL?
6	KALNR_VA	Cost Estimate Number for Procurement Alt./Consumption Alt.	nvarchar	12	0	NUMC	(N'000000000000')	No	*	CK_KALNR_BVALT	Allow NULL?
7	CURTP_OUT	Currency Type and Valuation View	nvarchar	2	0	CHAR	(N' ')	No		CURTP	Allow NULL?
8	CURTP_IN	Currency Type and Valuation View	nvarchar	2	0	CHAR	(N' ')	No		CURTP	Allow NULL?
9	GJAHR_OUT	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		CKML_RUN_GJAHR	Allow NULL?
10	POPER_OUT	Posting period	nvarchar	3	0	NUMC	(N'000')	No		CKML_RUN_POPER	Allow NULL?
11	CATEG	Category in Material Ledger Data Display	nvarchar	2	0	CHAR	(N' ')	No		CKML_CATEG	Allow NULL?
12	PTYP	Process category for procurement alt. or consuption alt.	nvarchar	4	0	CHAR	(N' ')	No	*	CK_PTYP_BVALT	Allow NULL?
13	KEART	Type of Cost Component Split for Product Costing	char	1	0	CHAR	(N' ')	No		KEART	Allow NULL?
14	KKZST	Indicator Lower Level/Level	char	1	0	CHAR	(N' ')	No		CK_STUFE	Allow NULL?
15	XCUMREC		char	1	0		(N' ')	Yes			Allow NULL?
16	BTYP_OUT	Process Category	nvarchar	4	0	CHAR	(N' ')	Yes	*	CKML_BTYP	Allow NULL?
17	GJAHR_IN	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		CKML_RUN_GJAHR	Allow NULL?
18	POPER_IN	Posting period	nvarchar	3	0	NUMC	(N'000')	Yes		CKML_RUN_POPER	Allow NULL?
19	SCALETYP		char	1	0		(N' ')	Yes			Allow NULL?
20	OTYP_IN	Object Type	nvarchar	2	0	CHAR	(N' ')	Yes		CKML_OTYP	Allow NULL?
21	XCUM		char	1	0		(N' ')	Yes			Allow NULL?
22	XCLS		char	1	0		(N' ')	Yes			Allow NULL?
23	ELEHK_OUT	Cost Component Structure - CGM and Sales/Administr. Costs	nvarchar	2	0	CHAR	(N' ')	Yes	*	CK_ELESMHK	Allow NULL?
24	ELEHK_IN	Cost Component Structure - CGM and Sales/Administr. Costs	nvarchar	2	0	CHAR	(N' ')	Yes	*	CK_ELESMHK	Allow NULL?
25	WAERS_OUT	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
26	WAERS_IN	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
27	KST001OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
28	KST002OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
29	KST003OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
30	KST004OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
31	KST005OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
32	KST006OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
33	KST007OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
34	KST008OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
35	KST009OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
36	KST010OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
37	KST011OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
38	KST012OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
39	KST013OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
40	KST014OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
41	KST015OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
42	KST016OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
43	KST017OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
44	KST018OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
45	KST019OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
46	KST020OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
47	KST021OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
48	KST022OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
49	KST023OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
50	KST024OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
51	KST025OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
52	KST026OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
53	KST027OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
54	KST028OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
55	KST029OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
56	KST030OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
57	KST031OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
58	KST032OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
59	KST033OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
60	KST034OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
61	KST035OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
62	KST036OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
63	KST037OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
64	KST038OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
65	KST039OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
66	KST040OUT	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
67	KST001IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
68	KST002IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
69	KST003IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
70	KST004IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
71	KST005IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
72	KST006IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
73	KST007IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
74	KST008IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
75	KST009IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
76	KST010IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
77	KST011IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
78	KST012IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
79	KST013IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
80	KST014IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
81	KST015IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
82	KST016IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
83	KST017IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
84	KST018IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
85	KST019IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
86	KST020IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
87	KST021IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
88	KST022IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
89	KST023IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
90	KST024IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
91	KST025IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
92	KST026IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
93	KST027IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
94	KST028IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
95	KST029IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
96	KST030IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
97	KST031IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
98	KST032IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
99	KST033IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
100	KST034IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
101	KST035IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
102	KST036IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
103	KST037IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
104	KST038IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
105	KST039IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL
106	KST040IN	Cost Field	decimal	15	2	CURR	((0))	Yes		MLCCS_D_KSTEL

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

106 COLUMNS | 1 INDEXES | ERP 6.0 | MLAVRSCALEKEPH TABLE

TOP ERP 6.0 | MLAVRSCALEKEPH COLUMNS

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

106 COLUMNS | 1 INDEXES | ERP 6.0 | MLAVRSCALEKEPH TABLE

TOPERP 6.0 | MLAVRSCALEKEPH COLUMNS

TOPERP 6.0 | MLAVRSCALEKEPH INDEXES

TOP ERP 6.0 | MLAVRSCALEKEPH COLUMNS

TOP ERP 6.0 | MLAVRSCALEKEPH INDEXES