C_ProcessOrderObjPgOpr

DDL: C_PROCESSORDEROBJPGOPR Type: view_entity CONSUMPTION Package: PP_MFGORDER_UI

Manufacturing Order Opr : Object Page

C_ProcessOrderObjPgOpr is a Consumption CDS View that provides data about "Manufacturing Order Opr : Object Page" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrderOperationDurn, I_OrderItem) and exposes 37 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. Part of development package PP_MFGORDER_UI.

2 data source(s) 37 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgOrderOperationDurn ManufacturingOrderOperation from
I_OrderItem OrderItem inner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manufacturing Order Opr : Object Page view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey OrderIntBillOfOperationsItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Operation view
UI.headerInfo.typeNamePlural Operations view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations I_MfgOrderOperationDurn OrderInternalBillOfOperations
KEY OrderIntBillOfOperationsItem I_MfgOrderOperationDurn OrderIntBillOfOperationsItem
ManufacturingOrder I_MfgOrderOperationDurn ManufacturingOrder
ManufacturingOrderOperation
MfgOrderOperationIsPhase I_MfgOrderOperationDurn MfgOrderOperationIsPhase Phase
ManufacturingOrderSequence I_MfgOrderOperationDurn ManufacturingOrderSequence
MfgOrderOperationText I_MfgOrderOperationDurn MfgOrderOperationText
ManufacturingOrderSubOperation Suboperation
ManufacturingOrderType I_MfgOrderOperationDurn ManufacturingOrderType
BusinessProcessEntryUnit I_MfgOrderOperationDurn BusinessProcessEntryUnit
ManufacturingOrderCategory I_MfgOrderOperationDurn ManufacturingOrderCategory
Material I_OrderItem Material
MaterialDescription
ProductionResourceType I_MfgOrderOperationDurn WorkCenterTypeCode Resource Type Code
WorkCenterText
WorkCenter I_MfgOrderOperationDurn WorkCenter Resource
OpErlstSchedldExecStrtDte I_MfgOrderOperationDurn OpErlstSchedldExecStrtDte Earliest Execution Start Date
OpErlstSchedldExecStrtTme I_MfgOrderOperationDurn OpErlstSchedldExecStrtTme Earliest Execution Start Time
OpErlstSchedldExecEndDte I_MfgOrderOperationDurn OpErlstSchedldExecEndDte Earliest Execution End Date
OpErlstSchedldExecEndTme I_MfgOrderOperationDurn OpErlstSchedldExecEndTme Earliest Execution End Time
OpActualExecutionStartDate I_MfgOrderOperationDurn OpActualExecutionStartDate Actual Execution Start Date
OpActualExecutionStartTime I_MfgOrderOperationDurn OpActualExecutionStartTime Actual Execution Start Time
OpActualExecutionEndDate I_MfgOrderOperationDurn OpActualExecutionEndDate Actual Execution End Date
OpActualExecutionEndTime I_MfgOrderOperationDurn OpActualExecutionEndTime Actual Execution End Time
OperationUnit I_MfgOrderOperationDurn OperationUnit
OpPlannedTotalQuantity I_MfgOrderOperationDurn OpPlannedTotalQuantity
ErlstSchedldExecDurnInWorkdays I_MfgOrderOperationDurn ErlstSchedldExecDurnInWorkdays Scheduled Execution Duration
OpActualExecutionDays I_MfgOrderOperationDurn OpActualExecutionDays Actual Execution Duration
OpTotalConfirmedYieldQty I_MfgOrderOperationDurn OpTotalConfirmedYieldQty
ProductionResourceInternalID I_MfgOrderOperationDurn WorkCenterInternalID
_Material I_OrderItem _Material
_MfgOrderType I_MfgOrderOperationDurn _MfgOrderType
_MfgOrderCategory I_MfgOrderOperationDurn _MfgOrderCategory
_MfgOrder I_MfgOrderOperationDurn _MfgOrder
_MfgOrderSequence I_MfgOrderOperationDurn _MfgOrderSequence
_BusinessProcessEntryUnit I_MfgOrderOperationDurn _BusinessProcessEntryUnit
_OrdInternalBillOfOperations I_MfgOrderOperationDurn _OrdInternalBillOfOperations 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Manufacturing Order Opr : Object Page'

