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 :: Background Processing
1	ERP EHP7	6.0	TBTCO	58	7	Job Status Overview Table	Background Processing

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	JOBNAME	Background job name	nvarchar	32	Allow NULL?
2	JOBCOUNT	Job ID	nvarchar	8	Allow NULL?
3	JOBGROUP	Summary of jobs for a group	nvarchar	12	Allow NULL?
4	INTREPORT	Name of internal report for batch job	nvarchar	40	Allow NULL?
5	STEPCOUNT	Job step ID number.	int	10	Allow NULL?
6	SDLSTRTDT	Planned Start Date for Background Job	nvarchar	8	Allow NULL?
7	SDLSTRTTM	Planned start time for background Job	nvarchar	6	Allow NULL?
8	BTCSYSTEM	Target System to Run Background Job	nvarchar	32	Allow NULL?
9	SDLDATE	Date of job/step scheduling	nvarchar	8	Allow NULL?
10	SDLTIME	Time of a scheduled job/step	nvarchar	6	Allow NULL?
11	SDLUNAME	Initiator of job/step scheduling	nvarchar	12	Allow NULL?
12	LASTCHDATE	Date of last job change	nvarchar	8	Allow NULL?
13	LASTCHTIME	Time of last job change	nvarchar	6	Allow NULL?
14	LASTCHNAME	Last job change made by	nvarchar	12	Allow NULL?
15	RELDATE	Release Date for Background Scheduling	nvarchar	8	Allow NULL?
16	RELTIME	Release time of scheduled background job	nvarchar	6	Allow NULL?
17	RELUNAME	User that released scheduled batch job	nvarchar	12	Allow NULL?
18	STRTDATE	Job start date	nvarchar	8	Allow NULL?
19	STRTTIME	Batch job start time	nvarchar	6	Allow NULL?
20	ENDDATE	Job start date	nvarchar	8	Allow NULL?
21	ENDTIME	Batch job start time	nvarchar	6	Allow NULL?
22	PRDMINS	Duration period (in minutes) for a batch job	nvarchar	2	Allow NULL?
23	PRDHOURS	Duration period (in hours) for a batch job	nvarchar	2	Allow NULL?
24	PRDDAYS	Duration (in days) of DBA action	nvarchar	3	Allow NULL?
25	PRDWEEKS	Duration period (in weeks) for a batch job	nvarchar	2	Allow NULL?
26	PRDMONTHS	Duration period (in months) for a batch job	nvarchar	2	Allow NULL?
27	PERIODIC	Periodic Jobs Indicator	char	1	Allow NULL?
28	DELANFREP	Job deletion indicator after processing	char	1	Allow NULL?
29	EMERGMODE	Emergency Job operation indicator (content 'X')	char	1	Allow NULL?
30	STATUS	State of Background Job	char	1	Allow NULL?
31	NEWFLAG	New job ID creation flag	char	1	Allow NULL?
32	AUTHCKNAM	Background User Name for Authorization Check	nvarchar	12	Allow NULL?
33	AUTHCKMAN	Background client for authorization check	nvarchar	3	Allow NULL?
34	SUCCNUM	Number of successor job(s)	int	10	Allow NULL?
35	PREDNUM	Number of previous jobs	int	10	Allow NULL?
36	JOBLOG	TemSe object name	nvarchar	20	Allow NULL?
37	LASTSTRTDT	Latest Execution Date for a Background Job	nvarchar	8	Allow NULL?
38	LASTSTRTTM	Latest Execution Time for Background Job	nvarchar	6	Allow NULL?
39	WPNUMBER	Work process number	int	10	Allow NULL?
40	WPPROCID	Work process ID	int	10	Allow NULL?
41	EVENTID	Background Processing Event	nvarchar	32	Allow NULL?
42	EVENTPARM	Background Event Parameters (Such as, Jobname/Jobcount)	nvarchar	64	Allow NULL?
43	BTCSYSREAX	Target System to Run Background Job	nvarchar	32	Allow NULL?
44	JOBCLASS	Job classification	char	1	Allow NULL?
45	PRIORITY	Job priority	int	10	Allow NULL?
46	EVENTCOUNT	Event number	nvarchar	8	Allow NULL?
47	CHECKSTAT	Job status check indicator for subsequent job start	char	1	Allow NULL?
48	CALENDARID	Factory Calendar ID for Background Processing	nvarchar	2	Allow NULL?
49	PRDBEHAV	Period behavior of jobs on non-workdays	char	1	Allow NULL?
50	EXECSERVER	Server name	nvarchar	20	Allow NULL?
51	EOMCORRECT	Correction field for calc. job execution (end-of-mth, cal.)	int	10	Allow NULL?
52	CALCORRECT	Correction field for calc. job execution (end-of-mth, cal.)	int	10	Allow NULL?
53	REAXSERVER	Server name	nvarchar	20	Allow NULL?
54	RECLOGSYS	Logical system	nvarchar	10	Allow NULL?
55	RECOBJTYPE	Object Type	nvarchar	10	Allow NULL?
56	RECOBJKEY	Object key	nvarchar	70	Allow NULL?
57	RECDESCRIB	Describe flag	nvarchar	10	Allow NULL?
58	TGTSRVGRP	Server Group Name Background Processing	nvarchar	40	Allow NULL?

Name	Primary	Unique	Type	Columns
TBTCO~0	Yes	Yes	CLUSTERED	JOBCOUNT, JOBNAME
TBTCO~1	No	No	NONCLUSTERED	AUTHCKMAN, SDLUNAME
TBTCO~3	No	No	NONCLUSTERED	JOBNAME, STATUS
TBTCO~5	No	No	NONCLUSTERED	EVENTPARM, EVENTID
TBTCO~7	No	No	NONCLUSTERED	BTCSYSREAX, WPPROCID, STATUS
TBTCO~8	No	No	NONCLUSTERED	STATUS, STRTTIME, STRTDATE
TBTCO~9	No	No	NONCLUSTERED	JOBNAME, SDLUNAME, STATUS, SDLSTRTTM, SDLSTRTDT

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

58 COLUMNS | 7 INDEXES | ERP 6.0 | TBTCO TABLE

TOP ERP 6.0 | TBTCO COLUMNS

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

58 COLUMNS | 7 INDEXES | ERP 6.0 | TBTCO TABLE

TOPERP 6.0 | TBTCO COLUMNS

TOPERP 6.0 | TBTCO INDEXES

TOP ERP 6.0 | TBTCO COLUMNS

TOP ERP 6.0 | TBTCO INDEXES