I_ListedSubstanceNameTextCust

DDL: I_LISTEDSUBSTANCENAMETEXTCUST Type: view_entity COMPOSITE Package: EHFND_BO_LISTED_SUBSTANCE

Name of Listed Substance Provided by Customer

I_ListedSubstanceNameTextCust is a Composite CDS View that provides data about "Name of Listed Substance Provided by Customer" in SAP S/4HANA. It reads from 1 data source (I_LstdSubstWthVarAndGrpName) and exposes 11 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) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_LstdSubstWthVarAndGrpName I_LstdSubstWthVarAndGrpName from

Associations (2)

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

Annotations (10)

NameValueLevelField
EndUserText.label Name of Listed Substance Provided by Customer view
Analytics.dataExtraction.enabled false view
Analytics.technicalName ILISUNAMETCUS view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ListedSubstanceUUID view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ListedSubstanceUUID
_ListedSubstance _ListedSubstance
KEY Language
KEY ListedSubstanceNameSequence ListedSubstanceNameSequence
ListedSubstanceNameUUID ListedSubstanceNameUUID
_Language _Language
ListedSubstance ListedSubstance
ListedSubstanceName ListedSubstanceName
CreationDateTime
LastChangeDateTime
ListedSubstanceCharUUID ListedSubstanceNameCharUUID 
@EndUserText.label: 'Name of Listed Substance Provided by Customer'
@Analytics.dataExtraction.enabled: false
@Analytics.technicalName: 'ILISUNAMETCUS'
@VDM.viewType: #COMPOSITE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ListedSubstanceUUID'
@AccessControl:
{
  authorizationCheck: #MANDATORY
}
// used for BOBF Master Data Object

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

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MASTER }

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity I_ListedSubstanceNameTextCust
  as select from I_LstdSubstWthVarAndGrpName
  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( ListedSubstanceUUID as ehfnd_lisu_key_nce preserving type ) as ListedSubstanceUUID, // conversion

      _ListedSubstance,

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

      // Admin data

      @Semantics.systemDateTime.createdAt: true
      cast( CreationDateTime as ehfnd_datetime_cr preserving type )    as CreationDateTime,
      @Semantics.systemDateTime.lastChangedAt: true
      cast( LastChangeDateTime as ehfnd_datetime_ch preserving type )  as LastChangeDateTime,

      @Semantics.uuid
      ListedSubstanceNameCharUUID                                      as ListedSubstanceCharUUID
      
} where CreatedByUser <> 'SAP'

Learn More