APJ_V_JOB_STATUS_INT

DDL: APJ_V_JOB_STATUS_INT SQL: APJ_V_JSTAT_INT Type: view
4 Fields 2 Data Sources

konvertiert internen in externen Status

APJ_V_JOB_STATUS_INT is a CDS View that provides data about "konvertiert internen in externen Status" in SAP S/4HANA. It reads from 2 data sources (apj_d_job_exe, APJ_V_JOB_RUN_OVERVIEW) and exposes 4 fields with key fields jobname, jobcount.

Data Sources (2)

SourceAliasJoin Type
apj_d_job_exe jobs from
APJ_V_JOB_RUN_OVERVIEW runs inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName APJ_V_JSTAT_INT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label konvertiert internen in externen Status view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY jobname APJ_V_JOB_RUN_OVERVIEW job_name Job No.
KEY jobcount APJ_V_JOB_RUN_OVERVIEW job_run_count Job No.
status APJ_V_JOB_RUN_OVERVIEW job_run_status
created_by apj_d_job_exe created_by Version Created By

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 APJ_V_JOB_STATUS_INT.
-- 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: APJ_V_JSTAT_INT

CREATE VIEW APJ_V_JOB_STATUS_INT AS
SELECT
  runs.job_name AS jobname,
  runs.job_run_count AS jobcount,
  runs.job_run_status AS status,
  jobs.created_by AS created_by
FROM apj_d_job_exe AS jobs
INNER JOIN APJ_V_JOB_RUN_OVERVIEW AS runs ON /* join condition not captured in parsed metadata */
;

Learn More