I_ListedSubstanceNameText

DDL: I_LISTEDSUBSTANCENAMETEXT SQL: ILISUNAMET Type: view BASIC

Listed Substance Text View

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

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_LSTDSUBSTUNIONNAME P_LSTDSUBSTUNIONNAME from

Associations (2)

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

Annotations (13)

NameValueLevelField
EndUserText.label Listed Substance Text View view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ListedSubstanceUUID view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ILISUNAMET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 P_LSTDSUBSTUNIONNAME sequence_number
ListedSubstanceNameUUID P_LSTDSUBSTUNIONNAME db_key
_Language _Language
ListedSubstanceName P_LSTDSUBSTUNIONNAME text
CreationDateTime P_LSTDSUBSTUNIONNAME datetime_cr
LastChangeDateTime P_LSTDSUBSTUNIONNAME datetime_ch 
@EndUserText.label: 'Listed Substance Text View'
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ListedSubstanceUUID'
@AccessControl:
{
  authorizationCheck: #CHECK
}

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

define view I_ListedSubstanceNameText
  as select from P_LSTDSUBSTUNIONNAME
  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( P_LSTDSUBSTUNIONNAME.parent_key as ehfnd_lisu_key_ref preserving type )    as ListedSubstanceUUID,
      _ListedSubstance,

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

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

      // Admin data

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

Learn More