I_LISTEDSUBSTANCENAMETEXTSAP

CDS View

Listed Substance Text View (SAP Content Only)

I_LISTEDSUBSTANCENAMETEXTSAP is a CDS View in S/4HANA. Listed Substance Text View (SAP Content Only). 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ListedSubstanceNameSAPDEX view_entity from CONSUMPTION SAP Listed Substance Name Data Extraction
I_ListedSubstanceDefNameSAP view from BASIC Default Name in All Languages for SAP LiSu 
@EndUserText.label: 'Listed Substance Text View (SAP Content Only)'
@Analytics.dataExtraction.enabled: false
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ListedSubstanceUUID'
@AccessControl:
{
  authorizationCheck: #MANDATORY
}

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

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view I_ListedSubstanceNameTextSAP
  as select from ehfndi_lisu_name
  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( parent_key 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 sequence_number                                          as ListedSubstanceNameSequence,
      db_key                                                   as ListedSubstanceNameUUID,
      _Language,
      ehfndi_lisu_name.listsub_id                              as ListedSubstance,
      @Semantics.text:true
      text                                                     as ListedSubstanceName,

      // Admin data

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

      @Semantics.uuid
      bco_key                                                  as ListedSubstanceCharUUID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDI_LISU_NAME"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_LISTEDSUBSTANCE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More