I_EHSDataPeriod

DDL: I_EHSDATAPERIOD SQL: IEHSDPERIOD Type: view BASIC Package: EHENV_BO_MDEF_IMPL

EHS Data Period

I_EHSDataPeriod is a Basic CDS View (Dimension) that provides data about "EHS Data Period" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field EHSDataPeriod. It has 1 association to related views. Part of development package EHENV_BO_MDEF_IMPL.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EHSDataPeriodText _Text $projection.EHSDataPeriod = _Text.EHSDataPeriod

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IEHSDPERIOD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label EHS Data Period view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name EHSDataPeriod view
ObjectModel.representativeKey EHSDataPeriod view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
Metadata.ignorePropagatedAnnotations true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY EHSDataPeriod
_Text _Text
@AbapCatalog.sqlViewName: 'IEHSDPERIOD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'EHS Data Period'

@VDM.viewType: #BASIC
@Analytics:
{
    dataCategory: #DIMENSION,
    dataExtraction.enabled: true,
    internalName:#LOCAL
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel : { supportedCapabilities: [ #EXTRACTION_DATA_SOURCE, #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET ],
                 modelingPattern: #NONE,
                 sapObjectNodeType.name: 'EHSDataPeriod',
                 representativeKey: 'EHSDataPeriod',
                 usageType: { serviceQuality: #A,
                              sizeCategory: #S,
                              dataClass: #META } }

@Metadata.ignorePropagatedAnnotations:true
define view I_EHSDataPeriod
  as select from dd07l
  association [0..*] to I_EHSDataPeriodText as _Text on $projection.EHSDataPeriod = _Text.EHSDataPeriod
{
      @ObjectModel.text.association: '_Text'
  key cast( dd07l.domvalue_l as ehenv_mdef_period_code_nc ) as EHSDataPeriod,
      // association

      _Text

}
where
      dd07l.domname  = 'EHENV_MDEF_PERIOD_CODE'
  and dd07l.as4local = 'A'