APJ_V_JOB_TEMPLATE_UNION

DDL: APJ_V_JOB_TEMPLATE_UNION SQL: APJ_V_JT_U Type: view Package: SBTI_APJ_DT

Union View Job Template

APJ_V_JOB_TEMPLATE_UNION is a CDS View that provides data about "Union View Job Template" in SAP S/4HANA. It reads from 2 data sources (APJ_V_JOB_TEMPLATE, APJ_V_X_JOB_TEMPLATE) and exposes 22 fields with key field mandt. Part of development package SBTI_APJ_DT.

Data Sources (2)

SourceAliasJoin Type
APJ_V_JOB_TEMPLATE APJ_V_JOB_TEMPLATE from
APJ_V_X_JOB_TEMPLATE APJ_V_X_JOB_TEMPLATE union_all

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName APJ_V_JT_U view
AbapCatalog.compiler.compareFilter true view
ClientDependent true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Union View Job Template view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY mandt
created_at APJ_V_JOB_TEMPLATE created_at Uploaded On
created_by APJ_V_JOB_TEMPLATE created_by Version Created By
changed_at APJ_V_JOB_TEMPLATE changed_at Timestamp
changed_by APJ_V_JOB_TEMPLATE changed_by User Name
auth_group APJ_V_JOB_TEMPLATE auth_group AuthorizGroup
report_name APJ_V_JOB_TEMPLATE report_name Report Name
seq_count APJ_V_JOB_TEMPLATE seq_count
jce_layer_c APJ_V_JOB_TEMPLATE jce_layer_c Layer Code
user_name User Name
text APJ_V_JOB_TEMPLATE text User Group
created_at APJ_V_X_JOB_TEMPLATE created_at Uploaded On
created_by APJ_V_X_JOB_TEMPLATE created_by Version Created By
changed_at APJ_V_X_JOB_TEMPLATE changed_at Timestamp
changed_by APJ_V_X_JOB_TEMPLATE changed_by User Name
auth_group APJ_V_X_JOB_TEMPLATE auth_group AuthorizGroup
report_name APJ_V_X_JOB_TEMPLATE report_name Report Name
seq_count APJ_V_X_JOB_TEMPLATE seq_count
jce_layer_c APJ_V_X_JOB_TEMPLATE jce_layer_c Layer Code
user_name APJ_V_X_JOB_TEMPLATE user_name User Name
text APJ_V_X_JOB_TEMPLATE text User Group
text_en APJ_V_X_JOB_TEMPLATE text_en User Group

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_TEMPLATE_UNION.
-- 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_JT_U

CREATE VIEW APJ_V_JOB_TEMPLATE_UNION AS
SELECT
  $session.client AS mandt,
  APJ_V_JOB_TEMPLATE.created_at AS created_at,
  APJ_V_JOB_TEMPLATE.created_by AS created_by,
  APJ_V_JOB_TEMPLATE.changed_at AS changed_at,
  APJ_V_JOB_TEMPLATE.changed_by AS changed_by,
  APJ_V_JOB_TEMPLATE.auth_group AS auth_group,
  APJ_V_JOB_TEMPLATE.report_name AS report_name,
  APJ_V_JOB_TEMPLATE.seq_count AS seq_count,
  APJ_V_JOB_TEMPLATE.jce_layer_c AS jce_layer_c,
  cast ( '' as syuname ) AS user_name,
  APJ_V_JOB_TEMPLATE.text AS text,
  APJ_V_X_JOB_TEMPLATE.text_en AS text_en
FROM APJ_V_JOB_TEMPLATE
-- UNION ALL with additional select branch(es): APJ_V_X_JOB_TEMPLATE
;