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
Logistics - General :: Variant Configuration
1	ERP EHP7	6.0	CUCO	117	6	Additional Data for Configurable Objects	Variant Configuration

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	T000	MANDT	Allow NULL?
2	OBTAB	Name of database table for object	nvarchar	30	CHAR	(N' ')	No	TCLO	TABELLE	Allow NULL?
3	OBJEK	Key of Configurable Object	nvarchar	50	CHAR	(N' ')	No		CUCOOBJ	Allow NULL?
4	ZAEHL	Internal counter	nvarchar	4	NUMC	(N'0000')	No		CUCOZHL	Allow NULL?
5	KLART	Class Type	nvarchar	3	CHAR	(N' ')	Yes	TCLA	KLASSENART	Allow NULL?
6	CLINT	Internal Class Number	nvarchar	10	NUMC	(N'0000000000')	Yes	KLAH	CLINT	Allow NULL?
7	SICHT	Organizational Area Indicator	char	1	CHAR	(N' ')	Yes	TCLS	SICHTKZ	Allow NULL?
8	CONAU	Automatic configuration	char	1	CHAR	(N' ')	Yes		CUCONAU	Allow NULL?
9	STLDY	No BOM explosion in configuration editor	char	1	CHAR	(N' ')	Yes		CUSTLDY	Allow NULL?
10	STLKD	Order BOM	char	1	CHAR	(N' ')	Yes		CUSTLKD	Allow NULL?
11	APLDY	Task list for planned/production order	char	1	CHAR	(N' ')	Yes		CUAPLDY	Allow NULL?
12	APLKD	Order task list	char	1	CHAR	(N' ')	Yes		CUAPLKD	Allow NULL?
13	STATUS	Status of configuration profile	char	1	CHAR	(N' ')	Yes	TCUOS	COBSTATUS	Allow NULL?
14	ERSDT	Created On	nvarchar	8	DATS	(N'00000000')	Yes		ERSDA	Allow NULL?
15	ERSNU	Name of Person who Created the Object	nvarchar	12	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
16	AEDAT	Changed On	nvarchar	8	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
17	AESBN	Name of Person Who Changed Object	nvarchar	12	CHAR	(N' ')	Yes		AENAM	Allow NULL?
18	DATUV	Valid-From Date	nvarchar	8	DATS	(N'00000000')	Yes		DATUV	Allow NULL?
19	DATUB	Valid-to date	nvarchar	8	DATS	(N'00000000')	Yes		DATUB	Allow NULL?
20	AENNR	Change Number	nvarchar	12	CHAR	(N' ')	Yes	AENR	AENNR	Allow NULL?
21	CLOGO	Display start logo	char	1	CHAR	(N' ')	Yes		CUCLOGO	Allow NULL?
22	KNOBJ	Number of Object with Assigned Dependencies	nvarchar	18	NUMC	(N'000000000000000000')	Yes		KNOBJ	Allow NULL?
23	STLBD	Display BOM Master Data	char	1	CHAR	(N' ')	Yes		CUSTLBD	Allow NULL?
24	STLOV	Configuration Structure of BOM	char	1	CHAR	(N' ')	Yes		CUSTLOV	Allow NULL?
25	STLRS	Configured BOM Result	char	1	CHAR	(N' ')	Yes		CUSTLRS	Allow NULL?
26	MONTF	Assembly Order	char	1	CHAR	(N' ')	Yes		CUMONTF	Allow NULL?
27	KDSET	Sales order (SET)	char	1	CHAR	(N' ')	Yes		CUKDSET	Allow NULL?
28	PRRES	Automatic Fixing	char	1	CHAR	(N' ')	Yes		CUPRRES	Allow NULL?
29	MATRS	Availability Check	char	1	CHAR	(N' ')	Yes		CUMATRS	Allow NULL?
30	CBAUG	Only configurable assemblies	char	1	CHAR	(N' ')	Yes		CUCBAUG	Allow NULL?
31	VVIEW	Organizational Area	nvarchar	10	CHAR	(N' ')	Yes		ABTEILUNG	Allow NULL?
32	KZLOE	Deletion indicator	char	1	CHAR	(N' ')	Yes		KZLOE	Allow NULL?
33	DVDAT	Date of last date shift	nvarchar	8	DATS	(N'00000000')	Yes		DVDAT	Allow NULL?
34	DVNAM	Name of the user who carried out the date shift	nvarchar	12	CHAR	(N' ')	Yes		DVNAM	Allow NULL?
35	APIDS	Application	nvarchar	4	CHAR	(N' ')	Yes	*	CAPID	Allow NULL?
36	APIDB	Application	nvarchar	4	CHAR	(N' ')	Yes	*	CAPID	Allow NULL?
37	PRFID	Configuration Profile Name	nvarchar	30	CHAR	(N' ')	Yes		CUPRFID	Allow NULL?
38	BESKZ	Procurement Type	char	1	CHAR	(N' ')	Yes		BESKZ	Allow NULL?
39	VALEV	Multilevel BOM Explosion	char	1	CHAR	(N' ')	Yes		CUVALEV	Allow NULL?
40	DESIGN	Design Name	nvarchar	18	CHAR	(N' ')	Yes		CE_DESIGN	Allow NULL?
41	NEUTR	Language-Independent Processing	char	1	CHAR	(N' ')	Yes		NEUTR	Allow NULL?
42	LCHAR	Language setting applies to characteristics	char	1	CHAR	(N' ')	Yes		LCHAR	Allow NULL?
43	LVALU	Language setting applies to values	char	1	CHAR	(N' ')	Yes		LVALU	Allow NULL?
44	A_LANGU	Alternative Language for Configurator	char	1	LANG	(N' ')	Yes	*	SPRAS_CO_ALTERN	Allow NULL?
45	MEMUS	Indicator: Required Characteristics	char	1	CHAR	(N' ')	Yes		MEMUS	Allow NULL?
46	MEOPT	Restriction for Optional Characteristics	char	1	CHAR	(N' ')	Yes		MEOPT	Allow NULL?
47	MEMIT	Display Only Characteristics with Assigned Values	char	1	CHAR	(N' ')	Yes		MEMIT	Allow NULL?
48	MEOHN	Display Only Characteristics Without Assigned Values	char	1	CHAR	(N' ')	Yes		MEOHN	Allow NULL?
49	MEMAS	Display Excluded Characteristics and Values	char	1	CHAR	(N' ')	Yes		MEMAS	Allow NULL?
50	DOBJD	Display According to Standard	char	1	CHAR	(N' ')	Yes		DOBJD	Allow NULL?
51	DMRKM	Display Without Values	char	1	CHAR	(N' ')	Yes		DMRKM	Allow NULL?
52	DMWRT	Display with Values and Without Page Editing	char	1	CHAR	(N' ')	Yes		DMWRT	Allow NULL?
53	DPAGE	Display with Values, One Characteristic Per Page	char	1	CHAR	(N' ')	Yes		DPAG1	Allow NULL?
54	DMABW	Display All Assigned Values	char	1	CHAR	(N' ')	Yes		DMABW	Allow NULL?
55	PRSAN	Pricing on request	char	1	CHAR	(N' ')	Yes		PRSAN	Allow NULL?
56	PRSPE	Pricing shown permanently	char	1	CHAR	(N' ')	Yes		PRSPE	Allow NULL?
57	CONFA	Configurator is permanently active	char	1	CHAR	(N' ')	Yes		CONFPERM	Allow NULL?
58	CONFI	Configurator is active on request	char	1	CHAR	(N' ')	Yes		CONFREQ	Allow NULL?
59	CONFS	Configurator is Active When You Choose Enter	char	1	CHAR	(N' ')	Yes		CONFDFRG	Allow NULL?
60	DVRST	Default Values Deleted	char	1	CHAR	(N' ')	Yes		DVRST	Allow NULL?
61	DVSET	Default values entered	char	1	CHAR	(N' ')	Yes		DVSET	Allow NULL?
62	DVMAR	Only selected entries	char	1	CHAR	(N' ')	Yes		DVMAR	Allow NULL?
63	DVUEB	Copy default values	char	1	CHAR	(N' ')	Yes		DVUEB	Allow NULL?
64	DVBST	Default values must be confirmed	char	1	CHAR	(N' ')	Yes		DVBST	Allow NULL?
65	MVANF	Check Configuration Material Against Stock on Request	char	1	CHAR	(N' ')	Yes		TYPAN	Allow NULL?
66	MVPER	Matching of inventoried material continuous	char	1	CHAR	(N' ')	Yes		TYPPE	Allow NULL?
67	NOMVF	Matching of inventoried material continuous	char	1	CHAR	(N' ')	Yes		NOMVF	Allow NULL?
68	MWVOR	Type matching of materials kept in stock: partial confign	char	1	CHAR	(N' ')	Yes		TYPST	Allow NULL?
69	MWVAT	Type Matching of Materials Kept in Stock	char	1	CHAR	(N' ')	Yes		TYPSK	Allow NULL?
70	MWVAV	Type matching of materials kept in stock: partial confign	char	1	CHAR	(N' ')	Yes		TYPST	Allow NULL?
71	KNOBJ_PRE	Number of Object with Assigned Dependencies	nvarchar	18	NUMC	(N'000000000000000000')	Yes		KNOBJ	Allow NULL?
72	FIX_ENTRY	Fix: Selected Assembly	char	1	CHAR	(N' ')	Yes		FIX_ENTRY	Allow NULL?
73	FIX_TOPDOWN	Fix: Top-Down	char	1	CHAR	(N' ')	Yes		FIX_TOPDOWN	Allow NULL?
74	FIX_BOTTOMUP	Fix: Bottom-Up	char	1	CHAR	(N' ')	Yes		FIX_BOTTOMUP	Allow NULL?
75	INST_ENTRY	Instantiation: Selected Assembly	char	1	CHAR	(N' ')	Yes		INST_ENTRY	Allow NULL?
76	INST_TOPDOWN	Instantiation: top-down	char	1	CHAR	(N' ')	Yes		INST_TOPDOWN	Allow NULL?
77	INST_BOTTOMUP	Instantiation: Bottom-Up	char	1	CHAR	(N' ')	Yes		INST_BOTTOMUP	Allow NULL?
78	EOASL	Result-Oriented Order BOM	char	1	CHAR	(N' ')	Yes		EOASL	Allow NULL?
79	SAASL	Maintenance in Order Allowed	char	1	CHAR	(N' ')	Yes		SAASL	Allow NULL?
80	SINGLE	Single-Level BOM Explosion	char	1	CHAR	(N' ')	Yes		CUVALEV1	Allow NULL?
81	MONTE	Manual changes to components allowed	char	1	CHAR	(N' ')	Yes		CUMONTE	Allow NULL?
82	CAREREL	SAP release maintenance	char	1	CHAR	(N' ')	Yes		CAREREL	Allow NULL?
83	IMBEZ	Single-Character Indicator	char	1	CHAR	(N' ')	Yes		CHAR1	Allow NULL?
84	UBEZW	Display with Object Dependencies	char	1	CHAR	(N' ')	Yes		UBEZW	Allow NULL?
85	UKNOT	Display Nodes Only	char	1	CHAR	(N' ')	Yes		UKNOT	Allow NULL?
86	UCMPF	Display All Components	char	1	CHAR	(N' ')	Yes		UCMPF	Allow NULL?
87	DMSTU	Multilevel Explosion	char	1	CHAR	(N' ')	Yes		DMSTU	Allow NULL?
88	DSTRU	Structure Explosion	char	1	CHAR	(N' ')	Yes		DSTRU	Allow NULL?
89	DPSEU	Read Special Procurement Key	char	1	CHAR	(N' ')	Yes		DPSEU	Allow NULL?
90	IMBEW	Characteristics (scope of decomp. hierarchy for configtor)	char	1	CHAR	(N' ')	Yes		MERK_BOM	Allow NULL?
91	OBJ_MAT	Object Type "Material"	char	1	CHAR	(N' ')	Yes		CE_OBJ_MAT	Allow NULL?
92	OBJ_DOCUMENT	Object Type "Document"	char	1	CHAR	(N' ')	Yes		CE_OBJ_DOC	Allow NULL?
93	OBJ_CLASS	Object Type "Class"	char	1	CHAR	(N' ')	Yes		CE_OBJ_CLS	Allow NULL?
94	OBJ_TEXT	Object Type "Text"	char	1	CHAR	(N' ')	Yes		CE_OBJ_TXT	Allow NULL?
95	FL_SDREL	Relevant to SD	char	1	CHAR	(N' ')	Yes		CE_SDREL	Allow NULL?
96	FL_KOREL	Relevant to Engineering	char	1	CHAR	(N' ')	Yes		CE_KOREL	Allow NULL?
97	FL_FEREL	Production Relevant	char	1	CHAR	(N' ')	Yes		CE_FEREL	Allow NULL?
98	FL_INREL	Relevant to Plant Maintenance	char	1	CHAR	(N' ')	Yes		CE_INREL	Allow NULL?
99	FL_KAREL	Relevant to Costing	char	1	CHAR	(N' ')	Yes		CE_KAREL	Allow NULL?
100	POSTYPEN	Item categories (BOM)	nvarchar	20	CHAR	(N' ')	Yes		POSTYPEN	Allow NULL?
101	SORTF1	Sort String	nvarchar	10	CHAR	(N' ')	Yes		SORTP	Allow NULL?
102	SORTF2	Sort String	nvarchar	10	CHAR	(N' ')	Yes		SORTP	Allow NULL?
103	SORTF3	Sort String	nvarchar	10	CHAR	(N' ')	Yes		SORTP	Allow NULL?
104	SORTF4	Sort String	nvarchar	10	CHAR	(N' ')	Yes		SORTP	Allow NULL?
105	SORTF5	Sort String	nvarchar	10	CHAR	(N' ')	Yes		SORTP	Allow NULL?
106	CLASSF1	Class filter	nvarchar	3	CHAR	(N' ')	Yes		CE_CLASSF	Allow NULL?
107	CLASSF2	Class filter	nvarchar	3	CHAR	(N' ')	Yes		CE_CLASSF	Allow NULL?
108	CLASSF3	Class filter	nvarchar	3	CHAR	(N' ')	Yes		CE_CLASSF	Allow NULL?
109	CLASSF4	Class filter	nvarchar	3	CHAR	(N' ')	Yes		CE_CLASSF	Allow NULL?
110	CLASSF5	Class filter	nvarchar	3	CHAR	(N' ')	Yes		CE_CLASSF	Allow NULL?
111	TYPST	Type matching of materials kept in stock: partial confign	char	1	CHAR	(N' ')	Yes		TYPST	Allow NULL?
112	TYPSK	Type Matching of Materials Kept in Stock	char	1	CHAR	(N' ')	Yes		TYPSK	Allow NULL?
113	PRIO	Configuration profile priority	nvarchar	2	NUMC	(N'00')	Yes		CUCOPRIO	Allow NULL?
114	PRSTL	WBS BOM	char	1	CHAR	(N' ')	Yes		CUPRSTL	Allow NULL?
115	UMBEW	Characteristics without values	char	1	CHAR	(N' ')	Yes		TYPUM	Allow NULL?
116	KZ_BROWSER	Configuration browser	char	1	CHAR	(N' ')	Yes		KZ_BROWSER	Allow NULL?
117	FL_PROF_OBOM	Order BOM Profile	char	1	CHAR	(N' ')	Yes		FL_PROF_OBOM	Allow NULL?

Name	Primary	Unique	Type	Columns
CUCO~0	Yes	Yes	CLUSTERED	ZAEHL, OBJEK, OBTAB, MANDT
CUCO~A	No	No	NONCLUSTERED	AENNR
CUCO~C	No	No	NONCLUSTERED	CLINT
CUCO~D	No	No	NONCLUSTERED	DESIGN
CUCO~K	No	No	NONCLUSTERED	KNOBJ
CUCO~V	No	No	NONCLUSTERED	KNOBJ_PRE

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

117 COLUMNS | 6 INDEXES | ERP 6.0 | CUCO TABLE

TOP ERP 6.0 | CUCO COLUMNS

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

117 COLUMNS | 6 INDEXES | ERP 6.0 | CUCO TABLE

TOPERP 6.0 | CUCO COLUMNS

TOPERP 6.0 | CUCO INDEXES

TOP ERP 6.0 | CUCO COLUMNS

TOP ERP 6.0 | CUCO INDEXES