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
Controlling :: Product Cost Controlling :: Actual CostingMaterial Ledger
1	ERP EHP7	6.0	CKML1	118	2	Material Ledger Period Totals Records (Release 3.xx)	Actual CostingMaterial Ledger

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	KALNR	Cost Estimate Number for Cost Est. w/o Qty Structure	nvarchar	12	0	NUMC	(N'000000000000')	No	*	CK_KALNR	Allow NULL?
3	MATLED	Material ledger type	nvarchar	4	0	CHAR	(N' ')	No	TCKM1	CK_MATLED	Allow NULL?
4	BDATJ	Posting Date YYYY	nvarchar	4	0	NUMC	(N'0000')	No		BDATJ	Allow NULL?
5	POPER	Posting period	nvarchar	3	0	NUMC	(N'000')	No		POPER	Allow NULL?
6	UNTPER	Value Structure Type	nvarchar	3	0	NUMC	(N'000')	No		CK_UNTPER	Allow NULL?
7	STPRS_1	Standard price	decimal	11	2	CURR	((0))	No		CK_STPRS_1
8	STPRS_2	Standard price	decimal	11	2	CURR	((0))	No		CK_STPRS_2
9	STPRS_3	Standard price	decimal	11	2	CURR	((0))	No		CK_STPRS_3
10	PVPRS_1	Periodic unit price	decimal	11	2	CURR	((0))	No		CK_PVPRS_1
11	PVPRS_2	Periodic unit price	decimal	11	2	CURR	((0))	No		CK_PVPRS_2
12	PVPRS_3	Periodic unit price	decimal	11	2	CURR	((0))	No		CK_PVPRS_3
13	LBKUM	Total valuated stock	decimal	15	3	QUAN	((0))	No		CK_LBKUM
14	SALK3_1	Value of total valuated stock	decimal	15	2	CURR	((0))	No		CK_SALK3_1
15	SALK3_2	Value of total valuated stock	decimal	15	2	CURR	((0))	No		CK_SALK3_2
16	SALK3_3	Value of total valuated stock	decimal	15	2	CURR	((0))	No		CK_SALK3_3
17	SALKV_1	Value based on the periodic unit price (only with pr.ctrl S)	decimal	15	2	CURR	((0))	No		CK_SALKV_1
18	SALKV_2	Value based on the periodic unit price (only with pr.ctrl S)	decimal	15	2	CURR	((0))	No		CK_SALKV_2
19	SALKV_3	Value based on the periodic unit price (only with pr.ctrl S)	decimal	15	2	CURR	((0))	No		CK_SALKV_3
20	KZ_ABGER	Material price will no longer be determined in this period	char	1	0	CHAR	(N' ')	No		XABGER	Allow NULL?
21	WEKUMO	Total valuated qty of goods received in the period	decimal	15	3	QUAN	((0))	Yes		CK_WEKUM
22	WEWRT_1O	Total value of goods receipts for period	decimal	15	2	CURR	((0))	Yes		CK_WEWRT_1
23	WEWRT_2O	Total value of goods receipts for period	decimal	15	2	CURR	((0))	Yes		CK_WEWRT_2
24	WEWRT_3O	Total value of goods receipts for period	decimal	15	2	CURR	((0))	Yes		CK_WEWRT_3
25	REKUMO	Total valuted invoice receipt quantity for the period	decimal	15	3	QUAN	((0))	Yes		CK_REKUM
26	REWRT_1O	Total invoice receipt value of period	decimal	15	2	CURR	((0))	Yes		CK_REWRT_1
27	REWRT_2O	Total invoice receipt value of period	decimal	15	2	CURR	((0))	Yes		CK_REWRT_2
28	REWRT_3O	Total invoice receipt value of period	decimal	15	2	CURR	((0))	Yes		CK_REWRT_3
29	LVREKUMO	Subcontracting: total valuated invoice receipt quantity	decimal	15	3	QUAN	((0))	Yes		CK_LVREKUM
30	LVREW_1O	Subcontracting: total invoice receipt value	decimal	15	2	CURR	((0))	Yes		CK_LVREW_1
31	LVREW_2O	Subcontracting: total invoice receipt value	decimal	15	2	CURR	((0))	Yes		CK_LVREW_2
32	LVREW_3O	Subcontracting: total invoice receipt value	decimal	15	2	CURR	((0))	Yes		CK_LVREW_3
33	ZUKUMO	Total quantity of goods received in period	decimal	15	3	QUAN	((0))	Yes		CK_ZUKUM
34	ZUABW_1O	Receipts: Single-level price differences	decimal	15	2	CURR	((0))	Yes		CK_ZUABW_1
35	ZUABW_2O	Variance to ML price	decimal	15	2	CURR	((0))	Yes		CK_ZUABW_2
36	ZUABW_3O	Variance to ML price	decimal	15	2	CURR	((0))	Yes		CK_ZUABW_3
37	LVABW_1O	Subcontrac.: var. from planned value of mat. to be provided	decimal	15	2	CURR	((0))	Yes		CK_LVABW_1
38	LVABW_2O	Subcontrac.: var. from planned value of mat. to be provided	decimal	15	2	CURR	((0))	Yes		CK_LVABW_2
39	LVABW_3O	Subcontrac.: var. from planned value of mat. to be provided	decimal	15	2	CURR	((0))	Yes		CK_LVABW_3
40	LVWEKUMO	Subcontracting: total valuated quantity of goods received	decimal	15	3	QUAN	((0))	Yes		CK_LVWEKUM
41	LVWEW_1O	Subcontracting: value of goods received	decimal	15	2	CURR	((0))	Yes		CK_LVWEW_1
42	LVWEW_2O	Subcontracting: value of goods received	decimal	15	2	CURR	((0))	Yes		CK_LVWEW_2
43	LVWEW_3O	Subcontracting: value of goods received	decimal	15	2	CURR	((0))	Yes		CK_LVWEW_3
44	ZUOME_1O	Amount to be debited to material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUOME_1
45	ZUOME_2O	Amount to be debited to material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUOME_2
46	ZUOME_3O	Amount to be debited to material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUOME_3
47	ZUUMB_1O	Revaluation Amount	decimal	15	2	CURR	((0))	Yes		CK_ZUUMB_1
48	ZUUMB_2O	Revaluation amount for material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUUMB_2
49	ZUUMB_3O	Revaluation amount for material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUUMB_3
50	LVPVP_1	Subcontracting: periodic unit price (PUP)	decimal	11	2	CURR	((0))	No		CK_LVPVP_1
51	LVPVP_2	Subcontracting: periodic unit price (PUP)	decimal	11	2	CURR	((0))	No		CK_LVPVP_2
52	LVPVP_3	Subcontracting: periodic unit price (PUP)	decimal	11	2	CURR	((0))	No		CK_LVPVP_3
53	WEKUMA	Total valuated qty of goods received in the period	decimal	15	3	QUAN	((0))	Yes		CK_WEKUM
54	WEWRT_1A	Total value of goods receipts for period	decimal	15	2	CURR	((0))	Yes		CK_WEWRT_1
55	WEWRT_2A	Total value of goods receipts for period	decimal	15	2	CURR	((0))	Yes		CK_WEWRT_2
56	WEWRT_3A	Total value of goods receipts for period	decimal	15	2	CURR	((0))	Yes		CK_WEWRT_3
57	REKUMA	Total valuted invoice receipt quantity for the period	decimal	15	3	QUAN	((0))	Yes		CK_REKUM
58	REWRT_1A	Total invoice receipt value of period	decimal	15	2	CURR	((0))	Yes		CK_REWRT_1
59	REWRT_2A	Total invoice receipt value of period	decimal	15	2	CURR	((0))	Yes		CK_REWRT_2
60	REWRT_3A	Total invoice receipt value of period	decimal	15	2	CURR	((0))	Yes		CK_REWRT_3
61	LVREKUMA	Subcontracting: total valuated invoice receipt quantity	decimal	15	3	QUAN	((0))	Yes		CK_LVREKUM
62	LVREW_1A	Subcontracting: total invoice receipt value	decimal	15	2	CURR	((0))	Yes		CK_LVREW_1
63	LVREW_2A	Subcontracting: total invoice receipt value	decimal	15	2	CURR	((0))	Yes		CK_LVREW_2
64	LVREW_3A	Subcontracting: total invoice receipt value	decimal	15	2	CURR	((0))	Yes		CK_LVREW_3
65	ZUKUMA	Total quantity of goods received in period	decimal	15	3	QUAN	((0))	Yes		CK_ZUKUM
66	ZUABW_1A	Receipts: Single-level price differences	decimal	15	2	CURR	((0))	Yes		CK_ZUABW_1
67	ZUABW_2A	Variance to ML price	decimal	15	2	CURR	((0))	Yes		CK_ZUABW_2
68	ZUABW_3A	Variance to ML price	decimal	15	2	CURR	((0))	Yes		CK_ZUABW_3
69	LVABW_1A	Subcontrac.: var. from planned value of mat. to be provided	decimal	15	2	CURR	((0))	Yes		CK_LVABW_1
70	LVABW_2A	Subcontrac.: var. from planned value of mat. to be provided	decimal	15	2	CURR	((0))	Yes		CK_LVABW_2
71	LVABW_3A	Subcontrac.: var. from planned value of mat. to be provided	decimal	15	2	CURR	((0))	Yes		CK_LVABW_3
72	LVWEKUMA	Subcontracting: total valuated quantity of goods received	decimal	15	3	QUAN	((0))	Yes		CK_LVWEKUM
73	LVWEW_1A	Subcontracting: value of goods received	decimal	15	2	CURR	((0))	Yes		CK_LVWEW_1
74	LVWEW_2A	Subcontracting: value of goods received	decimal	15	2	CURR	((0))	Yes		CK_LVWEW_2
75	LVWEW_3A	Subcontracting: value of goods received	decimal	15	2	CURR	((0))	Yes		CK_LVWEW_3
76	ZUOME_1A	Amount to be debited to material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUOME_1
77	ZUOME_2A	Amount to be debited to material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUOME_2
78	ZUOME_3A	Amount to be debited to material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUOME_3
79	ZUUMB_1A	Revaluation Amount	decimal	15	2	CURR	((0))	Yes		CK_ZUUMB_1
80	ZUUMB_2A	Revaluation amount for material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUUMB_2
81	ZUUMB_3A	Revaluation amount for material ledger price	decimal	15	2	CURR	((0))	Yes		CK_ZUUMB_3
82	ZUOMP_1O	Theoretical subsequent debit/credit price per price unit	decimal	11	2	CURR	((0))	No		CK_ZUOMP_1
83	ZUOMP_2O	Theoretical subsequent debit/credit price per price unit	decimal	11	2	CURR	((0))	No		CK_ZUOMP_2
84	ZUOMP_3O	Theoretical subsequent debit/credit price per price unit	decimal	11	2	CURR	((0))	No		CK_ZUOMP_3
85	ZUOMP_1A	Theoretical subsequent debit/credit price per price unit	decimal	11	2	CURR	((0))	No		CK_ZUOMP_1
86	ZUOMP_2A	Theoretical subsequent debit/credit price per price unit	decimal	11	2	CURR	((0))	No		CK_ZUOMP_2
87	ZUOMP_3A	Theoretical subsequent debit/credit price per price unit	decimal	11	2	CURR	((0))	No		CK_ZUOMP_3
88	ZUOMMO	Cumulated quantity of subs. debit/credit in period	decimal	15	3	QUAN	((0))	No		CK_ZUOMM
89	ZUOMMA	Cumulated quantity of subs. debit/credit in period	decimal	15	3	QUAN	((0))	No		CK_ZUOMM
90	PEINH_1	Price unit	decimal	5	0	DEC	((0))	No		CK_PEINH_1
91	PEINH_2	Price unit for material ledger	decimal	5	0	DEC	((0))	No		CK_PEINH_2
92	PEINH_3	Price unit for material ledger	decimal	5	0	DEC	((0))	No		CK_PEINH_3
93	UMKUMO	Quantity posted to previous period	decimal	15	3	QUAN	((0))	No		CK_UMKUM
94	UMKUMA	Quantity posted to previous period	decimal	15	3	QUAN	((0))	No		CK_UMKUM
95	WEKUMVA	Total valuated GR quantity (carried forward)	decimal	15	3	QUAN	((0))	No		CK_WEKUMV
96	WEWRT_1VA	Total value of goods receipts (carried for.)	decimal	15	2	CURR	((0))	No		CK_WEWV_1
97	WEWRT_2VA	Total value of goods receipts (carried for.)	decimal	15	2	CURR	((0))	No		CK_WEWV_2
98	WEWRT_3VA	Total value of goods receipts (carried for.)	decimal	15	2	CURR	((0))	No		CK_WEWV_3
99	REKUMVA	Total valuted invoice receipt quantity (carried for.)	decimal	15	3	QUAN	((0))	No		CK_REKUMV
100	REWRT_1VA	Total invoice receipt value (carried for.)	decimal	15	2	CURR	((0))	No		CK_REWV_1
101	REWRT_2VA	Total invoice receipt value (carried for.)	decimal	15	2	CURR	((0))	No		CK_REWV_2
102	REWRT_3VA	Total invoice receipt value (carried for.)	decimal	15	2	CURR	((0))	No		CK_REWV_3
103	LVWEKUMVA	Subcontracting: total valuated GR quantity (carried for.)	decimal	15	3	QUAN	((0))	No		CK_LWEKV
104	LVWEW_1VA	Subcontracting: value of goods received (carried for.)	decimal	15	2	CURR	((0))	No		CK_LWEWV_1
105	LVWEW_2VA	Subcontracting: value of goods received (carried for.)	decimal	15	2	CURR	((0))	No		CK_LWEWV_2
106	LVWEW_3VA	Subcontracting: value of goods received (carried for.)	decimal	15	2	CURR	((0))	No		CK_LWEWV_3
107	LVREKUMVA	Subcontracting: Total Valuated IR Quantity (Carryforward)	decimal	15	3	QUAN	((0))	No		CK_LREKV
108	LVREW_1VA	Subcontracting: Total Invoice Receipt Value (Carryforward)	decimal	15	2	CURR	((0))	No		CK_LREWV_1
109	LVREW_2VA	Subcontracting: Total Invoice Receipt Value (Carryforward)	decimal	15	2	CURR	((0))	No		CK_LREWV_2
110	LVREW_3VA	Subcontracting: Total Invoice Receipt Value (Carryforward)	decimal	15	2	CURR	((0))	No		CK_LREWV_3
111	ZPLPR_1	Future planned price	decimal	11	2	CURR	((0))	Yes		DZPLPR
112	ZPLPR_2	Future planned price	decimal	11	2	CURR	((0))	Yes		DZPLPR
113	ZPLPR_3	Future planned price	decimal	11	2	CURR	((0))	Yes		DZPLPR
114	ZKPRS_1	Future price	decimal	11	2	CURR	((0))	Yes		DZKPRS
115	ZKPRS_2	Future price	decimal	11	2	CURR	((0))	Yes		DZKPRS
116	ZKPRS_3	Future price	decimal	11	2	CURR	((0))	Yes		DZKPRS
117	XKONCHK	Switch off consistency check	char	1	0	CHAR	(N' ')	Yes		CK_XKONCHK	Allow NULL?
118	XINIT	Indicator: affected by initialization	char	1	0	CHAR	(N' ')	Yes		CK_XINIT	Allow NULL?

Name	Primary	Unique	Type	Columns
CKML1~0	Yes	Yes	CLUSTERED	UNTPER, POPER, BDATJ, MATLED, KALNR, MANDT
CKML1~1	No	No	NONCLUSTERED	KZ_ABGER, KALNR, 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

118 COLUMNS | 2 INDEXES | ERP 6.0 | CKML1 TABLE

TOP ERP 6.0 | CKML1 COLUMNS

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

118 COLUMNS | 2 INDEXES | ERP 6.0 | CKML1 TABLE

TOPERP 6.0 | CKML1 COLUMNS

TOPERP 6.0 | CKML1 INDEXES

TOP ERP 6.0 | CKML1 COLUMNS

TOP ERP 6.0 | CKML1 INDEXES