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
1	ERP EHP7	6.0	CSKS	73	2	Cost Center Master Data	Controlling

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	KOKRS	Controlling Area	nvarchar	4	CHAR	(N' ')	No	TKA01	KOKRS	Allow NULL?
3	KOSTL	Cost Center	nvarchar	10	CHAR	(N' ')	No		KOSTL	Allow NULL?
4	DATBI	Valid To Date	nvarchar	8	DATS	(N'00000000')	No		DATBI	Allow NULL?
5	DATAB	Valid-From Date	nvarchar	8	DATS	(N'00000000')	Yes		DATAB	Allow NULL?
6	BKZKP	Lock Indicator for Actual Primary Postings	char	1	CHAR	(N' ')	Yes		BKZKP	Allow NULL?
7	PKZKP	Lock Indicator for Plan Primary Costs	char	1	CHAR	(N' ')	Yes		PKZKP	Allow NULL?
8	BUKRS	Company Code	nvarchar	4	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
9	GSBER	Business Area	nvarchar	4	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
10	KOSAR	Cost Center Category	char	1	CHAR	(N' ')	Yes	TKA05	KOSAR	Allow NULL?
11	VERAK	Person Responsible	nvarchar	20	CHAR	(N' ')	Yes		VERAK	Allow NULL?
12	VERAK_USER	User Responsible	nvarchar	12	CHAR	(N' ')	Yes	USR02	VERAK_USER	Allow NULL?
13	WAERS	Currency Key	nvarchar	5	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
14	KALSM	Costing Sheet	nvarchar	6	CHAR	(N' ')	Yes	T683	AUFKALSM	Allow NULL?
15	TXJCD	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	Yes	TTXJ	TXJCD	Allow NULL?
16	PRCTR	Profit Center	nvarchar	10	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
17	WERKS	Plant	nvarchar	4	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
18	LOGSYSTEM	Logical System	nvarchar	10	CHAR	(N' ')	Yes	TBDLS	LOGSYSTEM	Allow NULL?
19	ERSDA	Created on	nvarchar	8	DATS	(N'00000000')	Yes		ERFDT	Allow NULL?
20	USNAM	Entered by	nvarchar	12	CHAR	(N' ')	Yes		ERFNM	Allow NULL?
21	BKZKS	Lock Indicator for Actual Secondary Costs	char	1	CHAR	(N' ')	Yes		BKZKS	Allow NULL?
22	BKZER	Lock Indicator for Actual Revenue Postings	char	1	CHAR	(N' ')	Yes		BKZER	Allow NULL?
23	BKZOB	Lock Indicator for Commitment Update	char	1	CHAR	(N' ')	Yes		BKZOB	Allow NULL?
24	PKZKS	Lock Indicator for Plan Secondary Costs	char	1	CHAR	(N' ')	Yes		PKZKS	Allow NULL?
25	PKZER	Lock Indicator for Planning Revenues	char	1	CHAR	(N' ')	Yes		PKZER	Allow NULL?
26	VMETH	Indicator for Allowed Allocation Methods	nvarchar	2	CHAR	(N' ')	Yes		VMETH	Allow NULL?
27	MGEFL	Indicator for Recording Consumption Quantities	char	1	CHAR	(N' ')	Yes		MGEFL	Allow NULL?
28	ABTEI	Department	nvarchar	12	CHAR	(N' ')	Yes		ABTEI	Allow NULL?
29	NKOST	Subsequent cost center	nvarchar	10	CHAR	(N' ')	Yes	*	NKOST	Allow NULL?
30	KVEWE	Usage of the condition table	char	1	CHAR	(N' ')	Yes	T681V	KVEWE	Allow NULL?
31	KAPPL	Application	nvarchar	2	CHAR	(N' ')	Yes	T681A	KAPPL	Allow NULL?
32	KOSZSCHL	CO-CCA Overhead Key	nvarchar	6	CHAR	(N' ')	Yes		KOSZSCHL	Allow NULL?
33	LAND1	Country Key	nvarchar	3	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
34	ANRED	Title	nvarchar	15	CHAR	(N' ')	Yes		ANRED	Allow NULL?
35	NAME1	Name 1	nvarchar	35	CHAR	(N' ')	Yes		NAME1_GP	Allow NULL?
36	NAME2	Name 2	nvarchar	35	CHAR	(N' ')	Yes		NAME2_GP	Allow NULL?
37	NAME3	Name 3	nvarchar	35	CHAR	(N' ')	Yes		NAME3_GP	Allow NULL?
38	NAME4	Name 4	nvarchar	35	CHAR	(N' ')	Yes		NAME4_GP	Allow NULL?
39	ORT01	City	nvarchar	35	CHAR	(N' ')	Yes		ORT01_GP	Allow NULL?
40	ORT02	District	nvarchar	35	CHAR	(N' ')	Yes		ORT02_GP	Allow NULL?
41	STRAS	House number and street	nvarchar	35	CHAR	(N' ')	Yes		STRAS_GP	Allow NULL?
42	PFACH	PO Box	nvarchar	10	CHAR	(N' ')	Yes		PFACH	Allow NULL?
43	PSTLZ	Postal Code	nvarchar	10	CHAR	(N' ')	Yes		PSTLZ	Allow NULL?
44	PSTL2	P.O. Box Postal Code	nvarchar	10	CHAR	(N' ')	Yes		PSTL2	Allow NULL?
45	REGIO	Region (State, Province, County)	nvarchar	3	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
46	SPRAS	Language Key	char	1	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
47	TELBX	Telebox number	nvarchar	15	CHAR	(N' ')	Yes		TELBX	Allow NULL?
48	TELF1	First telephone number	nvarchar	16	CHAR	(N' ')	Yes		TELF1	Allow NULL?
49	TELF2	Second telephone number	nvarchar	16	CHAR	(N' ')	Yes		TELF2	Allow NULL?
50	TELFX	Fax Number	nvarchar	31	CHAR	(N' ')	Yes		TELFX	Allow NULL?
51	TELTX	Teletex number	nvarchar	30	CHAR	(N' ')	Yes		TELTX	Allow NULL?
52	TELX1	Telex number	nvarchar	30	CHAR	(N' ')	Yes		TELX1	Allow NULL?
53	DATLT	Data communication line no.	nvarchar	14	CHAR	(N' ')	Yes		DATLT	Allow NULL?
54	DRNAM	Printer destination for CCtr report	nvarchar	4	CHAR	(N' ')	Yes		KDNAM	Allow NULL?
55	KHINR	Standard Hierarchy Area	nvarchar	12	CHAR	(N' ')	Yes		KHINR	Allow NULL?
56	CCKEY	Cost collector key	nvarchar	23	CHAR	(N' ')	Yes		CCKEY	Allow NULL?
57	KOMPL	Completion flag for the cost center master record	char	1	CHAR	(N' ')	Yes		KSKOM	Allow NULL?
58	STAKZ	Indicator. object is statistical	char	1	CHAR	(N' ')	Yes		STAKZ	Allow NULL?
59	OBJNR	Object number	nvarchar	22	CHAR	(N' ')	Yes	ONR00	J_OBJNR	Allow NULL?
60	FUNKT	Function of cost center	nvarchar	3	CHAR	(N' ')	Yes		FUNKT_DLK	Allow NULL?
61	AFUNK	Alternative function of cost center	nvarchar	3	CHAR	(N' ')	Yes		AFUNK_DLK	Allow NULL?
62	CPI_TEMPL	Template for Activity-Independent Formula Planning	nvarchar	10	CHAR	(N' ')	Yes	COTPL	CCA_TEMPL_CPI	Allow NULL?
63	CPD_TEMPL	Template for Activity-Dependent Formula Planning	nvarchar	10	CHAR	(N' ')	Yes	COTPL	CCA_TEMPL_CPD	Allow NULL?
64	FUNC_AREA	Functional Area	nvarchar	16	CHAR	(N' ')	Yes	TFKB	FKBER	Allow NULL?
65	SCI_TEMPL	Template: Activity-Independent Allocation to Cost Center	nvarchar	10	CHAR	(N' ')	Yes	COTPL	CCA_TEMPL_SCI	Allow NULL?
66	SCD_TEMPL	Template: Activity-Dependent Allocation to Cost Center	nvarchar	10	CHAR	(N' ')	Yes	COTPL	CCA_TEMPL_SCD	Allow NULL?
67	VNAME	Joint Venture	nvarchar	6	CHAR	(N' ')	Yes	T8JV	JV_NAME	Allow NULL?
68	RECID	Recovery Indicator	nvarchar	2	CHAR	(N' ')	Yes	T8JJ	JV_RECIND	Allow NULL?
69	ETYPE	Equity type	nvarchar	3	CHAR	(N' ')	Yes	T8JG	JV_ETYPE	Allow NULL?
70	JV_OTYPE	Joint Venture Object Type	nvarchar	4	CHAR	(N' ')	Yes		JV_OTYPE	Allow NULL?
71	JV_JIBCL	JIB/JIBE Class	nvarchar	3	CHAR	(N' ')	Yes	T8J6A	JV_JIBCL	Allow NULL?
72	JV_JIBSA	JIB/JIBE Subclass A	nvarchar	5	CHAR	(N' ')	Yes	T8J6C	JV_JIBSA	Allow NULL?
73	FERC_IND	Regulatory indicator	nvarchar	4	CHAR	(N' ')	Yes	FERC_C7	FE_IND	Allow NULL?

Name	Primary	Unique	Type	Columns
CSKS~0	Yes	Yes	CLUSTERED	DATBI, KOSTL, KOKRS, MANDT
CSKS~J	No	No	NONCLUSTERED	VNAME, BUKRS, 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

73 COLUMNS | 2 INDEXES | ERP 6.0 | CSKS TABLE

TOP ERP 6.0 | CSKS COLUMNS

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

73 COLUMNS | 2 INDEXES | ERP 6.0 | CSKS TABLE

TOPERP 6.0 | CSKS COLUMNS

TOPERP 6.0 | CSKS INDEXES

TOP ERP 6.0 | CSKS COLUMNS

TOP ERP 6.0 | CSKS INDEXES