I_ListedSubstanceDefNameCust

DDL: I_LISTEDSUBSTANCEDEFNAMECUST Type: view COMPOSITE Package: EHFND_BO_LISTED_SUBSTANCE

Default Name in All Languages for Customer LiSu

I_ListedSubstanceDefNameCust is a Composite CDS View that provides data about "Default Name in All Languages for Customer LiSu" in SAP S/4HANA. It reads from 1 data source (I_LstdSubstWthVarAndGrpName) and exposes 5 fields with key fields ListedSubstanceUUID, Language. Part of development package EHFND_BO_LISTED_SUBSTANCE.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_LstdSubstWthVarAndGrpName LisuName from

Annotations (12)

NameValueLevelField
EndUserText.label Default Name in All Languages for Customer LiSu view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey ListedSubstanceUUID view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.sqlViewName ILISUDEFCUS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ListedSubstanceUUID
KEY Language I_LstdSubstWthVarAndGrpName Language
ListedSubstance I_LstdSubstWthVarAndGrpName ListedSubstance
Sequence I_LstdSubstWthVarAndGrpName ListedSubstanceNameSequence
ListedSubstanceName I_LstdSubstWthVarAndGrpName ListedSubstanceName 
@EndUserText.label: 'Default Name in All Languages for Customer LiSu'
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'ListedSubstanceUUID'
@AccessControl.authorizationCheck: #MANDATORY

@AbapCatalog: {
  sqlViewName: 'ILISUDEFCUS',
  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

define view I_ListedSubstanceDefNameCust
  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 cast( LisuName.ListedSubstanceUUID as ehfnd_lisu_key_nce preserving type ) as ListedSubstanceUUID,
      @Semantics.language: true
  key LisuName.Language                                                  as Language,

      // ID

      LisuName.ListedSubstance                                           as ListedSubstance,

      LisuName.ListedSubstanceNameSequence                               as Sequence,
      LisuName.ListedSubstanceName                                       as ListedSubstanceName
      
} where LisuName.CreatedByUser <> 'SAP'

Learn More