I_EAMOVERALLSTATUS

CDS View

Overall Status

I_EAMOVERALLSTATUS is a CDS View in S/4HANA. Overall Status. It contains 4 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_JobListStatusVH view from CONSUMPTION Job List Status Value Help
C_MalfunctionOvrStatsVH view from CONSUMPTION Overall Status Value Help for Maintenance Job
I_EAMOverallStatusSequence view left_outer COMPOSITE Sequence of Overall Status
I_EAMOverallStatusStdVH view from COMPOSITE Overall Status
I_EAMOverallStatusUsage view inner BASIC Overall Status Usage
I_EAMOverallStatusUsage view left_outer BASIC Overall Status Usage
P_EAMOverallStatusPrevSequence view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY EAMOverallStatus EAMOverallStatus 3
KEY EAMOverallStatusEntity EAMOverallStatusEntity 1
KEY EAMOverallStatusProfile EAMOverallStatusProfile 3
KEY EAMOverallStatusSequence EAMOverallStatusSequence 1
@AbapCatalog.sqlViewName: 'IEAMOSTAT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Overall Status'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #S,
   usageType.dataClass: #CUSTOMIZING,
   representativeKey: 'EAMOverallStatus',
   semanticKey:  [ 'EAMOverallStatusProfile', 'EAMOverallStatus' ]
}

@AbapCatalog.buffering: {
  status: #ACTIVE,
  type: #FULL,
  numberOfKeyFields: 002
}

define view I_EAMOverallStatus
  as select from eam_ostat
  association [0..1] to I_EAMOverallStatusProfile   as _Profile   on  _Profile.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile
  association [0..*] to I_EAMOverallStatusText      as _Text      on  _Text.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile
                                                                  and _Text.EAMOverallStatus        = $projection.EAMOverallStatus
  association [0..*] to I_EAMOverallStatusCondition as _Condition on  _Condition.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile
                                                                  and _Condition.EAMOverallStatus        = $projection.EAMOverallStatus
{
      @ObjectModel.foreignKey.association: '_Profile'
  key overall_status_profile as EAMOverallStatusProfile,
      @ObjectModel.text.association: '_Text'
      @UI.textArrangement: #TEXT_ONLY
  key overall_status         as EAMOverallStatus,

      used_for_entity_type   as EAMOverallStatusEntity,

      is_logged              as EAMOverallStatusIsLogged,
      is_skippable           as EAMOverallStatusCanBeSkipped,
      sequence               as EAMOverallStatusSequence,

      _Text,
      _Profile,
      _Condition
}