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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	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	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	JOBNAME	Background job name	nvarchar	32	CHAR	(N' ')	No		BTCJOB	Allow NULL?
2	JOBCOUNT	Job ID	nvarchar	8	CHAR	(N' ')	No		BTCJOBCNT	Allow NULL?
3	JOBGROUP	Summary of jobs for a group	nvarchar	12	CHAR	(N' ')	Yes		BTCJOBGRP	Allow NULL?
4	INTREPORT	Name of internal report for batch job	nvarchar	40	CHAR	(N' ')	Yes		BTCREP	Allow NULL?
5	STEPCOUNT	Job step ID number.	int	10	INT4	((0))	Yes		BTCSTEPCNT	Allow NULL?
6	SDLSTRTDT	Planned Start Date for Background Job	nvarchar	8	DATS	(N'00000000')	Yes		BTCSDATE	Allow NULL?
7	SDLSTRTTM	Planned start time for background Job	nvarchar	6	TIMS	(N'000000')	Yes		BTCSTIME	Allow NULL?
8	BTCSYSTEM	Target System to Run Background Job	nvarchar	32	CHAR	(N' ')	Yes		BTCTGTSYS	Allow NULL?
9	SDLDATE	Date of job/step scheduling	nvarchar	8	DATS	(N'00000000')	Yes		BTCSDLDATE	Allow NULL?
10	SDLTIME	Time of a scheduled job/step	nvarchar	6	TIMS	(N'000000')	Yes		BTCSDLTIME	Allow NULL?
11	SDLUNAME	Initiator of job/step scheduling	nvarchar	12	CHAR	(N' ')	Yes		BTCSDLNM	Allow NULL?
12	LASTCHDATE	Date of last job change	nvarchar	8	DATS	(N'00000000')	Yes		BTCJCHDATE	Allow NULL?
13	LASTCHTIME	Time of last job change	nvarchar	6	TIMS	(N'000000')	Yes		BTCJCHTIME	Allow NULL?
14	LASTCHNAME	Last job change made by	nvarchar	12	CHAR	(N' ')	Yes		BTCJCHNM	Allow NULL?
15	RELDATE	Release Date for Background Scheduling	nvarchar	8	DATS	(N'00000000')	Yes		BTCRELDT	Allow NULL?
16	RELTIME	Release time of scheduled background job	nvarchar	6	TIMS	(N'000000')	Yes		BTCRELTM	Allow NULL?
17	RELUNAME	User that released scheduled batch job	nvarchar	12	CHAR	(N' ')	Yes		BTCRELNM	Allow NULL?
18	STRTDATE	Job start date	nvarchar	8	DATS	(N'00000000')	Yes		BTCXDATE	Allow NULL?
19	STRTTIME	Batch job start time	nvarchar	6	TIMS	(N'000000')	Yes		BTCXTIME	Allow NULL?
20	ENDDATE	Job start date	nvarchar	8	DATS	(N'00000000')	Yes		BTCXDATE	Allow NULL?
21	ENDTIME	Batch job start time	nvarchar	6	TIMS	(N'000000')	Yes		BTCXTIME	Allow NULL?
22	PRDMINS	Duration period (in minutes) for a batch job	nvarchar	2	NUMC	(N'00')	Yes		BTCPMIN	Allow NULL?
23	PRDHOURS	Duration period (in hours) for a batch job	nvarchar	2	NUMC	(N'00')	Yes		BTCPHOUR	Allow NULL?
24	PRDDAYS	Duration (in days) of DBA action	nvarchar	3	NUMC	(N'000')	Yes		BTCPDAY	Allow NULL?
25	PRDWEEKS	Duration period (in weeks) for a batch job	nvarchar	2	NUMC	(N'00')	Yes		BTCPWEEK	Allow NULL?
26	PRDMONTHS	Duration period (in months) for a batch job	nvarchar	2	NUMC	(N'00')	Yes		BTCPMNTH	Allow NULL?
27	PERIODIC	Periodic Jobs Indicator	char	1	CHAR	(N' ')	Yes		BTCPFLAG	Allow NULL?
28	DELANFREP	Job deletion indicator after processing	char	1	CHAR	(N' ')	Yes		BTCDELFLAG	Allow NULL?
29	EMERGMODE	Emergency Job operation indicator (content 'X')	char	1	CHAR	(N' ')	Yes		BTCEFLAG	Allow NULL?
30	STATUS	State of Background Job	char	1	CHAR	(N' ')	Yes		BTCSTATUS	Allow NULL?
31	NEWFLAG	New job ID creation flag	char	1	CHAR	(N' ')	Yes		BTCNEWFLAG	Allow NULL?
32	AUTHCKNAM	Background User Name for Authorization Check	nvarchar	12	CHAR	(N' ')	Yes		BTCAUTHNAM	Allow NULL?
33	AUTHCKMAN	Background client for authorization check	nvarchar	3	CLNT	(N'000')	Yes	*	BTCAUTHMAN	Allow NULL?
34	SUCCNUM	Number of successor job(s)	int	10	INT4	((0))	Yes		BTCSNUM	Allow NULL?
35	PREDNUM	Number of previous jobs	int	10	INT4	((0))	Yes		BTCPNUM	Allow NULL?
36	JOBLOG	TemSe object name	nvarchar	20	CHAR	(N' ')	Yes		RSTSONAME	Allow NULL?
37	LASTSTRTDT	Latest Execution Date for a Background Job	nvarchar	8	DATS	(N'00000000')	Yes		BTCLSDATE	Allow NULL?
38	LASTSTRTTM	Latest Execution Time for Background Job	nvarchar	6	TIMS	(N'000000')	Yes		BTCLSTIME	Allow NULL?
39	WPNUMBER	Work process number	int	10	INT4	((0))	Yes		BTCWPNO	Allow NULL?
40	WPPROCID	Work process ID	int	10	INT4	((0))	Yes		BTCWPPID	Allow NULL?
41	EVENTID	Background Processing Event	nvarchar	32	CHAR	(N' ')	Yes		BTCEVENTID	Allow NULL?
42	EVENTPARM	Background Event Parameters (Such as, Jobname/Jobcount)	nvarchar	64	CHAR	(N' ')	Yes		BTCEVTPARM	Allow NULL?
43	BTCSYSREAX	Target System to Run Background Job	nvarchar	32	CHAR	(N' ')	Yes		BTCTGTSYS	Allow NULL?
44	JOBCLASS	Job classification	char	1	CHAR	(N' ')	Yes		BTCJOBCLAS	Allow NULL?
45	PRIORITY	Job priority	int	10	INT4	((0))	Yes		BTCJOBPRIO	Allow NULL?
46	EVENTCOUNT	Event number	nvarchar	8	CHAR	(N' ')	Yes		BTCEVTCNT	Allow NULL?
47	CHECKSTAT	Job status check indicator for subsequent job start	char	1	CHAR	(N' ')	Yes		BTCCKSTAT	Allow NULL?
48	CALENDARID	Factory Calendar ID for Background Processing	nvarchar	2	CHAR	(N' ')	Yes		BTCCALID	Allow NULL?
49	PRDBEHAV	Period behavior of jobs on non-workdays	char	1	CHAR	(N' ')	Yes		BTCPRDBHV	Allow NULL?
50	EXECSERVER	Server name	nvarchar	20	CHAR	(N' ')	Yes		BTCSRVNAME	Allow NULL?
51	EOMCORRECT	Correction field for calc. job execution (end-of-mth, cal.)	int	10	INT4	((0))	Yes		BTCEOMCORR	Allow NULL?
52	CALCORRECT	Correction field for calc. job execution (end-of-mth, cal.)	int	10	INT4	((0))	Yes		BTCEOMCORR	Allow NULL?
53	REAXSERVER	Server name	nvarchar	20	CHAR	(N' ')	Yes		BTCSRVNAME	Allow NULL?
54	RECLOGSYS	Logical system	nvarchar	10	CHAR	(N' ')	Yes	*	LOGSYS	Allow NULL?
55	RECOBJTYPE	Object Type	nvarchar	10	CHAR	(N' ')	Yes	*	SWO_OBJTYP	Allow NULL?
56	RECOBJKEY	Object key	nvarchar	70	CHAR	(N' ')	Yes		SWO_TYPEID	Allow NULL?
57	RECDESCRIB	Describe flag	nvarchar	10	CHAR	(N' ')	Yes		SWO_DESCRB	Allow NULL?
58	TGTSRVGRP	Server Group Name Background Processing	nvarchar	40	CHAR	(N' ')	Yes		BPSRVGRPN	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