I_STATUSOBJECTSTATUSBASIC

CDS View

Status Object Status Basic

I_STATUSOBJECTSTATUSBASIC is a CDS View in S/4HANA. Status Object Status Basic. It contains 4 fields. 44 CDS views read from this table.

Used by 44 CDS view(s) 4 fields

CDS Views using this table (44)

ViewTypeJoinVDMDescription
C_IntOrderOverallUserStatus view_entity from CONSUMPTION Internal order overall user status
C_MaintOrdOpRdyForExec view_entity inner CONSUMPTION Maintenance Order Operation Status
C_Manageoperations view_entity left_outer CONSUMPTION Production Operations
C_OrderOperationSchedule view_entity left_outer CONSUMPTION Order Operation Schedule
C_ShopFloorOrderGenealogy view inner CONSUMPTION Shop Floor Order Genealogy
I_InspectionOperationStatus view left_outer BASIC Inspection Operation Status
I_IntOrderActiveSystemStatus view_entity from COMPOSITE Internal Order Active System Status
I_IntOrderActiveUserStatus view_entity from COMPOSITE Internal Order Active User Status
I_MaintenanceObjectStatus view_entity from BASIC Maintenance Object Status
I_MajorAssemblyProjectStatus view left_outer COMPOSITE To get Project Status Description
I_RFM_MfgOrderStatusObject view from BASIC Manufacturing Order Status Object
I_RSHMaintSchedExistingOp view left_outer COMPOSITE Existing Operations not part of Schedule
I_RSHOrderMaterialStatus view from COMPOSITE Order Material Status
I_StatusObjectStatus view from COMPOSITE Status Object Status
N_StatusObjectStatus view from Status Object Status
P_APIOrderStatus view_entity inner COMPOSITE Production Order Status
P_CoEvtBsdOrderMaxKeyStatus view from COMPOSITE Event Based Order Key Max Status
P_EBPCC_MaxKeyStatus view_entity from COMPOSITE Event-Based PCC Max Key Status
P_EBPCC_OrderActiveStatus view from COMPOSITE EBPCC - Order Active Status
P_EBPCC_OrderKeyStatus view from COMPOSITE EBPCC - Order Key Status
P_OrderIsShopFloorStatusBasic view_entity from COMPOSITE Order Status Basic
P_OrderItemStatusBasic view_entity from COMPOSITE Order Item Status Basic
P_OrderOpCompStatusBasic view_entity from COMPOSITE Order Operation Component Status
P_OrderOperationStatusBasic view_entity from COMPOSITE Main System Status of Order Operation
P_OrderOpPRTStatusBasic view_entity from COMPOSITE Order Operation PRT Status
P_OrderStatusBasic view_entity from COMPOSITE Order Status Basic
P_OrdFirstOper view_entity left_outer CONSUMPTION Order First Operation Details
P_Ordlatestoper view_entity left_outer CONSUMPTION Order Latest Operation Details
P_RealTimeMfgOrderStatus view from COMPOSITE CO PCC Object Max Status
P_RealTimeMfgReleasedOrder view from COMPOSITE CO PCC Object Max Status
P_RealTimeOrderKeyStatus view from COMPOSITE Real-Time Order Key Status
P_RealTimeOrderKeyStatus view union_all COMPOSITE Real-Time Order Key Status
P_RSHExOpsForScheduling view left_outer CONSUMPTION In process and Dispatched operations for scheduling
P_RSHExOpsForScheduling view inner CONSUMPTION In process and Dispatched operations for scheduling
P_RSHMaintSchedAddlDispOp view inner CONSUMPTION Additional dispatched operations in frozen schedule
P_RSHMaintSchedOperations view left_outer CONSUMPTION Operations from frozen schedule
P_RSHMaintSchedSmltdDueStatus view left_outer CONSUMPTION Processing Status
P_RSHOperationsForKPI view inner CONSUMPTION Operations and Sub Operations for overview page
P_RSHOperationsForKPI view left_outer CONSUMPTION Operations and Sub Operations for overview page
P_RTWIP_OrderMaxStatus view from COMPOSITE Real-Time WIP Reporting - Order Header Max Status
P_ShopFloorOrderInformation view inner CONSUMPTION Shop Floor Order Header Data
P_WhereUsdPrftCtrSystemStatus view from CONSUMPTION Object System Status WUL Profit Centers
P_WhereUsdPrftCtrUsrStatBasic view from CONSUMPTION Object User Status WUL Profit Centers
R_IntOrdOverallSystemStatusTP view_entity from TRANSACTIONAL Overall system status

Fields (4)

KeyField CDS FieldsUsed in Views
KEY StatusCode StatusCode 9
KEY StatusObject ObjectInternalID,StatusObject 14
_StatusObject _StatusObject 1
StatusIsInactive StatusIsInactive 6 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'ISTSOBJSTSBASIC'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey:true


@EndUserText.label: 'Status Object Status Basic'
@Analytics : { dataExtraction.enabled : true}
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@VDM.viewType: #BASIC

@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL

define view I_StatusObjectStatusBasic as select from jest

//left outer join jsto on jest.objnr = jsto.objnr


//  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.objnr as StatusObject,
  
//      @ObjectModel.foreignKey.association: '_StatusCode'

  key jest.stat  as StatusCode,
  
//      @ObjectModel.foreignKey.association: '_StatusProfile'

//      //jsto.stsma as StatusProfile,

//      case

//        when jest.stat like 'E%' then jsto.stsma

//        when jest.stat not like 'E%' then ''

//      end        as StatusProfile,

//

//      case

//        when jest.stat like 'E%' then 'X'

//        when jest.stat not like 'E%' then ' '

//      end        as IsUserStatus,


//      case jest.inact

//        when 'X' then ''

//        when ''  then 'X'

//      end        as StatusIsActive,


      jest.inact as StatusIsInactive,
      
      _StatusObject
//      ,

//      _StatusCode,

//      _StatusProfile

}

Learn More