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
Production Planning and Control :: Production Orders
1	ERP EHP7	6.0	COCF_SR	29	5	Shift Reports in PDF Format	Production Orders

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	FILENAME	Shift Report: File Name	nvarchar	70	Allow NULL?
3	SR_ORIGIN	Origin or Use of Shift Note or Report	nvarchar	2	Allow NULL?
4	PLANT	Plant	nvarchar	4	Allow NULL?
5	TYP	Object types of the CIM resource	nvarchar	2	Allow NULL?
6	ARBHI	Name of Work Center or Hierarchy	nvarchar	10	Allow NULL?
7	FUNCT_LOC	Functional Location	nvarchar	30	Allow NULL?
8	EQUIPMENT	Equipment Number	nvarchar	18	Allow NULL?
9	COUNTER	Running Number for Shift Reports with Same Key	nvarchar	2	Allow NULL?
10	START_DATE	Start of Evaluation Period	nvarchar	8	Allow NULL?
11	START_TIME	Start Time of Evaluation Period	nvarchar	6	Allow NULL?
12	END_DATE	End of Evaluation Period	nvarchar	8	Allow NULL?
13	END_TIME	End Time of Evaluation Period	nvarchar	6	Allow NULL?
14	STATUS	Status of Shift Report	nvarchar	10	Allow NULL?
15	TIME_ZONE	Time Zone	nvarchar	6	Allow NULL?
16	ERNAM	Name of Person who Created the Object	nvarchar	12	Allow NULL?
17	AENAM	Name of Person Who Changed Object	nvarchar	12	Allow NULL?
18	LANGU	Language Key	char	1	Allow NULL?
19	PRODSUP	Person Responsible for Shift	nvarchar	12	Allow NULL?
20	SIGNER	Signatory of Digital Signature	nvarchar	12	Allow NULL?
21	ERDAT	Date on Which Record Was Created	nvarchar	8	Allow NULL?
22	ERZET	Entry time	nvarchar	6	Allow NULL?
23	AEDAT	Changed On	nvarchar	8	Allow NULL?
24	AEZET	Time last change was made	nvarchar	6	Allow NULL?
25	SCHGRUP	Grouping for Shift Definitions and Shift Sequences	nvarchar	2	Allow NULL?
26	KAPTPROG	Shift definition	nvarchar	4	Allow NULL?
27	HASH_PDF	Hash Value (160 Bits)	varbinary	20
28	KPRO_CLASS	Document class	nvarchar	10	Allow NULL?
29	KPRO_OBJID	ID for documents and relations	nvarchar	32	Allow NULL?

Name	Primary	Unique	Type	Columns
COCF_SR~0	Yes	Yes	CLUSTERED	FILENAME, MANDT
COCF_SR~001	No	No	NONCLUSTERED	END_DATE, TYP, ARBHI, PLANT, MANDT
COCF_SR~002	No	No	NONCLUSTERED	STATUS, TYP, ARBHI, PLANT, MANDT
COCF_SR~003	No	No	NONCLUSTERED	KPRO_OBJID, KPRO_CLASS, MANDT
COCF_SR~004	No	No	NONCLUSTERED	END_DATE, EQUIPMENT, FUNCT_LOC, 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

29 COLUMNS | 5 INDEXES | ERP 6.0 | COCF_SR TABLE

TOP ERP 6.0 | COCF_SR COLUMNS

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

29 COLUMNS | 5 INDEXES | ERP 6.0 | COCF_SR TABLE

TOPERP 6.0 | COCF_SR COLUMNS

TOPERP 6.0 | COCF_SR INDEXES

TOP ERP 6.0 | COCF_SR COLUMNS

TOP ERP 6.0 | COCF_SR INDEXES