P_APJ_X_JOB_TEMPLATE

DDL: P_APJ_X_JOB_TEMPLATE SQL: P_APJ_X_JT Type: view Package: SBTI_APJ_DT
4 Fields 1 Data Sources 1 Associations

Client-dependent Job Template

P_APJ_X_JOB_TEMPLATE is a CDS View that provides data about "Client-dependent Job Template" in SAP S/4HANA. It reads from 1 data source (apj_x_jt_root) and exposes 4 fields. It has 1 association to related views. Part of development package SBTI_APJ_DT.

Data Sources (1)

SourceAliasJoin Type
apj_x_jt_root Root from

Associations (1)

CardinalityTargetAliasCondition
[0..*] P_APJ_JOB_TEMPLATE_VALUE Value Value.job_template_name = Root.job_template_name and Value.job_template_version = Root.job_template_version

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName P_APJ_X_JT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Client-dependent Job Template view

Fields (4)

KeyFieldSource TableSource FieldDescription
user_name user_name User Name
layer_c layer_c Layer Code
text text User Group
Value Value Value from table

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_APJ_X_JOB_TEMPLATE.
-- 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: P_APJ_X_JT

CREATE VIEW P_APJ_X_JOB_TEMPLATE AS
SELECT
  user_name,
  layer_c,
  text,
  Value
FROM apj_x_jt_root AS Root
LEFT OUTER JOIN P_APJ_JOB_TEMPLATE_VALUE AS Value ON Value.job_template_name = Root.job_template_name AND Value.job_template_version = Root.job_template_version  -- association [0..*]
;

Learn More