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	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

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