P_ListSubstGrpDefName

DDL: P_LISTSUBSTGRPDEFNAME Type: view_entity COMPOSITE

P_ListSubstGrpDefName is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Language, I_CmplRqVersSubstListGrp) and exposes 5 fields with key fields ListedSubstanceGroup, Language, BCO_ID, CmplRqVersUUID, RegulatoryListUUID.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_Language Language cross
I_CmplRqVersSubstListGrp list_subst_grp from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ListedSubstanceGroup I_CmplRqVersSubstListGrp ListedSubstanceGroup
KEY Language I_Language Language
KEY BCO_ID I_CmplRqVersSubstListGrp CmplRqVers
KEY CmplRqVersUUID I_CmplRqVersSubstListGrp CmplRqVersUUID
KEY RegulatoryListUUID I_CmplRqVersSubstListGrp SubstanceListUUID 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM: {
  private: true,
  viewType: #COMPOSITE
}

@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #MIXED
  }
}

// This view selects the substanced goups for substances which are assigned to a substance group on a substance list.

// and select the default name from the substance group


define view entity P_ListSubstGrpDefName

  as select from I_CmplRqVersSubstListGrp as list_subst_grp

    cross join   I_Language               as Language
{
  key list_subst_grp.ListedSubstanceGroup,
  key Language.Language,
  key list_subst_grp.CmplRqVers        as BCO_ID,
  key list_subst_grp.CmplRqVersUUID,
  key list_subst_grp.SubstanceListUUID as RegulatoryListUUID

}

Learn More