C_ProcessOrderObjPgOpr

DDL: C_PROCESSORDEROBJPGOPR Type: view_entity CONSUMPTION
37 Fields 2 Data Sources

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.

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 Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem I_MfgOrderOperationDurn OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ManufacturingOrder I_MfgOrderOperationDurn ManufacturingOrder Order
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 Vehicle Model
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 Act/op UoM
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 Work Center
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProcessOrderObjPgOpr.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_ProcessOrderObjPgOpr AS
SELECT
  ManufacturingOrderOperation.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  ManufacturingOrderOperation.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  ManufacturingOrderOperation.ManufacturingOrder AS ManufacturingOrder,
  cast(ManufacturingOrderOperation.ManufacturingOrderOperation as ck_vornr) AS ManufacturingOrderOperation,
  ManufacturingOrderOperation.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  ManufacturingOrderOperation.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  ManufacturingOrderOperation.MfgOrderOperationText AS MfgOrderOperationText,
  cast(ManufacturingOrderOperation.ManufacturingOrderSubOperation as vornr) AS ManufacturingOrderSubOperation,
  ManufacturingOrderOperation.ManufacturingOrderType AS ManufacturingOrderType,
  ManufacturingOrderOperation.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  ManufacturingOrderOperation.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  OrderItem.Material AS Material,
  cast(OrderItem._Material._Text[1:Language = $session.system_language ].MaterialName as maktx) AS MaterialDescription,
  ManufacturingOrderOperation.WorkCenterTypeCode AS ProductionResourceType,
  ManufacturingOrderOperation._WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  ManufacturingOrderOperation.WorkCenter AS WorkCenter,
  ManufacturingOrderOperation.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  ManufacturingOrderOperation.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  ManufacturingOrderOperation.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  ManufacturingOrderOperation.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  ManufacturingOrderOperation.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  ManufacturingOrderOperation.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  ManufacturingOrderOperation.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  ManufacturingOrderOperation.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  ManufacturingOrderOperation.OperationUnit AS OperationUnit,
  ManufacturingOrderOperation.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  ManufacturingOrderOperation.ErlstSchedldExecDurnInWorkdays AS ErlstSchedldExecDurnInWorkdays,
  ManufacturingOrderOperation.OpActualExecutionDays AS OpActualExecutionDays,
  ManufacturingOrderOperation.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  ManufacturingOrderOperation.WorkCenterInternalID AS ProductionResourceInternalID,
  OrderItem._Material AS _Material,
  ManufacturingOrderOperation._MfgOrderType AS _MfgOrderType,
  ManufacturingOrderOperation._MfgOrderCategory AS _MfgOrderCategory,
  ManufacturingOrderOperation._MfgOrder AS _MfgOrder,
  ManufacturingOrderOperation._MfgOrderSequence AS _MfgOrderSequence,
  ManufacturingOrderOperation._BusinessProcessEntryUnit AS _BusinessProcessEntryUnit,
  ManufacturingOrderOperation._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations
FROM I_MfgOrderOperationDurn AS ManufacturingOrderOperation
INNER JOIN I_OrderItem AS OrderItem ON /* join condition not captured in parsed metadata */
;

Learn More