P_T460aGlobalStatus

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Cross-Plant Special Procurement Settings'

@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
define view entity P_T460aGlobalStatus
  as select from t460a
{
  key sobsl      as Sobsl,
      max(beskz) as Beskz,
      max(sobes) as Sobes,
      max(clcor) as Clcor,
      max(dumps) as Dumps,
      max(rewfg) as Rewfg,
      max(dirpr) as Dirpr,
      max(umldb) as Umldb,
      max(mlscr) as Mlscr,
      case when max(beskz) = min(beskz) then 'X'
        else ' '
        end      as BeskzIsConsistent,
      case when max(sobes) = min(sobes) then 'X'
        else ' '
        end      as SobesIsConsistent,
      case when max(clcor) = min(clcor) then 'X'
      else ' '
      end        as ClcorIsConsistent,
      case when max(dumps) = min(dumps) then 'X'
        else ' '
        end      as DumpsIsConsistent,
      case when max(rewfg) = min(rewfg) then 'X'
      else ' '
      end        as RewfgIsConsistent,
      case when max(dirpr) = min(dirpr) then 'X'
        else ' '
        end      as DirprIsConsistent,
      case when max(umldb) = min(umldb) then 'X'
      else ' '
      end        as UmldbIsConsistent,
      case when max(mlscr) = min(mlscr) then 'X'
        else ' '
        end      as MlscrIsConsistent
}
group by
  sobsl
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T460A"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/