I_ListedSubstanceNameText

DDL: I_LISTEDSUBSTANCENAMETEXT SQL: ILISUNAMET Type: view COMPOSITE Package: EHFND_BO_LISTED_SUBSTANCE

Listed Substance Text View

I_ListedSubstanceNameText is a Composite CDS View that provides data about "Listed Substance Text View" in SAP S/4HANA. It reads from 1 data source (I_LstdSubstWthVarAndGrpName) and exposes 9 fields with key fields ListedSubstanceUUID, Language, ListedSubstanceNameSequence. It has 2 associations to related views. Part of development package EHFND_BO_LISTED_SUBSTANCE.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_LstdSubstWthVarAndGrpName ListedSubstanceAll from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ListedSubstance _ListedSubstance $projection.ListedSubstanceUUID = _ListedSubstance.ListedSubstanceUUID
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
EndUserText.label Listed Substance Text View view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ListedSubstanceUUID view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.sqlViewName ILISUNAMET 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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ListedSubstanceUUID
_ListedSubstance _ListedSubstance
KEY Language
KEY ListedSubstanceNameSequence I_LstdSubstWthVarAndGrpName ListedSubstanceNameSequence
ListedSubstanceNameUUID I_LstdSubstWthVarAndGrpName ListedSubstanceNameUUID
_Language _Language
ListedSubstanceName I_LstdSubstWthVarAndGrpName ListedSubstanceName
CreationDateTime I_LstdSubstWthVarAndGrpName CreationDateTime
LastChangeDateTime I_LstdSubstWthVarAndGrpName LastChangeDateTime 
@EndUserText.label: 'Listed Substance Text View'
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ListedSubstanceUUID'
@AccessControl:
{
  authorizationCheck: #MANDATORY
}

@AbapCatalog.sqlViewName: 'ILISUNAMET'
@AbapCatalog.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 }

define view I_ListedSubstanceNameText
  as select from I_LstdSubstWthVarAndGrpName as ListedSubstanceAll
  association [0..1] to I_ListedSubstance as _ListedSubstance   on $projection.ListedSubstanceUUID = _ListedSubstance.ListedSubstanceUUID
  association [0..1] to I_Language        as _Language          on $projection.Language           = _Language.Language
{
  key cast( ListedSubstanceAll.ListedSubstanceUUID as ehfnd_lisu_key_ref preserving type ) as ListedSubstanceUUID,
      _ListedSubstance,

      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key cast( ListedSubstanceAll.Language as sylangu preserving type )                        as Language,
  key ListedSubstanceAll.ListedSubstanceNameSequence                                        as ListedSubstanceNameSequence,
      ListedSubstanceAll.ListedSubstanceNameUUID                                            as ListedSubstanceNameUUID,
      _Language,

      @Semantics.text:true
      ListedSubstanceAll.ListedSubstanceName                                                as ListedSubstanceName,

      // Admin data

      @Semantics.systemDateTime.createdAt: true
      ListedSubstanceAll.CreationDateTime                                                   as CreationDateTime,
      @Semantics.systemDateTime.lastChangedAt: true
      ListedSubstanceAll.LastChangeDateTime                                                 as LastChangeDateTime
}
where
  mandt = $session.client

Learn More