P_SchedOrderOperationStatus

DDL: P_SCHEDORDEROPERATIONSTATUS Type: view_entity COMPOSITE Package: PPH_VDM_CAP_EVAL

Schedule Production Order Operation Status

P_SchedOrderOperationStatus is a Composite CDS View that provides data about "Schedule Production Order Operation Status" in SAP S/4HANA. It reads from 1 data source (I_StatusObjectStatus) and exposes 2 fields with key fields StatusObject, StatusCode. Part of development package PPH_VDM_CAP_EVAL.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_StatusObjectStatus jest from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED 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 (2)

KeyFieldSource TableSource FieldDescription
KEY StatusObject StatusObject
KEY StatusCode 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_SchedOrderOperationStatus
  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

    
   key max(jest.StatusCode) as StatusCode
}
where StatusIsActive = 'X'
and ( jest.StatusCode = 'I0001'
  or jest.StatusCode = 'I0002'
  or jest.StatusCode = 'I0009'
  or jest.StatusCode = 'I0010' )
  and StatusObject like 'OV%'
group by StatusObject

Learn More