@VDM.viewType: #CONSUMPTION

@ObjectModel.representativeKey: 'OrderIntBillOfOperationsItem'
@ObjectModel.semanticKey: ['ManufacturingOrder' , 'ManufacturingOrderSequence' , 'ManufacturingOrderOperation' , 'ManufacturingOrderSubOperation']
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@UI.presentationVariant: [{sortOrder: [{by: 'ManufacturingOrderOperation', direction: #ASC}]}, {requestAtLeast: [ 'ProductionResourceInternalID' ]}]
@UI.headerInfo.typeName: 'Operation'
@UI.headerInfo.typeNamePlural: 'Operations'
define view entity C_ProcessOrderObjPgOpr
  as select from I_MfgOrderOperationDurn as ManufacturingOrderOperation
    inner join   I_OrderItem             as OrderItem on  OrderItem.OrderID   = ManufacturingOrderOperation.ManufacturingOrder
                                                      and OrderItem.OrderItem = '0001'                                               
{
       // Technical Key

       @UI.hidden: true
       @ObjectModel.foreignKey.association: '_OrdInternalBillOfOperations'
  key  ManufacturingOrderOperation.OrderInternalBillOfOperations,
       @UI.hidden: true
  key  ManufacturingOrderOperation.OrderIntBillOfOperationsItem,
       @UI.hidden: true
       // Semantical Key

       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderStdVH', element: 'ManufacturingOrder' } } ]
       ManufacturingOrderOperation.ManufacturingOrder,
       @UI.lineItem: [{position:10}]
       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderOperationVH', element: 'ManufacturingOrderOperation' } } ]
       cast(ManufacturingOrderOperation.ManufacturingOrderOperation as ck_vornr)                                                       as  ManufacturingOrderOperation,
       //ltrim(ManufacturingOrderOperation,'0')                                                      as  ManufacturingOrderOperation,

       @UI.lineItem: [{position:20}]
       @EndUserText.label:'Phase'
       ManufacturingOrderOperation.MfgOrderOperationIsPhase,
       @UI.hidden: true
       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderSequenceStdVH', element: 'ManufacturingOrderSequence' } } ]
       ManufacturingOrderOperation.ManufacturingOrderSequence, // Sequence,

       @UI.lineItem: [{position:30}]
       ManufacturingOrderOperation.MfgOrderOperationText, // OperationShortText

       @EndUserText.label:'Suboperation'
       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderOperationVH', element: 'ManufacturingOrderSubOperation' } } ]
       cast(ManufacturingOrderOperation.ManufacturingOrderSubOperation as vornr)                                                       as  ManufacturingOrderSubOperation, // Operation,

       @ObjectModel.foreignKey.association: '_MfgOrderType'
       @UI.hidden
       ManufacturingOrderOperation.ManufacturingOrderType,
       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_UnitOfMeasureStdVH', element: 'UnitOfMeasure' } } ]
       ManufacturingOrderOperation.BusinessProcessEntryUnit,
       // Order header data

       @ObjectModel.foreignKey.association: '_MfgOrderCategory'
       @UI.hidden
       ManufacturingOrderOperation.ManufacturingOrderCategory,
       @UI.lineItem: [{position:40}]
       @ObjectModel.foreignKey.association: '_Material'
       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialStdVH', element: 'Material' } } ]
       OrderItem.Material,
       @UI.lineItem: [{position:45}]
       cast(OrderItem._Material._Text[1:Language = $session.system_language ].MaterialName as maktx) as MaterialDescription, //MaterialDescription

       @EndUserText.label:'Resource Type Code'
       @ObjectModel.text.element: ['WorkCenterText']
       ManufacturingOrderOperation.WorkCenterTypeCode                                                                                  as  ProductionResourceType,
       @UI.hidden: true
       ManufacturingOrderOperation._WorkCenter._Text[1: Language=$session.system_language].WorkCenterText                              as  WorkCenterText,
       @Consumption.semanticObject: 'Resource'
       @UI.lineItem: [{ position: 50}]
       @EndUserText.label:'Resource'
       @UI.identification: [{type: #WITH_INTENT_BASED_NAVIGATION,dataAction: 'display'}]
       @Consumption.valueHelpDefinition: [{ entity: { name: 'I_WorkCenterVH', element: 'WorkCenter'} }] 
       ManufacturingOrderOperation.WorkCenter,                     // WorkCenter,


       @Semantics.calendarItem.dtStart: true
       @UI.lineItem: [{position:60}]
       @EndUserText.label:'Earliest Execution Start Date'
       ManufacturingOrderOperation.OpErlstSchedldExecStrtDte,      // PlannedStartDate

       @UI.lineItem: [{position:70}]
       @EndUserText.label:'Earliest Execution Start Time'
       ManufacturingOrderOperation.OpErlstSchedldExecStrtTme,      // PlannedStartTime

       @Semantics.calendarItem.dtStart: true
       @UI.lineItem: [{position:80}]
       @EndUserText.label:'Earliest Execution End Date'
       ManufacturingOrderOperation.OpErlstSchedldExecEndDte,       // PlannedEndDate

       @UI.lineItem: [{position:90}]
       @EndUserText.label:'Earliest Execution End Time'
       ManufacturingOrderOperation.OpErlstSchedldExecEndTme,       // PlannedEndTime

       @Semantics.calendarItem.dtStart: true
       @EndUserText.label:'Actual Execution Start Date'
       ManufacturingOrderOperation.OpActualExecutionStartDate,     // StartDate,

       @EndUserText.label:'Actual Execution Start Time'
       ManufacturingOrderOperation.OpActualExecutionStartTime,     // StartTime,

       @Semantics.calendarItem.dtEnd: true
       @EndUserText.label:'Actual Execution End Date'
       ManufacturingOrderOperation.OpActualExecutionEndDate,       // EndDate,

       @EndUserText.label:'Actual Execution End Time'
       ManufacturingOrderOperation.OpActualExecutionEndTime,       // EndTime,

       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_UnitOfMeasureStdVH', element: 'UnitOfMeasure' } } ]
       ManufacturingOrderOperation.OperationUnit,                  // OperationUnit,

       @Semantics.quantity.unitOfMeasure: 'OperationUnit'
       //@DefaultAggregation: #NONE

       ManufacturingOrderOperation.OpPlannedTotalQuantity,         // OperationQuantity,

       @Semantics.calendarItem.duration: true
       @EndUserText.label:'Scheduled Execution Duration'
       ManufacturingOrderOperation.ErlstSchedldExecDurnInWorkdays, // PlannedDuration,

       @Semantics.calendarItem.duration: true
       @EndUserText.label:'Actual Execution Duration'
       ManufacturingOrderOperation.OpActualExecutionDays                                                                               as  OpActualExecutionDays, // ActualDuration,

       ManufacturingOrderOperation.OpTotalConfirmedYieldQty, // Confirmed Quantity

       @UI.hidden: true
       ManufacturingOrderOperation.WorkCenterInternalID                                                                                as  ProductionResourceInternalID,

       OrderItem._Material,
       ManufacturingOrderOperation._MfgOrderType,
       ManufacturingOrderOperation._MfgOrderCategory,
       ManufacturingOrderOperation._MfgOrder,
       ManufacturingOrderOperation._MfgOrderSequence,
       ManufacturingOrderOperation._BusinessProcessEntryUnit,
       ManufacturingOrderOperation._OrdInternalBillOfOperations

};

Learn More