I_EAMOverallStatusCondition

DDL: I_EAMOVERALLSTATUSCONDITION SQL: IEAMOSTATCOND Type: view BASIC

Overall Status Condition

I_EAMOverallStatusCondition is a Basic CDS View that provides data about "Overall Status Condition" in SAP S/4HANA. It reads from 1 data source (eam_ostatcond) and exposes 12 fields with key fields EAMOverallStatusProfile, EAMOverallStatus, EAMOverallStatusConditionGroup, EAMOverallStatusConditionCntr. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
eam_ostatcond eam_ostatcond 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 (12)

NameValueLevelField
AbapCatalog.sqlViewName IEAMOSTATCOND view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Overall Status Condition 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
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 004 view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY EAMOverallStatusProfile overall_status_profile
KEY EAMOverallStatus overall_status
KEY EAMOverallStatusConditionGroup overall_status_condition_group
KEY EAMOverallStatusConditionCntr overall_status_condition_count
EAMOverallStatusCndnEntity entity_type
EAMOvrlStsCndnEntityQualifier entity_qualifier
EAMOverallStatusCndnStatusPrfl entity_status_profile
EAMOverallStatusCndnStatusCode entity_status
EAMOverallStatusCndnQualifier qualifier
EAMOverallStatusCndnQuantifier quantifier
_OverallStatusProfile _OverallStatusProfile
_OverallStatus _OverallStatus 
@AbapCatalog.sqlViewName: 'IEAMOSTATCOND'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Overall Status Condition'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

define view I_EAMOverallStatusCondition
  as select from eam_ostatcond
  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_condition_group as EAMOverallStatusConditionGroup,
  key overall_status_condition_count as EAMOverallStatusConditionCntr,

      entity_type                    as EAMOverallStatusCndnEntity,
      entity_qualifier               as EAMOvrlStsCndnEntityQualifier,
      entity_status_profile          as EAMOverallStatusCndnStatusPrfl,
      entity_status                  as EAMOverallStatusCndnStatusCode,


      qualifier                      as EAMOverallStatusCndnQualifier,
      quantifier                     as EAMOverallStatusCndnQuantifier,

      _OverallStatusProfile,
      _OverallStatus
}

Learn More