I_CHEMICALROOT

CDS View

Chemical Root

I_CHEMICALROOT is a CDS View in S/4HANA. Chemical Root. It contains 4 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 4 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ChemicalDetailsC view from COMPOSITE DEPRECATED: Chemcial Details Cube
I_ChmRskAtEHSLocC view from COMPOSITE Chemical Risk at EHS Location Cube
I_EHSSubject view inner COMPOSITE Subject
I_EHSSubjectText view inner COMPOSITE Subject text
P_HzdsSubstInvtrySubstProposal view inner CONSUMPTION Private view for proposed substances for the HSI

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ChemicalUUID ChemicalUUID 2
_ChemicalType _ChemicalType 2
ChemicalID EHSSubjectID 1
ChemicalType ChemicalType 2 
@EndUserText.label: 'Chemical Root'
@Analytics: { dataCategory:#DIMENSION , dataExtraction.enabled:true }
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'ChemicalUUID'
@Metadata.allowExtensions:true

@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.sqlViewName: 'ICHMROOT'
@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:  #M,         // < 100.000

                         dataClass: #MASTER }

define view I_ChemicalRoot
  as select from ehfndd_chm_root

  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_ChemicalRevision as _ChemicalRevision  on $projection.ChemicalUUID = _ChemicalRevision.ChemicalUUID
  association [1..1] to I_ChemicalType     as _ChemicalType      on $projection.ChemicalType = _ChemicalType.ChemicalType

{
  key cast( db_key as ehfnd_chm_uuid_ref preserving type )      as ChemicalUUID,
      _ChemicalRevision,

      id                                                        as ChemicalID,

      @ObjectModel.foreignKey.association: '_ChemicalType'
      cast( chm_nature as ehfnd_chm_nature_nc preserving type ) as ChemicalType,
      @ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
      _ChemicalType,


      // Admin data

      datetime_cr                                               as CreationDateTime,
      user_id_cr                                                as CreatedByUser,
      _CreatedByUser,
      datetime_ch                                               as LastChangeDateTime,
      user_id_ch                                                as LastChangedByUser,
      _LastChangedByUser

}

Learn More