P_JobStatus

DDL: P_JOBSTATUS SQL: PJOBSTATUS Type: view BASIC
3 Fields 1 Data Sources

P_JobStatus is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (tbtco) and exposes 3 fields with key fields ApplicationJobName, ApplicationJob.

Data Sources (1)

SourceAliasJoin Type
tbtco tbtco from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PJOBSTATUS view
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ApplicationJobName jobname Name of Send Process
KEY ApplicationJob jobcount Job number
ScheduledByUser sdluname Job scheduler

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_JobStatus.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PJOBSTATUS

CREATE VIEW P_JobStatus AS
SELECT
  jobname AS ApplicationJobName,
  jobcount AS ApplicationJob,
  sdluname AS ScheduledByUser
FROM tbtco
;

Learn More