I_EAMOverallStatusUsage

DDL: I_EAMOVERALLSTATUSUSAGE SQL: IEAMOSTATUSG Type: view BASIC

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.

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 (9)

NameValueLevelField
AbapCatalog.sqlViewName IEAMOSTATUSG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Overall Status Usage view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE 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 EAMOverallStatusEvent
KEY EAMOvrlStsEventConfiguration EAMOvrlStsEventConfiguration
EAMOvrlStsIsCoveredByEvent 
@AbapCatalog.sqlViewName: 'IEAMOSTATUSG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Overall Status Usage'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #S,
   usageType.dataClass: #CUSTOMIZING
}

define view 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 EAMOverallStatusEvent,
  key 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 EAMOverallStatusEvent = 'F2023'

Learn More