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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	PRTREQ_ID	Print Request	nvarchar	12	Allow NULL?
3	PRTREQ_ID_REF	Print Request Body	nvarchar	12	Allow NULL?
4	TYPE	Print Request Type	nvarchar	12	Allow NULL?
5	STATE	Print Request Status	nvarchar	12	Allow NULL?
6	GENWARNING	Warnings During Label Generation	char	1	Allow NULL?
7	CRDAT	Created On	nvarchar	8	Allow NULL?
8	CRNAM	Created By	nvarchar	12	Allow NULL?
9	CRTIM	Creation Time of Print Request	nvarchar	6	Allow NULL?
10	UPDDAT	Changed On	nvarchar	8	Allow NULL?
11	UPDNAM	Last Changed By	nvarchar	12	Allow NULL?
12	UPDTIM	Print Request Change Date/Time	nvarchar	6	Allow NULL?
13	SCENID	Labeling Scenario	nvarchar	30	Allow NULL?
14	SBGVID	Report Generation Variant	nvarchar	10	Allow NULL?
15	LABELTYPE	Label Category	nvarchar	10	Allow NULL?
16	STNID	Print Station	nvarchar	12	Allow NULL?
17	PRNID	Printer on Print Station	nvarchar	12	Allow NULL?
18	SUBID	Specification	nvarchar	12	Allow NULL?
19	REPLANGU	Language Key	char	1	Allow NULL?
20	ECOUNT	Number of Printed Copies	decimal	6
21	FLGPRIMM	Print Immediately	char	1	Allow NULL?
22	LSID	Label Stock	nvarchar	12	Allow NULL?
23	DELDELAY	Validity in Days	int	10	Allow NULL?
24	PRELABEL	Number of Preliminary Leg Labels	nvarchar	4	Allow NULL?
25	POSTLABEL	Number of Subsequent Leg Labels	nvarchar	4	Allow NULL?
26	MATNR	Material Number	nvarchar	18	Allow NULL?
27	SCNGRP	Labeling Scenario Group	nvarchar	30	Allow NULL?
28	SYSTEMNAME	Name of SAP System	nvarchar	8	Allow NULL?
29	CLNT	Client	nvarchar	3	Allow NULL?
30	EXTNUMBER	Application Log: External ID	nvarchar	100	Allow NULL?
31	TRIGORDID	Object Key for Print Request	nvarchar	128	Allow NULL?
32	PLANT	Plant or Shipping Point	nvarchar	4	Allow NULL?
33	WORKPLACE	Work Center	nvarchar	8	Allow NULL?
34	WORKLIST	Worklist for Print Request	char	1	Allow NULL?
35	ORDER1	Print Request Description 01	nvarchar	128	Allow NULL?
36	ORDER2	Print Request Description 02	nvarchar	128	Allow NULL?
37	ORDER3	Print Request Description 03	nvarchar	128	Allow NULL?
38	ORDER4	Print Request Description 04	nvarchar	128	Allow NULL?
39	ORDER5	Print Request Description 05	nvarchar	128	Allow NULL?
40	ORDER6	Print Request Description 06	nvarchar	128	Allow NULL?
41	ORDER7	Print Request Description 07	nvarchar	128	Allow NULL?
42	ORDER8	Print Request Description 08	nvarchar	128	Allow NULL?
43	ORDER9	Print Request Description 09	nvarchar	128	Allow NULL?
44	ORDER10	Print Request Description 10	nvarchar	128	Allow NULL?
45	DOKAR	Document Type	nvarchar	3	Allow NULL?
46	DOKNR	Document number	nvarchar	25	Allow NULL?
47	DOKVR	Document Version	nvarchar	2	Allow NULL?
48	DOKTL	Document Part	nvarchar	3	Allow NULL?

Name	Primary	Unique	Type	Columns
CCGLT_PRTREQ_HDR01	No	No	NONCLUSTERED	STATE, TYPE
CCGLT_PRTREQ_HDR02	No	No	NONCLUSTERED	STNID
CCGLT_PRTREQ_HDR03	No	No	NONCLUSTERED	CRDAT
CCGLT_PRTREQ_HDR04	No	No	NONCLUSTERED	MATNR
CCGLT_PRTREQ_HDR05	No	No	NONCLUSTERED	TRIGORDID
CCGLT_PRTREQ_HDR06	No	No	NONCLUSTERED	ORDER1
CCGLT_PRTREQ_HDR07	No	No	NONCLUSTERED	ORDER2
CCGLT_PRTREQ_HDR08	No	No	NONCLUSTERED	ORDER3
CCGLT_PRTREQ_HDR09	No	No	NONCLUSTERED	ORDER4
CCGLT_PRTREQ_HDR10	No	No	NONCLUSTERED	ORDER5
CCGLT_PRTREQ_HDR~0	Yes	Yes	CLUSTERED	PRTREQ_ID, 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

48 COLUMNS | 11 INDEXES | ERP 6.0 | CCGLT_PRTREQ_HDR TABLE

TOP ERP 6.0 | CCGLT_PRTREQ_HDR COLUMNS

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

48 COLUMNS | 11 INDEXES | ERP 6.0 | CCGLT_PRTREQ_HDR TABLE

TOPERP 6.0 | CCGLT_PRTREQ_HDR COLUMNS

TOPERP 6.0 | CCGLT_PRTREQ_HDR INDEXES

TOP ERP 6.0 | CCGLT_PRTREQ_HDR COLUMNS

TOP ERP 6.0 | CCGLT_PRTREQ_HDR INDEXES