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
Basis Components :: Use Subcomponents :: Print and Output Management
1	ERP EHP7	6.0	TSPJSTAT	37	2	Statistical data for output requests	Print and Output Management

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	PJIDENT	Spool request number	int	10	Allow NULL?
2	PJNUMBER	Spool: output request number	smallint	5
3	PJCREATIME	Time a spool request was created	nvarchar	16	Allow NULL?
4	STARTTIME	System log time stamp	nvarchar	16	Allow NULL?
5	PJDEST	Spool: Output device	nvarchar	4	Allow NULL?
6	PJPAPER	Spool: Format	nvarchar	16	Allow NULL?
7	PRTYPE	Spool: Device type name	nvarchar	8	Allow NULL?
8	DESTHOST	Physical host name	nvarchar	64	Allow NULL?
9	PRNAME	Spool: Long name of printers for host spooler	nvarchar	50	Allow NULL?
10	PJTITLE	Title of a spool request	nvarchar	68	Allow NULL?
11	PJSUFFIX0	Spool request: Name	nvarchar	6	Allow NULL?
12	PJSUFFIX1	Spool request: Suffix 1	nvarchar	4	Allow NULL?
13	PJSUFFIX2	Spool request: Suffix 2	nvarchar	12	Allow NULL?
14	PJCOPIES	Number of copies	tinyint	3
15	PJPRIO	Spool: Spool or print request priority	tinyint	3
16	PJPAGES	Number of pages in a spool request	int	10	Allow NULL?
17	PJBYTES	Print request size	int	10	Allow NULL?
18	PJCLIENT	Client for which object was generated	nvarchar	3	Allow NULL?
19	PJRETRIES	Spool: Small counter	tinyint	3
20	PJOWNER	User name	nvarchar	12	Allow NULL?
21	PJRECEIVER	Spool: Recipient of spool request	nvarchar	12	Allow NULL?
22	PJDIVISION	Department	nvarchar	12	Allow NULL?
23	PJTELENUM	Telecommunications partner	nvarchar	30	Allow NULL?
24	PJSERVER	Server Name	nvarchar	20	Allow NULL?
25	FILLER	Character field of length 6	nvarchar	6	Allow NULL?
26	T1	Trace time stamp	varbinary	8
27	T2	Trace time stamp	varbinary	8
28	T3	Trace time stamp	varbinary	8
29	T4	Trace time stamp	varbinary	8
30	T5	Trace time stamp	varbinary	8
31	T6	Trace time stamp	varbinary	8
32	T7	Trace time stamp	varbinary	8
33	ENDTIME	System log time stamp	nvarchar	16	Allow NULL?
34	STATUS	Spool: Output request status	char	1	Allow NULL?
35	OLDENTRY	Flag if entry was processed	char	1	Allow NULL?
36	PJSAPTITLE	Print SAP cover page	char	1	Allow NULL?
37	PJUNXTITLE	Print operating system cover page	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
TSPJSTAT~0	Yes	Yes	CLUSTERED	PJIDENT, PJNUMBER, PJCREATIME
TSPJSTAT~001	No	No	NONCLUSTERED	OLDENTRY

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

37 COLUMNS | 2 INDEXES | ERP 6.0 | TSPJSTAT TABLE

TOP ERP 6.0 | TSPJSTAT COLUMNS

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

37 COLUMNS | 2 INDEXES | ERP 6.0 | TSPJSTAT TABLE

TOPERP 6.0 | TSPJSTAT COLUMNS

TOPERP 6.0 | TSPJSTAT INDEXES

TOP ERP 6.0 | TSPJSTAT COLUMNS

TOP ERP 6.0 | TSPJSTAT INDEXES