XAJ_JOB_TEMPLATE_PARAMS

DDL: XAJ_JOB_TEMPLATE_PARAMS SQL: XAJ_JT_PAR Type: view Package: SBTI_XAJ

JT Parameters

XAJ_JOB_TEMPLATE_PARAMS is a CDS View that provides data about "JT Parameters" in SAP S/4HANA. It reads from 4 data sources (APJ_V_JT_SEQUENCE_W, APJ_V_JT_SEQUENCE_X, apj_w_jce_par, apj_x_jce_par) and exposes 15 fields with key fields JobParameterName, JobParameterName. Part of development package SBTI_XAJ.

Data Sources (4)

SourceAliasJoin Type
APJ_V_JT_SEQUENCE_W jce_root_w from
APJ_V_JT_SEQUENCE_X jce_root_x union_all
apj_w_jce_par par_w inner
apj_x_jce_par par_x inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName XAJ_JT_PAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label JT Parameters view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY JobParameterName apj_w_jce_par job_parameter_name Parameter
JobCatalogEntryName apj_w_jce_par job_catalog_entry_name Job Catalog
MandatoryInd apj_w_jce_par mandatory_ind Mandatory Parameter
JobSequenceName apj_w_jce_par job_sequence_name Sequence Name
JobParameterGroupName apj_w_jce_par job_parameter_group_name Parameter Group
JobParameterHiddenInd apj_w_jce_par job_parameter_hidden_ind Hidden Indicator
JobParameterReadOnlyInd apj_w_jce_par job_parameter_read_only_ind Read Only
KEY JobParameterName apj_x_jce_par job_parameter_name Parameter
JobCatalogEntryName apj_x_jce_par job_catalog_entry_name Job Catalog
MandatoryInd apj_x_jce_par mandatory_ind Mandatory Parameter
JobSequenceName apj_x_jce_par job_sequence_name Sequence Name
JobParameterGroupName apj_x_jce_par job_parameter_group_name Parameter Group
JobParameterHiddenInd apj_x_jce_par job_parameter_hidden_ind Hidden Indicator
JobParameterReadOnlyInd apj_x_jce_par job_parameter_read_only_ind Read Only
JobParameterPosition apj_x_jce_par job_parameter_position INT2

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_TEMPLATE_PARAMS.
-- 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_JT_PAR

CREATE VIEW XAJ_JOB_TEMPLATE_PARAMS AS
SELECT
  par_w.job_parameter_name AS JobParameterName,
  par_w.job_catalog_entry_name AS JobCatalogEntryName,
  par_w.mandatory_ind AS MandatoryInd,
  par_w.job_sequence_name AS JobSequenceName,
  par_w.job_parameter_group_name AS JobParameterGroupName,
  par_w.job_parameter_hidden_ind AS JobParameterHiddenInd,
  par_w.job_parameter_read_only_ind AS JobParameterReadOnlyInd,
  par_x.job_parameter_position AS JobParameterPosition
FROM APJ_V_JT_SEQUENCE_W AS jce_root_w
INNER JOIN apj_w_jce_par AS par_w ON /* join condition not captured in parsed metadata */
INNER JOIN apj_x_jce_par AS par_x ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): APJ_V_JT_SEQUENCE_X
;