P_SubstanceSubstListUnion

DDL: P_SUBSTANCESUBSTLISTUNION Type: view_entity CONSUMPTION Package: EHFND_CNS_SUBSTANCE
19 Fields 6 Data Sources

Substance Lists of Substances

P_SubstanceSubstListUnion is a Consumption CDS View that provides data about "Substance Lists of Substances" in SAP S/4HANA. It reads from 6 data sources and exposes 19 fields with key field UUID. Part of development package EHFND_CNS_SUBSTANCE.

Data Sources (6)

SourceAliasJoin Type
I_CmplRqVersExposureLimit _ExposureLimit union_all
I_CmplRqVersOrganicPrxd _OrganicPrxd union_all
I_CmplRqVersSelfReactvSubst _SelfReactvSubst union_all
I_CmplRqVersThldListItm _ThldListItm union_all
I_CmplRqVersGrpAssgmt GroupAssgmt from
I_CmplRqVersGrpAssgmtCust GroupAssgmtChange union_all

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Substance Lists of Substances view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY UUID I_CmplRqVersGrpAssgmt SubstanceGrpAssgmtUUID Substance Group Assignment
CmplRqVersUUID I_CmplRqVersGrpAssgmt CmplRqVersUUID NodeID
SubstanceListUUID Substance List
SubstanceGrpAssgmtCustChgdUUIDasUUID
CmplRqVersUUID I_CmplRqVersGrpAssgmtCust CmplRqVersUUID NodeID
SubstanceListUUID I_CmplRqVersGrpAssgmtCust SubstanceListUUID Substance List
SubstanceListItmUUIDasUUID
CmplRqVersUUID I_CmplRqVersThldListItm CmplRqVersUUID NodeID
SubstanceListUUID I_CmplRqVersThldListItm SubstanceListUUID Substance List
OccptlExpsrLmtUUIDasUUID
CmplRqVersUUID I_CmplRqVersExposureLimit CmplRqVersUUID NodeID
SubstanceListUUID I_CmplRqVersExposureLimit SubstanceListUUID Substance List
CmplRqVersOrganicPrxdUUIDasUUID
CmplRqVersUUID I_CmplRqVersOrganicPrxd CmplRqVersUUID NodeID
SubstanceListUUID I_CmplRqVersOrganicPrxd SubstanceListUUID Substance List
CmplRqVersSelfReactvSubstUUIDasUUID
CmplRqVersUUID I_CmplRqVersSelfReactvSubst CmplRqVersUUID NodeID
SubstanceListUUID I_CmplRqVersSelfReactvSubst SubstanceListUUID Substance List
ListedSubstance I_CmplRqVersSelfReactvSubst ListedSubstance Listed Substance

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_SubstanceSubstListUnion.
-- 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_SubstanceSubstListUnion AS
SELECT
  GroupAssgmt.SubstanceGrpAssgmtUUID AS UUID,
  GroupAssgmt.CmplRqVersUUID AS CmplRqVersUUID,
  GroupAssgmt._SubstListGrp.SubstanceListUUID AS SubstanceListUUID,
  GroupAssgmt.ListedSubstance as ListedSubstance AS SubstanceGrpAssgmtCustChgdUUIDasUUID,
  GroupAssgmtChange.ListedSubstance as ListedSubstance AS SubstanceListItmUUIDasUUID,
  _ThldListItm.ListedSubstance as ListedSubstance AS OccptlExpsrLmtUUIDasUUID,
  _ExposureLimit.ListedSubstance as ListedSubstance AS CmplRqVersOrganicPrxdUUIDasUUID,
  _OrganicPrxd.ListedSubstance as ListedSubstance AS CmplRqVersSelfReactvSubstUUIDasUUID,
  _SelfReactvSubst.ListedSubstance AS ListedSubstance
FROM I_CmplRqVersGrpAssgmt AS GroupAssgmt
-- UNION ALL with additional select branch(es): I_CmplRqVersGrpAssgmtCust, I_CmplRqVersThldListItm, I_CmplRqVersExposureLimit, I_CmplRqVersOrganicPrxd, I_CmplRqVersSelfReactvSubst
;

Learn More