I_EHSEmittedSubstDataSetType

DDL: I_EHSEMITTEDSUBSTDATASETTYPE Type: view_entity BASIC

Emitted Substance Data Set Type

I_EHSEmittedSubstDataSetType is a Basic CDS View that provides data about "Emitted Substance Data Set Type" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field EHSEmittedSubstDataSetType.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l Domain from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Emitted Substance Data Set Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY EHSEmittedSubstDataSetType
EHSEmittedSubstDetnTypeText DomainText ddtext 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Emitted Substance Data Set Type'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MIXED
}

@VDM:{
  viewType:#BASIC
}
define view entity I_EHSEmittedSubstDataSetType
  as select from           dd07l as Domain
    left outer to one join dd07t as DomainText on  Domain.domname        = DomainText.domname
                                               and Domain.domvalue_l     = DomainText.domvalue_l
                                               and DomainText.ddlanguage = $session.system_language
{

  key  cast ( Domain.domvalue_l as ehenv_emsub_dtaset_type_nc) as EHSEmittedSubstDataSetType,

       @Semantics.text: true
       DomainText.ddtext                                       as EHSEmittedSubstDetnTypeText
}

where
      Domain.domname      = 'EHENV_EMSUB_DTASET_TYPE_NC'
  and Domain.as4local     = 'A'
  and DomainText.domname  = 'EHENV_EMSUB_DTASET_TYPE_NC'
  and DomainText.as4local = 'A';

Learn More