I_LISTEDSUBSTANCEDEFNAME

CDS View

Listed Substance Default Names

I_LISTEDSUBSTANCEDEFNAME is a CDS View in S/4HANA. Listed Substance Default Names. It contains 4 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 4 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_EHSSubjectText view union COMPOSITE Subject text
I_ListedSubstanceDefaultName view from COMPOSITE Listed Substance Default Name
I_ListedSubstanceDefaultName view union COMPOSITE Listed Substance Default Name

Fields (4)

KeyField CDS FieldsUsed in Views
Language Language 1
ListedSubstanceName ListedSubstanceName 1
ListedSubstanceUUID ListedSubstanceUUID 1
Sequence Sequence 1 
@EndUserText.label: 'Listed Substance Default Names'
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'ListedSubstance'
@AccessControl.authorizationCheck: #MANDATORY

@AbapCatalog: 
{ 
  sqlViewName: 'ILISUDEFNAME',
  compiler.compareFilter: true
}

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MASTER }

@ObjectModel.dataCategory: #TEXT

// Reads the listed substance names for all languages. 

// Returns one record per listed substance and language 


define view I_ListedSubstanceDefName
as
select from I_LstdSubstWthVarAndGrpName as LisuName
       join P_LstdSubstPrimNameKey as MinKey on  LisuName.ListedSubstanceUUID         = MinKey.ListedSubstanceUUID
                                             and LisuName.ListedSubstance             = MinKey.ListedSubstance
                                             and LisuName.Language                    = MinKey.Language
                                             and LisuName.ListedSubstanceNameSequence = MinKey.MinSequence
{
   key LisuName.ListedSubstanceUUID                as ListedSubstanceUUID, 
   key LisuName.ListedSubstance                    as ListedSubstance,
   key LisuName.Language                           as Language,
   key LisuName.ListedSubstanceName                as ListedSubstanceName,
       LisuName.ListedSubstanceNameSequence        as Sequence
} 
where LisuName.ListedSubstanceNameSequence <= 11

Learn More