FCCX_V_APJ_TEMPLATE_VAL_UNION

DDL: FCCX_V_APJ_TEMPLATE_VAL_UNION Type: view_entity
9 Fields 2 Data Sources

APJ Job Template Union

FCCX_V_APJ_TEMPLATE_VAL_UNION is a CDS View that provides data about "APJ Job Template Union" in SAP S/4HANA. It reads from 2 data sources (apj_w_jt_val, apj_x_jt_val) and exposes 9 fields with key fields uuid, uuid.

Data Sources (2)

SourceAliasJoin Type
apj_w_jt_val val from
apj_x_jt_val val union_all

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label APJ Job Template Union view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY uuid apj_x_jt_val uuid Waste Partner UUID
sign apj_x_jt_val sign Type of SIGN component in row type of a Ranges type
opt apj_x_jt_val opt Type of OPTION component in row type of a Ranges type
low apj_x_jt_val low Value from
KEY uuid apj_x_jt_val uuid Waste Partner UUID
sign apj_x_jt_val sign Type of SIGN component in row type of a Ranges type
opt apj_x_jt_val opt Type of OPTION component in row type of a Ranges type
low apj_x_jt_val low Value from
high apj_x_jt_val high Value up to

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 FCCX_V_APJ_TEMPLATE_VAL_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.

CREATE VIEW FCCX_V_APJ_TEMPLATE_VAL_UNION AS
SELECT
  val.uuid AS uuid,
  val.sign AS sign,
  val.opt AS opt,
  val.low AS low,
  val.high AS high
FROM apj_w_jt_val AS val
-- UNION ALL with additional select branch(es): apj_x_jt_val
;

Learn More