P_SubstanceLstdSubstUnion

DDL: P_SUBSTANCELSTDSUBSTUNION Type: view_entity CONSUMPTION Package: EHFND_CNS_SUBSTANCE

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. Part of development package EHFND_CNS_SUBSTANCE.

2 data source(s) 5 fields

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
KEY ListedSubstanceUUID I_Substance ListedSubstanceUUID
SubstanceUUIDasSubstanceUUID
KEY ListedSubstanceUUID I_SubstanceVarAssgmt ListedSubstanceVariantUUID
ListedSubstance _ListedSubstanceVariant ListedSubstanceVariant 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Substance with its (Sub-)Root LiSus'
@Metadata.ignorePropagatedAnnotations: true
@VDM.private:true
@VDM.viewType: #CONSUMPTION
define view entity P_SubstanceLstdSubstUnion

  as select from I_Substance as Substance
  association [1..1] to I_ListedSubstance as _RootListedSubstance on _RootListedSubstance.ListedSubstanceUUID = Substance.ListedSubstanceUUID
{
  key Substance.SubstanceUUID              as SubstanceUUID,
  key Substance.ListedSubstanceUUID        as ListedSubstanceUUID,
      _RootListedSubstance.ListedSubstance as ListedSubstance
}

union all
// select group assignment records which were added by the customer

select from I_SubstanceVarAssgmt as SubstanceVar
association [1..1] to I_ListedSubstanceVariant as _ListedSubstanceVariant on _ListedSubstanceVariant.ListedSubstanceVariantUUID = SubstanceVar.ListedSubstanceVariantUUID
{
  key SubstanceVar.SubstanceUUID                     as SubstanceUUID,
  key SubstanceVar.ListedSubstanceVariantUUID        as ListedSubstanceUUID,
      _ListedSubstanceVariant.ListedSubstanceVariant as ListedSubstance
}

Learn More