SAP ABAP View TBTCJCNTXT (Inner Join of Job Data and Contexts)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-BTC (Application Component) Background Processing
     ⤷ SBTI (Package) User Interface and Job-API of Background Processing

Basic Data

View Type	D	Database View
Database View	TBTCJCNTXT
Short Description	Inner Join of Job Data and Contexts
Root table	TBTCO	Job Status Overview Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TBTCO	TBTCO
2	TBTCCNTXT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TBTCO	JOBNAME	JL	EQ				0	0
2	TBTCCNTXT	JOBNAME	JR	EQ			AND	0	0
3	TBTCO	JOBCOUNT	JL	EQ				0	0
4	TBTCCNTXT	JOBCOUNT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	TBTCO	*		☐		☐
2	JOBNAME	TBTCO	JOBNAME		☐	BTCJOB	☐	Background job name
3	JOBCOUNT	TBTCO	JOBCOUNT		☐	BTCJOBCNT	☐	Job ID
4	JOBGROUP	TBTCO	JOBGROUP		☐	BTCJOBGRP	☐	Summary of jobs for a group
5	INTREPORT	TBTCO	INTREPORT		☐	BTCREP	☐	Name of internal report for batch job
6	STEPCOUNT	TBTCO	STEPCOUNT		☐	BTCSTEPCNT	☐	Job step ID number.
7	SDLSTRTDT	TBTCO	SDLSTRTDT		☐	BTCSDATE	☐	Planned Start Date for Background Job
8	SDLSTRTTM	TBTCO	SDLSTRTTM		☐	BTCSTIME	☐	Planned start time for background Job
9	BTCSYSTEM	TBTCO	BTCSYSTEM		☐	BTCTGTSYS	☐	Target System to Run Background Job
10	SDLDATE	TBTCO	SDLDATE		☐	BTCSDLDATE	☐	Date of job/step scheduling
11	SDLTIME	TBTCO	SDLTIME		☐	BTCSDLTIME	☐	Time of a scheduled job/step
12	SDLUNAME	TBTCO	SDLUNAME		☐	BTCSDLNM	☐	Initiator of job/step scheduling
13	LASTCHDATE	TBTCO	LASTCHDATE		☐	BTCJCHDATE	☐	Date of last job change
14	LASTCHTIME	TBTCO	LASTCHTIME		☐	BTCJCHTIME	☐	Time of last job change
15	LASTCHNAME	TBTCO	LASTCHNAME		☐	BTCJCHNM	☐	Last job change made by
16	RELDATE	TBTCO	RELDATE		☐	BTCRELDT	☐	Release Date for Background Scheduling
17	RELTIME	TBTCO	RELTIME		☐	BTCRELTM	☐	Release time of scheduled background job
18	RELUNAME	TBTCO	RELUNAME		☐	BTCRELNM	☐	User that released scheduled batch job
19	STRTDATE	TBTCO	STRTDATE		☐	BTCXDATE	☐	Job start date
20	STRTTIME	TBTCO	STRTTIME		☐	BTCXTIME	☐	Batch job start time
21	ENDDATE	TBTCO	ENDDATE		☐	BTCXDATE	☐	Job start date
22	ENDTIME	TBTCO	ENDTIME		☐	BTCXTIME	☐	Batch job start time
23	PRDMINS	TBTCO	PRDMINS		☐	BTCPMIN	☐	Duration period (in minutes) for a batch job
24	PRDHOURS	TBTCO	PRDHOURS		☐	BTCPHOUR	☐	Duration period (in hours) for a batch job
25	PRDDAYS	TBTCO	PRDDAYS		☐	BTCPDAY	☐	Duration (in days) of DBA action
26	PRDWEEKS	TBTCO	PRDWEEKS		☐	BTCPWEEK	☐	Duration period (in weeks) for a batch job
27	PRDMONTHS	TBTCO	PRDMONTHS		☐	BTCPMNTH	☐	Duration period (in months) for a batch job
28	PERIODIC	TBTCO	PERIODIC		☐	BTCPFLAG	☐	Periodic Jobs Indicator
29	DELANFREP	TBTCO	DELANFREP		☐	BTCDELFLAG	☐	Job deletion indicator after processing
30	EMERGMODE	TBTCO	EMERGMODE		☐	BTCEFLAG	☐	Emergency Job operation indicator (content 'X')
31	STATUS	TBTCO	STATUS		☐	BTCSTATUS	☐	Background Job Status
32	NEWFLAG	TBTCO	NEWFLAG		☐	BTCNEWFLAG	☐	New job ID creation flag
33	AUTHCKNAM	TBTCO	AUTHCKNAM		☐	BTCAUTHNAM	☐	Background User Name for Authorization Check
34	AUTHCKMAN	TBTCO	AUTHCKMAN		☐	BTCAUTHMAN	☐	Background client for authorization check
35	SUCCNUM	TBTCO	SUCCNUM		☐	BTCSNUM	☐	Number of successor job(s)
36	PREDNUM	TBTCO	PREDNUM		☐	BTCPNUM	☐	Number of previous jobs
37	JOBLOG	TBTCO	JOBLOG		☐	RSTSONAME	☐	TemSe object name
38	LASTSTRTDT	TBTCO	LASTSTRTDT		☐	BTCLSDATE	☐	Latest Execution Date for a Background Job
39	LASTSTRTTM	TBTCO	LASTSTRTTM		☐	BTCLSTIME	☐	Latest Execution Time for Background Job
40	WPNUMBER	TBTCO	WPNUMBER		☐	BTCWPNO	☐	Work process number
41	WPPROCID	TBTCO	WPPROCID		☐	BTCWPPID	☐	Work process ID
42	EVENTID	TBTCO	EVENTID		☐	BTCEVENTID	☐	Background Processing Event
43	EVENTPARM	TBTCO	EVENTPARM		☐	BTCEVTPARM	☐	Background Event Parameters (Such as, Jobname/Jobcount)
44	BTCSYSREAX	TBTCO	BTCSYSREAX		☐	BTCTGTSYS	☐	Target System to Run Background Job
45	JOBCLASS	TBTCO	JOBCLASS		☐	BTCJOBCLAS	☐	Job classification
46	PRIORITY	TBTCO	PRIORITY		☐	BTCJOBPRIO	☐	Job priority
47	EVENTCOUNT	TBTCO	EVENTCOUNT		☐	BTCEVTCNT	☐	Event number
48	CHECKSTAT	TBTCO	CHECKSTAT		☐	BTCCKSTAT	☐	Job status check indicator for subsequent job start
49	CALENDARID	TBTCO	CALENDARID		☐	BTCCALID	☐	Factory calendar ID for background processing
50	PRDBEHAV	TBTCO	PRDBEHAV		☐	BTCPRDBHV	☐	Period behavior of jobs on non-workdays
51	EXECSERVER	TBTCO	EXECSERVER		☐	BTCSRVNAME	☐	Server name
52	EOMCORRECT	TBTCO	EOMCORRECT		☐	BTCEOMCORR	☐	Correction field for calc. job execution (end-of-mth, cal.)
53	CALCORRECT	TBTCO	CALCORRECT		☐	BTCEOMCORR	☐	Correction field for calc. job execution (end-of-mth, cal.)
54	REAXSERVER	TBTCO	REAXSERVER		☐	BTCSRVNAME	☐	Server name
55	RECLOGSYS	TBTCO	RECLOGSYS		☐	LOGSYS	☐	Logical system
56	RECOBJTYPE	TBTCO	RECOBJTYPE		☐	SWO_OBJTYP	☐	Object Type
57	RECOBJKEY	TBTCO	RECOBJKEY		☐	SWO_TYPEID	☐	Object key
58	RECDESCRIB	TBTCO	RECDESCRIB		☐	SWO_DESCRB	☐	Describe flag
59	TGTSRVGRP	TBTCO	TGTSRVGRP		☐	BPSRVGRPN	☐	Server Group Name Background Processing
60	CTXTTYPE	TBTCCNTXT	CTXTTYPE		☐	BTCCTXTTYP	☐	Reference type: assignment of job to component or creator
61	CTXTVAL	TBTCCNTXT	CTXTVAL		☐	BTCCTXT	☐	Reference value from job creator to identify job
62	CTXTTEXT	TBTCCNTXT	CTXTTEXT		☐	BTCCTXTT	☐	Reference or job creator description

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130604
SAP Release Created in