I_STATUSOBJECTSTATUS

CDS View

Status Object Status

I_STATUSOBJECTSTATUS is a CDS View in S/4HANA. Status Object Status. It contains 7 fields. 13 CDS views read from this table.

Used by 13 CDS view(s) 7 fields

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_Materialsamplestatus view inner CONSUMPTION CDS View for Material Sample Statuses
I_MaintObjectPhaseControl view from COMPOSITE Maintenance Object Phase Control Code
I_ManufacturingOrderStatus view_entity inner COMPOSITE Manufacturing Order Status
I_QltyInProcmtActiveStatus view_entity from COMPOSITE Status of Q-Info Record in Procurement
I_StatusObjectActiveStatus view from COMPOSITE Status Object Active Status
P_ChgImpactNtwkOrderStatus view inner COMPOSITE Network Order Status
P_ChgImpactOrderStatus view inner COMPOSITE Production Order Status
P_EngmentProjEmpWrkPckgDets view inner COMPOSITE Engagement Project Employee Work Package Details
P_MfgOrderOperationStatus view_entity inner COMPOSITE Manufacturing Order Operation Status
P_MfgOrderOpStatus view from COMPOSITE Order Operation Status for Manufacturing Orders
P_OrderOperationStatus view_entity inner COMPOSITE Order Operation Status
P_SchedOrderOperationStatus view_entity from COMPOSITE Schedule Production Order Operation Status
P_WrkCtrMntrOrderOperationSts view_entity from COMPOSITE View to calculate last status of an order operation

Fields (7)

KeyField CDS FieldsUsed in Views
KEY StatusCode StatusCode 1
KEY StatusObject StatusObject 1
_StatusCode _StatusCode 1
_StatusObject _StatusObject 2
_StatusProfile _StatusProfile 1
StatusIsInactive StatusIsInactive 1
StatusProfile StatusProfile 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.sqlViewName: 'ISTATUSOBJSTATUS'
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Status Object Status'

@Analytics : { dataExtraction.enabled : true}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #COMPOSITE

define view I_StatusObjectStatus as select from    I_StatusObjectStatusBasic as jest

  left outer to one join I_StatusObject as jsto  on jest.StatusObject = jsto.StatusObject

  association [0..1] to I_StatusCode    as _StatusCode    on  $projection.StatusCode    = _StatusCode.StatusCode
                                                          and $projection.StatusProfile = _StatusCode.StatusProfile
                                                          
  association [0..1] to I_StatusObject  as _StatusObject  on  $projection.StatusObject = _StatusObject.StatusObject

  association [0..1] to I_StatusProfile as _StatusProfile on  $projection.StatusProfile = _StatusProfile.StatusProfile

{
      @ObjectModel.foreignKey.association: '_StatusObject'
  key jest.StatusObject,
  
      @ObjectModel.foreignKey.association: '_StatusCode'
  key StatusCode,
  
      @ObjectModel.foreignKey.association: '_StatusProfile'
      //jsto.stsma as StatusProfile,

      case
        when StatusCode like 'E%' then jsto.StatusProfile
        when StatusCode not like 'E%' then ''
      end        as StatusProfile,

      case
        when StatusCode like 'E%' then 'X'
        when StatusCode not like 'E%' then ' '
      end        as IsUserStatus,

      case StatusIsInactive
        when 'X' then ''
        when ''  then 'X'
      end        as StatusIsActive,

      StatusIsInactive,
      
      _StatusObject,
      _StatusCode,
      _StatusProfile
}

Learn More