P_MfgOrderOpStatus

DDL: P_MFGORDEROPSTATUS SQL: PMFGORDEROPSTS Type: view COMPOSITE Package: PPH_VDM_CAP_EVAL

Order Operation Status for Manufacturing Orders

P_MfgOrderOpStatus is a Composite CDS View that provides data about "Order Operation Status for Manufacturing Orders" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatus) and exposes 1 field with key field StatusObject. Part of development package PPH_VDM_CAP_EVAL.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatus jest from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMFGORDEROPSTS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject 
@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