SAP ABAP View AGS_V_JOB_EXT (Job Documentation)

Hierarchy

☛ ST (Software Component) SAP Solution Manager Tool
   ⤷ SV-SMG-PSM (Application Component) Process Scheduling Management
     ⤷ AGS_EXTJOB_REPOSITORY (Package) Job Scheduling Management Main Package

Basic Data

View Type	D	Database View
Database View	AGS_V_JOB_EXT
Short Description	Job Documentation
Root table	AGS_JOB_HEAD	Background Job Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AGS_JOB_HEAD	AGS_JOB_HEAD
2	AGS_JOB_DEF

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AGS_JOB_HEAD	DEFINITION_ID	JL	EQ				0	0
2	AGS_JOB_DEF	DEFINITION_ID	JR	EQ			AND	0	0
3	AGS_JOB_HEAD	CURRENT_VERSION	JL	EQ				0	0
4	AGS_JOB_DEF	VERSION	JR	EQ			AND	0	0
5	AGS_JOB_HEAD	JOBDOC_TYPE	JL	EQ				0	0
6	AGS_JOB_DEF	JOBDOC_TYPE	JR	EQ			AND	0	0
7	AGS_JOB_DEF	JOBDOC_TYPE		EQ	'J'		OR	0	0
8	AGS_JOB_DEF	JOBDOC_TYPE		EQ	''		OR	0	0
9	AGS_JOB_DEF	JOBDOC_TYPE		EQ	'N'		OR	0	0
10	AGS_JOB_DEF	JOBDOC_TYPE		EQ	'C'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	KONZS	AGS_JOB_HEAD	KONZS		☐	KONZS	☐	Group key
2	DEFINITION_ID	AGS_JOB_HEAD	DEFINITION_ID		☐	AGS_EJR_JOB_DEFINITION_ID	☐	Unique ID of a Job Definition
3	EXTERNAL_STATUS	AGS_JOB_HEAD	EXTERNAL_STATUS		☐	AGS_EJR_EXTERNAL_STATUS	☐	Status Management
4	JOB_TYPE	AGS_JOB_DEF	JOB_TYPE		☐	AGS_EJR_STEP_TYPE_CODE	☐	Job Types in SAP Solution Manager
5	JOB_TYPE_DEF	AGS_JOB_DEF	JOB_TYPE_DEF		☐	AGS_EJR_JOBDOC_TYPE	☐	Documentation Type
6	JOB_STATUS	AGS_JOB_DEF	JOB_STATUS		☐	AGS_EJR_STATUS	☐	Documentation Status
7	JOB_NAME	AGS_JOB_DEF	JOB_NAME		☐	AGS_EJR_JOB_NAME	☐	Job Documentation Name
8	JOB_STEP_ID	AGS_JOB_DEF	JOB_STEP_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
9	CONTEXT_ID	AGS_JOB_DEF	CONTEXT_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
10	LINK_ID	AGS_JOB_DEF	LINK_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
11	INSTANCE_ID	AGS_JOB_DEF	INSTANCE_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
12	MONITORING_ID	AGS_JOB_DEF	MONITORING_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
13	PARTNER_ID	AGS_JOB_DEF	PARTNER_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
14	ESCALATION_ID	AGS_JOB_DEF	ESCALATION_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
15	ERRORHANDLING_ID	AGS_JOB_DEF	ERRORHANDLING_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
16	CREATED_BY	AGS_JOB_DEF	CREATED_BY		☐	AGS_EJR_USER	☐	User Name
17	CREATED_ON	AGS_JOB_DEF	CREATED_ON		☐	AGS_EJR_TIME_STAMP	☐	Time Stamp
18	CHANGED_BY	AGS_JOB_DEF	CHANGED_BY		☐	AGS_EJR_USER	☐	User Name
19	CHANGED_ON	AGS_JOB_DEF	CHANGED_ON		☐	AGS_EJR_TIME_STAMP	☐	Time Stamp
20	VERSION	AGS_JOB_DEF	VERSION		☐	AGS_EJR_VERSION	☐	Job Documentation Version
21	SCHEDULER_TYPE	AGS_JOB_DEF	SCHEDULER_TYPE		☐	AGS_EJR_SCHEDULER_TYPE	☐	Scheduler Type
22	RESTRICTION_ID	AGS_JOB_DEF	RESTRICTION_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
23	JOBDOC_NO	AGS_JOB_HEAD	JOBDOC_NO		☐	AGS_EJR_JOBDOC_NUMBER	☐	Job Documentation ID
24	VALID_UNTIL	AGS_JOB_DEF	VALID_UNTIL		☐	AGS_EJR_DUE_DATE	☐	Due Date
25	BU_PARTNER	AGS_JOB_HEAD	BU_PARTNER		☐	BU_PARTNER	☐	Business Partner Number
26	EXTERNAL_ID	AGS_JOB_HEAD	EXTERNAL_ID		☐	AGS_EJR_IDENTIFIER	☐	Unique ID
27	JOBDOC_TYPE	AGS_JOB_HEAD	JOBDOC_TYPE		☐	AGS_EJR_DOC_TYPE	☐	Document Type for Display

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