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	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Service :: Solution Manager :: Service Data Download
1	ERP EHP7	6.0	/SOMO/JOSCHEDLT	74	2	Job Schedule Local Template	Service Data Download

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	SOLUTION		nvarchar	50	Allow NULL?
2	WEEKDAY		char	1	Allow NULL?
3	SID		nvarchar	3	Allow NULL?
4	JOBMONID		nvarchar	20	Allow NULL?
5	STEPCOUNT		int	10	Allow NULL?
6	JCOUNTER		int	10	Allow NULL?
7	CLIENT		nvarchar	3	Allow NULL?
8	EXECUSER		nvarchar	12	Allow NULL?
9	JOBNAME		nvarchar	32	Allow NULL?
10	PROGNAME		nvarchar	40	Allow NULL?
11	VARIANT		nvarchar	14	Allow NULL?
12	XPGPROG		nvarchar	128	Allow NULL?
13	XPGPARAMS		nvarchar	255	Allow NULL?
14	PREC_JOBNAME		nvarchar	32	Allow NULL?
15	EVENTID		nvarchar	32	Allow NULL?
16	EVENTPARM		nvarchar	64	Allow NULL?
17	SDLSTRTTM		nvarchar	6	Allow NULL?
18	SENDTIME		nvarchar	6	Allow NULL?
19	BPROCESSOBJNO		nvarchar	10	Allow NULL?
20	BPROCSTEPOBJNO		nvarchar	10	Allow NULL?
21	PARAPROC		char	1	Allow NULL?
22	NUMPARAJOB		int	10	Allow NULL?
23	JOBLOGANA		char	1	Allow NULL?
24	PTIMEWINS		nvarchar	6	Allow NULL?
25	PTIMEWINE		nvarchar	6	Allow NULL?
26	CRITICAL		char	1	Allow NULL?
27	ADELAYYEL		int	10	Allow NULL?
28	ADELAYRED		int	10	Allow NULL?
29	ADLENDYEL		int	10	Allow NULL?
30	ADLENDRED		int	10	Allow NULL?
31	AWINDWYEL		int	10	Allow NULL?
32	AWINDWRED		int	10	Allow NULL?
33	ADURATYEL		int	10	Allow NULL?
34	ADURATRED		int	10	Allow NULL?
35	ASTATUS		char	1	Allow NULL?
36	APARAPROC		char	1	Allow NULL?
37	ANOTSTARTED		char	1	Allow NULL?
38	CUSSTRTTM		nvarchar	6	Allow NULL?
39	EXTFLAG		char	1	Allow NULL?
40	NAM_RULE		nvarchar	3	Allow NULL?
41	CALENDARID		nvarchar	2	Allow NULL?
42	RELDAYMONTH		int	10	Allow NULL?
43	PRDMONTHS		int	10	Allow NULL?
44	STARTMONTH		int	10	Allow NULL?
45	CHKTIMNOTSTARTED		nvarchar	6	Allow NULL?
46	AJOBACTIVEYEL		int	10	Allow NULL?
47	AJOBACTIVERED		int	10	Allow NULL?
48	SIDLONG	Name of SAP System	nvarchar	8	Allow NULL?
49	PERIV		nvarchar	2	Allow NULL?
50	RELDAYMONTHEND		int	10	Allow NULL?
51	LAST_PLAN_START		nvarchar	6	Allow NULL?
52	PERIODICITY		int	10	Allow NULL?
53	JOBTYPE		nvarchar	2	Allow NULL?
54	RJOBMONID		nvarchar	20	Allow NULL?
55	CHAINSTATUS_YEL		nvarchar	2	Allow NULL?
56	CHAINSTATUS_RED		nvarchar	2	Allow NULL?
57	CHKTIMNOTSTARTRE		int	10	Allow NULL?
58	PLAN_END_REL		int	10	Allow NULL?
59	CHAIN_ID		nvarchar	25	Allow NULL?
60	TYPE		nvarchar	10	Allow NULL?
61	VARIANTE		nvarchar	30	Allow NULL?
62	LNR		nvarchar	10	Allow NULL?
63	RECPROC_MIN_YEL		int	10	Allow NULL?
64	RECPROC_MIN_RED		int	10	Allow NULL?
65	RECPROC_MAX_YEL		int	10	Allow NULL?
66	RECPROC_MAX_RED		int	10	Allow NULL?
67	MONWINDOW		smallint	5
68	INFOPCKG_MIN_YEL		int	10	Allow NULL?
69	INFOPCKG_MIN_RED		int	10	Allow NULL?
70	INFOPCKG_MAX_YEL		int	10	Allow NULL?
71	INFOPCKG_MAX_RED		int	10	Allow NULL?
72	ADURATMINYEL		int	10	Allow NULL?
73	ADURATMINRED		int	10	Allow NULL?
74	ALERTTYPELEVEL		nvarchar	20	Allow NULL?

Name	Primary	Unique	Type	Columns
/SOMO/JOSCHEDLT~0	Yes	Yes	CLUSTERED	JCOUNTER, STEPCOUNT, JOBMONID, SID, WEEKDAY, SOLUTION
/SOMO/JOSCHEDLT~1	No	No	NONCLUSTERED	BPROCESSOBJNO, SOLUTION, WEEKDAY

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

74 COLUMNS | 2 INDEXES | ERP 6.0 | /SOMO/JOSCHEDLT TABLE

TOP ERP 6.0 | /SOMO/JOSCHEDLT COLUMNS

TOP ERP 6.0 | /SOMO/JOSCHEDLT 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

74 COLUMNS | 2 INDEXES | ERP 6.0 | /SOMO/JOSCHEDLT TABLE

TOPERP 6.0 | /SOMO/JOSCHEDLT COLUMNS

TOPERP 6.0 | /SOMO/JOSCHEDLT INDEXES

TOP ERP 6.0 | /SOMO/JOSCHEDLT COLUMNS

TOP ERP 6.0 | /SOMO/JOSCHEDLT INDEXES