P_SUBSTLSTDSUBSTDFLTNAME

CDS View

Determines the default name of Listed Substances

P_SUBSTLSTDSUBSTDFLTNAME is a CDS View in S/4HANA. Determines the default name of Listed Substances. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SubstLstdSubstDfltNameFB view_entity from COMPOSITE Lisu Default Name with Language Fallback
P_SubstLstdSubstDfltNameFB view_entity union COMPOSITE Lisu Default Name with Language Fallback

Fields (2)

KeyField CDS FieldsUsed in Views
ListedSubstanceDefaultName ListedSubstanceDefaultName 1
ListedSubstanceUUID ListedSubstanceUUID 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
// This CDS View determines the default name of Listed Substances that are used as base of a company substance

define view entity P_SubstLstdSubstDfltName
  as select from I_SubstanceActiveDraft as Substance
  association [0..1] to I_ListedSubstanceDefName as _ListedSubstanceDfltName on $projection.ListedSubstanceUUID = _ListedSubstanceDfltName.ListedSubstanceUUID
{
  key Substance.ActiveSubstanceUUID                as ActiveSubstanceUUID,
  
  key _ListedSubstanceDfltName.Language            as Language,
  
      Substance.ListedSubstanceUUID                as ListedSubstanceUUID,
  
      _ListedSubstanceDfltName.ListedSubstanceName as ListedSubstanceDefaultName
}

Learn More