I_LSTDSUBSTWTHVARANDGRP

CDS View

Listed Substance View

I_LSTDSUBSTWTHVARANDGRP is a CDS View in S/4HANA. Listed Substance View. It contains 12 fields. 11 CDS views read from this table.

Used by 11 CDS view(s) 12 fields

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_HzdsSubstInvtryHzdsIngrdntVH view from CONSUMPTION Value help for Hazardous Ingredients
C_ListedSubstanceElementDEX view_entity from CONSUMPTION Listed Substance Element
Ehfnd_Lisu_Name view from Name of a listed substance
I_ListedSubstance view from COMPOSITE Listed Substance View
I_ListedSubstanceCust view from COMPOSITE Listed Substances provided by Customer
I_ListedSubstanceGroup view from COMPOSITE Listed Substance Group View
I_ListedSubstanceSAP view from COMPOSITE Listed Substances provided by SAP
I_ListedSubstanceVariant view from COMPOSITE Listed Substance Variant View
I_ListedSubstanceVariant view inner COMPOSITE Listed Substance Variant View
I_ListedSubstMigrationVH view from COMPOSITE Listed Substance Migration
P_NameOnGrpMbrListRptblQty view_entity inner COMPOSITE Internal View for the CFR49 Name on List for Rptbl Qty

Fields (12)

KeyField CDS FieldsUsed in Views
KEY ListedSubstanceUUID ListedSubstanceUUID,ListedSubstanceVariantUUID,lisu_root_key 4
CASNumber CASNumber 3
ContentProvider ContentProvider 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
ECNumber ECNumber 2
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
ListedSubstance ListedSubstanceVariant 1
ListedSubstanceCndn ListedSubstanceCndn,ListedSubstanceCndnCode 2
ListedSubstanceReference ListedSubstanceReference 1
MolecularFormula MolecularFormula 1 
@AbapCatalog.sqlViewName: 'ILISU'
@AbapCatalog.compiler.compareFilter: true
@AccessControl:
{
  authorizationCheck: #MANDATORY,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}
@EndUserText.label: 'Listed Substance View'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'ListedSubstanceUUID'
@Analytics: { dataCategory:#DIMENSION , dataExtraction.enabled: true }

@Metadata.allowExtensions: true
// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

// Used for BOBF Master Data Object

@ObjectModel.usageType:
{
  serviceQuality: #A,
  sizeCategory: #L,       // < 10.000.000

  dataClass: #MASTER
}
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view I_LstdSubstWthVarAndGrp
  as select from ehfndd_lisu_rt
  association [0..1] to I_User                       as _CreatedByUser     on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                       as _LastChangedByUser on  $projection.LastChangedByUser = _LastChangedByUser.UserID
  association [0..*] to I_ListedSubstanceNameText    as _Text              on  $projection.ListedSubstanceUUID = _Text.ListedSubstanceUUID
  association [0..1] to I_ListedSubstanceDefaultName as _DefaultName       on  $projection.ListedSubstance     = _DefaultName.ListedSubstance
                                                                           and $projection.ListedSubstanceUUID = _DefaultName.ListedSubstanceUUID
  association [0..1] to I_ListedSubstanceCndnText    as _SubstanceCndnText on  $projection.ListedSubstanceCndn = _SubstanceCndnText.ListedSubstanceCndn
                                                                           and _SubstanceCndnText.Language     = $session.system_language
{
      //      @ObjectModel.text.association: '_Text'    removed with note 2636226 26.04.2018

  key cast( db_key as ehfnd_lisu_key_nce preserving type )                as ListedSubstanceUUID,

      // ID

      listsub_id                                                          as ListedSubstance,

      // Identifiers

      cast(cas_number as ehfnd_chm_cas_no preserving type )               as CASNumber,
      ec_number                                                           as ECNumber,
      mol_formula                                                         as MolecularFormula,

      // Variant related attributes

      cast(condition_code as ehfnd_lisu_cond_code_plain preserving type ) as ListedSubstanceCndn,
      cast(listsub_id_root as ehfnd_regbaslst_sub_ref preserving type)    as ListedSubstanceReference,

      // Group related attributes

      is_group_ind                                                        as ListedSubstanceIsGroup,

      // Admin data

      @Semantics.systemDateTime.lastChangedAt: true
      cast(datetime_ch  as timestamp preserving type)                     as LastChangeDateTime,
      @Semantics.systemDateTime.createdAt: true
      cast(datetime_cr as timestamp preserving type)                      as CreationDateTime,
      user_id_ch                                                          as LastChangedByUser,
      user_id_cr                                                          as CreatedByUser,
      @Semantics.uuid
      bco_key                                                             as ListedSubstanceCharUUID,
      content_provider                                                    as ContentProvider,

      /* Associations */
      _Text,
      _DefaultName,
      _SubstanceCndnText,
      _CreatedByUser,
      _LastChangedByUser

}

Learn More