I_EAMOverallStatusUsage

DDL: I_EAMOVERALLSTATUSUSAGE Type: view_entity BASIC Package: EAM_OVRL_STS

Overall Status Usage

I_EAMOverallStatusUsage is a Basic CDS View that provides data about "Overall Status Usage" in SAP S/4HANA. It reads from 3 data sources (I_EAMOverallStatus, I_EAMOverallStatus, I_EAMOverallStatusEvent) and exposes 5 fields with key fields EAMOverallStatusProfile, EAMOverallStatus, EAMOverallStatusEvent, EAMOvrlStsEventConfiguration. Part of development package EAM_OVRL_STS.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
I_EAMOverallStatus _OtherStatus left_outer
I_EAMOverallStatus _OverallStatus inner
I_EAMOverallStatusEvent I_EAMOverallStatusEvent from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Overall Status Usage view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EAMOverallStatusProfile I_EAMOverallStatus EAMOverallStatusProfile
KEY EAMOverallStatus I_EAMOverallStatus EAMOverallStatus
KEY EAMOverallStatusEvent I_EAMOverallStatusEvent EAMOverallStatusEvent
KEY EAMOvrlStsEventConfiguration I_EAMOverallStatusEvent EAMOvrlStsEventConfiguration
EAMOvrlStsIsCoveredByEvent 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Overall Status Usage'
@VDM.viewType: #BASIC
@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #S,
   usageType.dataClass: #CUSTOMIZING
}

define view entity I_EAMOverallStatusUsage
  as select from    I_EAMOverallStatusEvent
    inner join      I_EAMOverallStatus as _OverallStatus on  _OverallStatus.EAMOverallStatusProfile = I_EAMOverallStatusEvent.EAMOverallStatusProfile
                                                         and _OverallStatus.EAMOverallStatus        = I_EAMOverallStatusEvent.EAMOverallStatus
    left outer join I_EAMOverallStatus as _OtherStatus   on  _OtherStatus.EAMOverallStatusProfile = I_EAMOverallStatusEvent.EAMOverallStatusProfile
                                                         and _OtherStatus.EAMOverallStatusEntity  = _OverallStatus.EAMOverallStatusEntity
{
  key _OtherStatus.EAMOverallStatusProfile,
  key _OtherStatus.EAMOverallStatus,
  key I_EAMOverallStatusEvent.EAMOverallStatusEvent,
  key I_EAMOverallStatusEvent.EAMOvrlStsEventConfiguration,
  
      cast( case when _OtherStatus.EAMOverallStatusSequence >= _OverallStatus.EAMOverallStatusSequence then 'X' else ' ' end as xfeld ) as EAMOvrlStsIsCoveredByEvent

      //I_EAMOverallStatusEvent.EAMOverallStatus,

      //_OverallStatus.EAMOverallStatusSequence


      /* Associations */
      //_OverallStatus,

      //_OverallStatusProfile

} where I_EAMOverallStatusEvent.EAMOverallStatusEvent = 'F2023'

Learn More