I_EAMOverallStatusEvent

DDL: I_EAMOVERALLSTATUSEVENT SQL: IEAMOSTATEVT Type: view BASIC

Overall Status Event

I_EAMOverallStatusEvent is a Basic CDS View that provides data about "Overall Status Event" in SAP S/4HANA. It reads from 1 data source (eam_ostatevt) and exposes 6 fields with key fields EAMOverallStatusProfile, EAMOverallStatus, EAMOverallStatusEvent, EAMOvrlStsEventConfiguration. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
eam_ostatevt eam_ostatevt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EAMOverallStatusProfile _OverallStatusProfile _OverallStatusProfile.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile
[0..1] I_EAMOverallStatus _OverallStatus _OverallStatus.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile and _OverallStatus.EAMOverallStatus = $projection.EAMOverallStatus

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEAMOSTATEVT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Overall Status Event 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 (6)

KeyFieldSource TableSource FieldDescription
KEY EAMOverallStatusProfile overall_status_profile
KEY EAMOverallStatus overall_status
KEY EAMOverallStatusEvent overall_status_event
KEY EAMOvrlStsEventConfiguration overall_status_event_config
_OverallStatusProfile _OverallStatusProfile
_OverallStatus _OverallStatus
@AbapCatalog.sqlViewName: 'IEAMOSTATEVT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Overall Status Event'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view I_EAMOverallStatusEvent
  as select from eam_ostatevt
  association [0..1] to I_EAMOverallStatusProfile as _OverallStatusProfile on  _OverallStatusProfile.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile
  association [0..1] to I_EAMOverallStatus        as _OverallStatus        on  _OverallStatus.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile
                                                                           and _OverallStatus.EAMOverallStatus        = $projection.EAMOverallStatus
{
      @ObjectModel.foreignKey.association: '_OverallStatusProfile'
  key overall_status_profile      as EAMOverallStatusProfile,
      @ObjectModel.foreignKey.association: '_OverallStatus'
  key overall_status              as EAMOverallStatus,
  key overall_status_event        as EAMOverallStatusEvent,
  key overall_status_event_config as EAMOvrlStsEventConfiguration,

      _OverallStatusProfile,
      _OverallStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EAM_OSTATEVT"
],
"ASSOCIATED":
[
"I_EAMOVERALLSTATUS",
"I_EAMOVERALLSTATUSPROFILE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/