I_EHSEMITTEDSUBSTANCEDATASET

CDS View

EHS Emitted Substances Data Set Basic

I_EHSEMITTEDSUBSTANCEDATASET is a CDS View in S/4HANA. EHS Emitted Substances Data Set Basic. It contains 4 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 4 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_EHSAmountsForActivity view inner COMPOSITE Amounts for Activity
I_EHSEnvRptPRTRSubstEmsnsDecln view_entity inner COMPOSITE EmD Data for PRTR report
I_EHSLocAggrgnEmtdSubst view from COMPOSITE Location Aggregation for Emitted Subst

Fields (4)

KeyField CDS FieldsUsed in Views
EHSEmittedSubstanceUUID EHSEmittedSubstanceUUID 1
EHSEmittedSubstDataSetID EHSComplianceScenActivityID 1
EHSEmittedSubstDataSetTitle EHSComplianceScenActivityTitle,EHSEmittedSubstDataSetTitle 2
EHSEmittedSubstDataSetUUID EHSComplianceScenActivityUUID,EHSEmittedSubstDataSetUUID 2 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'EHS Emitted Substances Data Set Basic'

@ObjectModel: {
  usageType: {
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL,
    serviceQuality: #A
  }
}

@VDM:{
  viewType:#BASIC
}

define view entity I_EHSEmittedSubstanceDataSet
  as select from ehenvd_emsu_dset
  association [1..1] to I_EHSEmittedSubstDataSetType as _EHSEmittedSubstDataSetType on $projection.EHSEmittedSubstDataSetType = _EHSEmittedSubstDataSetType.EHSEmittedSubstDataSetType

{
  key cast( db_key as ehenv_emsub_dset_uuid preserving type )   as EHSEmittedSubstDataSetUUID,
      parent_key                                                as EHSEmittedSubstanceUUID,
      id                                                        as EHSEmittedSubstDataSetID,
      cast(type as ehenv_emsub_dtaset_type_nc preserving type ) as EHSEmittedSubstDataSetType,
      title                                                     as EHSEmittedSubstDataSetTitle,
      cast(unit as ehenv_emsub_dset_unit preserving type )      as EHSEmittedSubstDataSetUnit,
      _EHSEmittedSubstDataSetType
}

Learn More