I_LISTEDSUBSTANCEDEFNAME

CDS View

Listed Substance Default Names

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

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EHSSubjectText view union COMPOSITE Subject text 
@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,
  preserveKey: 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, either from customer table or from content. 

// Returns one record per listed substance and language 


define view I_ListedSubstanceDefName
as
// Select name from customer table with minimum sequence whether there exists any content name or not 

// (sequence of customer name is always < 11 and therefore has precedence)

select from I_ListedSubstance
join        I_ListedSubstanceDefNameCust     as CustListedSubstanceName   on I_ListedSubstance.ListedSubstance   = CustListedSubstanceName.ListedSubstance
//join        I_Language                       as Language                  on  CustListedSubstanceName.Language   = Language.Language

{
   key I_ListedSubstance.ListedSubstanceUUID                as ListedSubstanceUUID, 
   key I_ListedSubstance.ListedSubstance                    as ListedSubstance,
//   key Language.LanguageISOCode                             as Language,

   key CustListedSubstanceName.Language                     as Language,
   key CustListedSubstanceName.ListedSubstanceName          as ListedSubstanceName,
       CustListedSubstanceName.Sequence                     as Sequence
 } 
 
union
// Select name from content with sequence = 11 where no customer name exists (left outer join to customer name where customer name is null)

select from     I_ListedSubstance
join            I_ListedSubstanceDefNameSAP  as CntntListedSubstanceName  on  I_ListedSubstance.ListedSubstance  = CntntListedSubstanceName.ListedSubstance
//join            I_Language                   as Language                  on  CntntListedSubstanceName.Language  = Language.Language

left outer to one join I_ListedSubstanceDefNameCust as CustListedSubstanceName   on  CntntListedSubstanceName.ListedSubstance = CustListedSubstanceName.ListedSubstance
                                                                          and CntntListedSubstanceName.Language  = CustListedSubstanceName.Language
{

   key I_ListedSubstance.ListedSubstanceUUID                as ListedSubstanceUUID, 
   key I_ListedSubstance.ListedSubstance                    as ListedSubstance,
   key CntntListedSubstanceName.Language                    as Language,
   
//   key Language.LanguageISOCode                             as Language,

   key CntntListedSubstanceName.ListedSubstanceName         as ListedSubstanceName,
       CntntListedSubstanceName.Sequence                    as Sequence
} 
where CustListedSubstanceName.Sequence is null
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LISTEDSUBSTANCE",
"I_LISTEDSUBSTANCEDEFNAMECUST",
"I_LISTEDSUBSTANCEDEFNAMESAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More