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

	Product	Version	Table	Columns	Indexes	Description	Module
Basis Components :: Use Subcomponents :: Background Processing
1	ERP EHP7	6.0	TBTCP	71	3	Background Job Step Overview	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	STEPCOUNT	Job step ID number.	int	10	Allow NULL?
4	PROGNAME	Program name within a step (e.g. report)	nvarchar	40	Allow NULL?
5	PROGFROMLN	Line number in an internal report.	int	10	Allow NULL?
6	PROGTOLN	Line number in an internal report.	int	10	Allow NULL?
7	SDLDATE	Date of job/step scheduling	nvarchar	8	Allow NULL?
8	SDLTIME	Time of a scheduled job/step	nvarchar	6	Allow NULL?
9	SDLUNAME	Initiator of job/step scheduling	nvarchar	12	Allow NULL?
10	VARIANT	Name of variant within a step	nvarchar	14	Allow NULL?
11	AUTHCKNAM	Background User Name for Authorization Check	nvarchar	12	Allow NULL?
12	LISTIDENT	ID of batch job output list in the spool	nvarchar	10	Allow NULL?
13	XPGPID	ID of external program	nvarchar	10	Allow NULL?
14	XPGTGTSYS	Target System to Run Background Job	nvarchar	32	Allow NULL?
15	XPGRFCDEST	Logical Destination (Specified in Function Call)	nvarchar	32	Allow NULL?
16	XPGPROG	Name of external program (possibly with access path)	nvarchar	128	Allow NULL?
17	XPGPARAMS	Parameters of external program (string)	nvarchar	255	Allow NULL?
18	XPGFLAG	Identification of step as ABAP, ext. command or program	char	1	Allow NULL?
19	CONNCNTL	Control flag for external program (e.g. trace level)	char	1	Allow NULL?
20	STDINCNTL	Control flag for external program (e.g. trace level)	char	1	Allow NULL?
21	STDOUTCNTL	Control flag for external program (e.g. trace level)	char	1	Allow NULL?
22	STDERRCNTL	Control flag for external program (e.g. trace level)	char	1	Allow NULL?
23	TRACECNTL	Control flag for external program (e.g. trace level)	char	1	Allow NULL?
24	TERMCNTL	Control flag for external program (e.g. trace level)	char	1	Allow NULL?
25	STATUS	Status of step in background processing	char	1	Allow NULL?
26	EXITCODE	Exit code of an external program	int	10	Allow NULL?
27	LANGUAGE	Language Key	char	1	Allow NULL?
28	EXTCMD	Name of Logical Command	nvarchar	18	Allow NULL?
29	OPSYSTEM	Operating System of Application Server	nvarchar	10	Allow NULL?
30	PDEST	Spool Output Device	nvarchar	4	Allow NULL?
31	PRCOP	Number of Spool Copies	nvarchar	3	Allow NULL?
32	PLIST	Spool Request	nvarchar	12	Allow NULL?
33	PRTXT	Spool Description	nvarchar	68	Allow NULL?
34	PRIMM	Immediate Spool Print	char	1	Allow NULL?
35	PRREL	Immediate Spool Deletion	char	1	Allow NULL?
36	PRNEW	New Spool Request	char	1	Allow NULL?
37	PEXPI	Spool Retention Period	char	1	Allow NULL?
38	LINCT	Page Length of List	int	10	Allow NULL?
39	LINSZ	Line width of list	int	10	Allow NULL?
40	PAART	Spool Format	nvarchar	16	Allow NULL?
41	PRBIG	Spool Cover Sheet	char	1	Allow NULL?
42	PRSAP	Print: SAP cover page	char	1	Allow NULL?
43	PRREC	Spool Recipient Name	nvarchar	12	Allow NULL?
44	PRABT	Spool Department Name	nvarchar	12	Allow NULL?
45	PRBER	Print: Authorization	nvarchar	12	Allow NULL?
46	PRDSN	Spool File	nvarchar	6	Allow NULL?
47	PTYPE	Print: Type of spool request	nvarchar	12	Allow NULL?
48	ARMOD	Print: Archiving mode	char	1	Allow NULL?
49	FOOTL	Print: Output footer	char	1	Allow NULL?
50	PRCHK	Print: Check sum for print and archiving parameters	int	10	Allow NULL?
51	SAP_OBJECT	Archiving Parameter: Object Type of SAP Object	nvarchar	10	Allow NULL?
52	AR_OBJECT	Archiving Parameter: Document Type	nvarchar	10	Allow NULL?
53	ARCHIV_ID	Archiving Parameter: Target Storage System	nvarchar	2	Allow NULL?
54	DOC_TYPE	Archiving Parameter: Document Type	nvarchar	20	Allow NULL?
55	RPC_HOST	Archiving Parameter: RPC Host	nvarchar	32	Allow NULL?
56	RPC_SERVIC	Archiving Parameter: RPC Service/RFC Destination	nvarchar	32	Allow NULL?
57	INTERFACE	Archiving Parameter: Communication Connection Component	nvarchar	14	Allow NULL?
58	MANDANT	Archiving Parameter: Client	nvarchar	3	Allow NULL?
59	REPORT	Archiving Parameter: Program Name	nvarchar	40	Allow NULL?
60	INFO	Archiving Parameter: Info Field	nvarchar	3	Allow NULL?
61	ARCTEXT	Archiving Parameter: Text Information Field	nvarchar	40	Allow NULL?
62	DATUM	Archiving Parameter: Archiving Date	nvarchar	8	Allow NULL?
63	ARCUSER	Archiving Parameter: User	nvarchar	12	Allow NULL?
64	PRINTER	Archiving Parameter: Target Output Device	nvarchar	4	Allow NULL?
65	FORMULAR	Archiving Parameter: Output Format	nvarchar	16	Allow NULL?
66	ARCHIVPATH	Archiving Parameter: Standard Path	nvarchar	70	Allow NULL?
67	PROTOKOLL	Archiving Parameter: Log	nvarchar	8	Allow NULL?
68	VERSION	Archiving Parameter: Version Number	nvarchar	4	Allow NULL?
69	ACHECK	Archiving Parameter: Check Total	int	10	Allow NULL?
70	PRIPARKEY	Key for print parameters	nvarchar	16	Allow NULL?
71	CONVID	Conversation ID	nvarchar	8	Allow NULL?

Name	Primary	Unique	Type	Columns
TBTCP~0	Yes	Yes	CLUSTERED	STEPCOUNT, JOBCOUNT, JOBNAME
TBTCP~1	No	No	NONCLUSTERED	VARIANT, PROGNAME
TBTCP~2	No	No	NONCLUSTERED	XPGPROG

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

71 COLUMNS | 3 INDEXES | ERP 6.0 | TBTCP TABLE

TOP ERP 6.0 | TBTCP COLUMNS

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

71 COLUMNS | 3 INDEXES | ERP 6.0 | TBTCP TABLE

TOPERP 6.0 | TBTCP COLUMNS

TOPERP 6.0 | TBTCP INDEXES

TOP ERP 6.0 | TBTCP COLUMNS

TOP ERP 6.0 | TBTCP INDEXES