SAP ABAP View V_OP (Join from tbtco and tbtcp)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-BTC (Application Component) Background Processing
     ⤷ SBTC (Package) SAP Background Processing

Basic Data

View Type	D	Database View
Database View	V_OP
Short Description	Join from tbtco and tbtcp
Root table	TBTCO	Job Status Overview Table

Table

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

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	TBTCP	JOBNAME	JR	EQ			AND	0	0
3	TBTCO	JOBCOUNT	JL	EQ				0	0
4	TBTCP	JOBCOUNT	JR	EQ				0	0

View Fields

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

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	20141013
SAP Release Created in