P_MFGORDEROPSTATUS

CDS View

Order Operation Status for Manufacturing Orders

P_MFGORDEROPSTATUS is a CDS View in S/4HANA. Order Operation Status for Manufacturing Orders. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_WorkCenterCapPplineOp view left_outer COMPOSITE Load day opr for manufacturing and planned order for Cap
P_WORKCENTERCAPREQS view left_outer COMPOSITE Load day opr for manufacturing and planned order for Cap 
@AbapCatalog.sqlViewName: 'PMFGORDEROPSTS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_MfgOrderOpStatus

  as select from I_StatusObjectStatus as jest
{
  key StatusObject,

  key max(case jest.StatusCode
      when 'I0001' then 10
      when 'I0002' then 20
      when 'I0009' then 30
      when 'I0010' then 40
      end) as StatusCode

}
where
       StatusIsInactive = ''
//  and(

//       jest.StatusCode = 'I0001'

//    or jest.StatusCode = 'I0002'

//    or jest.StatusCode = 'I0009'

//    or jest.StatusCode = 'I0010'

//  )

  
group by
  StatusObject

//  as select from I_OrderOperationBasic     as afvc

//

//    inner join   I_StatusObjectStatusBasic as jest on  jest.StatusObject     = afvc.ObjectInternalID

//                                                   and jest.StatusIsInactive = ''

//

//{

//      // Technical Key

//  key afvc.OrderInternalID,

//  key afvc.OrderOperationInternalID,

//

//      // Status

//

//      afvc.ObjectInternalID,

//      max(case jest.StatusCode

//        when 'I0001' then 10

//        when 'I0002' then 20

//        when 'I0009' then 30

//        when 'I0010' then 40

//      end) as StatusCode

//

//

//}

//

////where

////     jest.StatusCode = 'I0001'

////  or jest.StatusCode = 'I0002'

////  or jest.StatusCode = 'I0009'

////  or jest.StatusCode = 'I0010'

//

//group by

//  OrderInternalID,

//  OrderOperationInternalID,

//  ObjectInternalID;

Learn More