I_EAMOverallStatus

DDL: I_EAMOVERALLSTATUS SQL: IEAMOSTAT Type: view BASIC

Overall Status

I_EAMOverallStatus is a Basic CDS View that provides data about "Overall Status" in SAP S/4HANA. It reads from 1 data source (eam_ostat) and exposes 9 fields with key fields EAMOverallStatusProfile, EAMOverallStatus. It has 3 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
eam_ostat eam_ostat from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_EAMOverallStatusProfile _Profile _Profile.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile
[0..*] I_EAMOverallStatusText _Text _Text.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile and _Text.EAMOverallStatus = $projection.EAMOverallStatus
[0..*] I_EAMOverallStatusCondition _Condition _Condition.EAMOverallStatusProfile = $projection.EAMOverallStatusProfile and _Condition.EAMOverallStatus = $projection.EAMOverallStatus

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IEAMOSTAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Overall Status 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
ObjectModel.representativeKey EAMOverallStatus view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 002 view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EAMOverallStatusProfile overall_status_profile
KEY EAMOverallStatus overall_status
EAMOverallStatusEntity used_for_entity_type
EAMOverallStatusIsLogged is_logged
EAMOverallStatusCanBeSkipped is_skippable
EAMOverallStatusSequence sequence
_Text _Text
_Profile _Profile
_Condition _Condition 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EAM_OSTAT"
],
"ASSOCIATED":
[
"I_EAMOVERALLSTATUSCONDITION",
"I_EAMOVERALLSTATUSPROFILE",
"I_EAMOVERALLSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More