XAJ_JOB_STEP_INFO

DDL: XAJ_JOB_STEP_INFO SQL: XAJ_JOB_STEP Type: view Package: SBTI_XAJ

Application Job Step Info

XAJ_JOB_STEP_INFO is a CDS View that provides data about "Application Job Step Info" in SAP S/4HANA. It reads from 4 data sources (APJ_V_JCE_TEXT, apj_d_job_exe, APJ_V_STATUS_TEXT, XAJ_ALL_JOBSTEPS) and exposes 5 fields with key fields jobname, jobcount, stepnr. Part of development package SBTI_XAJ.

Data Sources (4)

SourceAliasJoin Type
APJ_V_JCE_TEXT jce_text left_outer
apj_d_job_exe job inner
APJ_V_STATUS_TEXT stat_text left_outer
XAJ_ALL_JOBSTEPS step from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName XAJ_JOB_STEP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Application Job Step Info view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY jobname XAJ_ALL_JOBSTEPS job_name Job No.
KEY jobcount XAJ_ALL_JOBSTEPS jobcount Job number
KEY stepnr XAJ_ALL_JOBSTEPS stepcount Step no.
step_status XAJ_ALL_JOBSTEPS status Workflow Status
step_app_rc XAJ_ALL_JOBSTEPS app_rc

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 XAJ_JOB_STEP_INFO.
-- 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: XAJ_JOB_STEP

CREATE VIEW XAJ_JOB_STEP_INFO AS
SELECT
  step.job_name AS jobname,
  step.jobcount AS jobcount,
  step.stepcount AS stepnr,
  step.status AS step_status,
  step.app_rc AS step_app_rc
FROM XAJ_ALL_JOBSTEPS AS step
INNER JOIN apj_d_job_exe AS job ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APJ_V_JCE_TEXT AS jce_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APJ_V_STATUS_TEXT AS stat_text ON /* join condition not captured in parsed metadata */
;