P_SubstanceLstdSubstUnion

DDL: P_SUBSTANCELSTDSUBSTUNION Type: view_entity CONSUMPTION
5 Fields 2 Data Sources 2 Associations

Substance with its (Sub-)Root LiSus

P_SubstanceLstdSubstUnion is a Consumption CDS View that provides data about "Substance with its (Sub-)Root LiSus" in SAP S/4HANA. It reads from 2 data sources (I_Substance, I_SubstanceVarAssgmt) and exposes 5 fields with key fields SubstanceUUID, ListedSubstanceUUID, ListedSubstanceUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_Substance Substance from
I_SubstanceVarAssgmt SubstanceVar union_all

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ListedSubstance _RootListedSubstance _RootListedSubstance.ListedSubstanceUUID = Substance.ListedSubstanceUUID
[1..1] I_ListedSubstanceVariant _ListedSubstanceVariant _ListedSubstanceVariant.ListedSubstanceVariantUUID = SubstanceVar.ListedSubstanceVariantUUID

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Substance with its (Sub-)Root LiSus view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SubstanceUUID I_Substance SubstanceUUID Substance
KEY ListedSubstanceUUID I_Substance ListedSubstanceUUID Name
SubstanceUUIDasSubstanceUUID
KEY ListedSubstanceUUID I_SubstanceVarAssgmt ListedSubstanceVariantUUID Name
ListedSubstance _ListedSubstanceVariant ListedSubstanceVariant

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_SubstanceLstdSubstUnion.
-- 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 P_SubstanceLstdSubstUnion AS
SELECT
  Substance.SubstanceUUID AS SubstanceUUID,
  Substance.ListedSubstanceUUID AS ListedSubstanceUUID,
  _RootListedSubstance.ListedSubstance as ListedSubstance AS SubstanceUUIDasSubstanceUUID,
  _ListedSubstanceVariant.ListedSubstanceVariant AS ListedSubstance
FROM I_Substance AS Substance
LEFT OUTER JOIN I_ListedSubstance AS _RootListedSubstance ON _RootListedSubstance.ListedSubstanceUUID = Substance.ListedSubstanceUUID  -- association [1..1]
LEFT OUTER JOIN I_ListedSubstanceVariant AS _ListedSubstanceVariant ON _ListedSubstanceVariant.ListedSubstanceVariantUUID = SubstanceVar.ListedSubstanceVariantUUID  -- association [1..1]
-- UNION ALL with additional select branch(es): I_SubstanceVarAssgmt
;

Learn More