I_EAMObjectOverallStatus

DDL: I_EAMOBJECTOVERALLSTATUS Type: view_entity BASIC Package: EAM_OVRL_STS

Object Overall Status

I_EAMObjectOverallStatus is a Basic CDS View that provides data about "Object Overall Status" in SAP S/4HANA. It reads from 1 data source (eam_ostobjsts) and exposes 9 fields with key fields StatusObject, EAMOverallObjectStatusProfile. It has 6 associations to related views. Part of development package EAM_OVRL_STS.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
eam_ostobjsts eam_ostobjsts from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_EAMOverallStatusProfile _OverallStatusProfile _OverallStatusProfile.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile
[0..1] I_EAMOverallStatus _OverallStatus _OverallStatus.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile and _OverallStatus.EAMOverallStatus = $projection.EAMOverallObjectStatus --and _OverallStatus.EAMOverallStatusEntity = 'OVG'
[0..1] I_EAMOverallStatusUsage _ConfirmationUsage _ConfirmationUsage.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile and _ConfirmationUsage.EAMOverallStatus = $projection.EAMOverallObjectStatus and _ConfirmationUsage.EAMOverallStatusEvent = 'F2023' and _ConfirmationUsage.EAMOvrlStsEventConfiguration = 'CONF'
[0..1] I_EAMOverallStatusEvent _InProcessUsage _InProcessUsage.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile and _InProcessUsage.EAMOverallStatus = $projection.EAMOverallObjectStatus and _InProcessUsage.EAMOverallStatusEvent = 'F2023' and _InProcessUsage.EAMOvrlStsEventConfiguration = 'INPROC'
[0..1] I_EAMOverallStatusNextPrimary _NextPrimaryStatus _NextPrimaryStatus.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile and _NextPrimaryStatus.EAMOverallStatus = $projection.EAMOverallObjectStatus
[0..*] I_EAMOverallStatusText _OverallStatusText _OverallStatusText.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile and _OverallStatusText.EAMOverallStatus = $projection.EAMOverallObjectStatus

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Object Overall Status view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY StatusObject status_object
KEY EAMOverallObjectStatusProfile overall_status_profile
EAMOverallObjectStatus
_OverallStatusProfile _OverallStatusProfile
_OverallStatus _OverallStatus
_ConfirmationUsage _ConfirmationUsage
_InProcessUsage _InProcessUsage
_NextPrimaryStatus _NextPrimaryStatus
_OverallStatusText _OverallStatusText 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Object Overall Status'
@VDM.viewType: #BASIC
@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #XL,
   usageType.dataClass: #TRANSACTIONAL
}

define view entity I_EAMObjectOverallStatus
  as select from eam_ostobjsts
  association [0..1] to I_EAMOverallStatusProfile     as _OverallStatusProfile on  _OverallStatusProfile.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile
  association [0..1] to I_EAMOverallStatus            as _OverallStatus        on  _OverallStatus.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile
                                                                               and _OverallStatus.EAMOverallStatus        = $projection.EAMOverallObjectStatus
                                                                               --and _OverallStatus.EAMOverallStatusEntity  = 'OVG'
  association [0..1] to I_EAMOverallStatusUsage       as _ConfirmationUsage    on  _ConfirmationUsage.EAMOverallStatusProfile      = $projection.EAMOverallObjectStatusProfile
                                                                               and _ConfirmationUsage.EAMOverallStatus             = $projection.EAMOverallObjectStatus
                                                                               and _ConfirmationUsage.EAMOverallStatusEvent        = 'F2023'
                                                                               and _ConfirmationUsage.EAMOvrlStsEventConfiguration = 'CONF'
  association [0..1] to I_EAMOverallStatusEvent       as _InProcessUsage       on  _InProcessUsage.EAMOverallStatusProfile      = $projection.EAMOverallObjectStatusProfile
                                                                               and _InProcessUsage.EAMOverallStatus             = $projection.EAMOverallObjectStatus
                                                                               and _InProcessUsage.EAMOverallStatusEvent        = 'F2023'
                                                                               and _InProcessUsage.EAMOvrlStsEventConfiguration = 'INPROC'
  association [0..1] to I_EAMOverallStatusNextPrimary as _NextPrimaryStatus    on  _NextPrimaryStatus.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile
                                                                               and _NextPrimaryStatus.EAMOverallStatus        = $projection.EAMOverallObjectStatus
  association [0..*] to I_EAMOverallStatusText        as _OverallStatusText    on  _OverallStatusText.EAMOverallStatusProfile = $projection.EAMOverallObjectStatusProfile
                                                                               and _OverallStatusText.EAMOverallStatus        = $projection.EAMOverallObjectStatus
{
  key status_object                                             as StatusObject,
      @ObjectModel.foreignKey.association: '_OverallStatusProfile'
  key overall_status_profile                                    as EAMOverallObjectStatusProfile,
      @ObjectModel.foreignKey.association: '_OverallStatus'
      @ObjectModel.text.association: '_OverallStatusText'
      cast( overall_status as eam_iwoc_overall_status )         as EAMOverallObjectStatus,

      _OverallStatusProfile,
      _OverallStatus,
      _ConfirmationUsage,
      _InProcessUsage,
      _NextPrimaryStatus,
      _OverallStatusText
}

Learn More