C_MfgOrderObjPgOpr

DDL: C_MFGORDEROBJPGOPR SQL: CMFGORDOBJPAGOPR Type: view CONSUMPTION Package: PP_MFGORDER_UI
38 Fields 2 Data Sources 1 Associations

Manufacturing Order Opr : Object Page

C_MfgOrderObjPgOpr 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 38 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. It has 1 association to related views. Part of development package PP_MFGORDER_UI.

Data Sources (2)

SourceAliasJoin Type
I_MfgOrderOperationDurn ManufacturingOrderOperation from
I_OrderItem OrderItem inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_OrderOperation _Extension OrderInternalBillOfOperations = _Extension.OrderInternalID and OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CMFGORDOBJPAGOPR view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Manufacturing Order Opr : Object Page view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey OrderIntBillOfOperationsItem view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
UI.presentationVariant.sortOrder.by ManufacturingOrderOperation view
UI.presentationVariant.sortOrder.direction #ASC view
UI.headerInfo.typeName Operation view
UI.headerInfo.typeNamePlural Operations view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ManufacturingOrder ManufacturingOrder Order
ManufacturingOrderOperation ManufacturingOrderOperation Activity
MfgOrderOperationIsPhase MfgOrderOperationIsPhase
ManufacturingOrderSequence ManufacturingOrderSequence
MfgOrderSequenceCategoryName
MfgOrderSequenceText _MfgOrderSequence MfgOrderSequenceText
MfgOrderOperationText MfgOrderOperationText
ManufacturingOrderType ManufacturingOrderType
BusinessProcessEntryUnit BusinessProcessEntryUnit
ManufacturingOrderCategory ManufacturingOrderCategory
Material I_OrderItem Material Vehicle Model
MaterialDescription
WorkCenterTypeCode WorkCenterTypeCode Work Center Type Code
WorkCenterTypeName
WorkCenter WorkCenter Work Center
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte Earliest Execution Start Date
OpErlstSchedldExecStrtTme OpErlstSchedldExecStrtTme Earliest Execution Start Time
OpErlstSchedldExecEndDte OpErlstSchedldExecEndDte Earliest Execution End Date
OpErlstSchedldExecEndTme OpErlstSchedldExecEndTme Earliest Execution End Time
OpActualExecutionStartDate OpActualExecutionStartDate Actual Execution Start Date
OpActualExecutionStartTime OpActualExecutionStartTime Actual Execution Start Time
OpActualExecutionEndDate OpActualExecutionEndDate Actual Execution End Date
OpActualExecutionEndTime OpActualExecutionEndTime Actual Execution End Time
OperationUnit OperationUnit Act/op UoM
OpPlannedTotalQuantity OpPlannedTotalQuantity
ErlstSchedldExecDurnInWorkdays ErlstSchedldExecDurnInWorkdays Scheduled Execution Duration
OpActualExecutionDays OpActualExecutionDays Actual Execution Duration
OpTotalConfirmedYieldQty OpTotalConfirmedYieldQty
WorkCenterInternalID WorkCenterInternalID Work Center
_Material _Material
_MfgOrderType _MfgOrderType
_MfgOrderCategory _MfgOrderCategory
_MfgOrder _MfgOrder
_MfgOrderSequence _MfgOrderSequence
_BusinessProcessEntryUnit _BusinessProcessEntryUnit
_OrdInternalBillOfOperations _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_MfgOrderObjPgOpr.
-- 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.
-- SQL view name: CMFGORDOBJPAGOPR

CREATE VIEW C_MfgOrderObjPgOpr AS
SELECT
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem,
  ManufacturingOrder,
  ManufacturingOrderOperation,
  MfgOrderOperationIsPhase,
  ManufacturingOrderSequence,
  _MfgOrderSequence._SequenceCategory._Text[1: Language=$session.system_language].SequenceCategoryName AS MfgOrderSequenceCategoryName,
  _MfgOrderSequence.MfgOrderSequenceText AS MfgOrderSequenceText,
  MfgOrderOperationText,
  ManufacturingOrderType,
  BusinessProcessEntryUnit,
  ManufacturingOrderCategory,
  OrderItem.Material AS Material,
  cast(OrderItem._Material._Text[1:Language = $session.system_language ].MaterialName as maktx) AS MaterialDescription,
  WorkCenterTypeCode,
  _WorkCenterType._Text[1: Language=$session.system_language].WorkCenterTypeName AS WorkCenterTypeName,
  WorkCenter,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecStrtTme,
  OpErlstSchedldExecEndDte,
  OpErlstSchedldExecEndTme,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  OpActualExecutionEndDate,
  OpActualExecutionEndTime,
  OperationUnit,
  OpPlannedTotalQuantity,
  ErlstSchedldExecDurnInWorkdays,
  OpActualExecutionDays,
  OpTotalConfirmedYieldQty,
  WorkCenterInternalID
FROM I_MfgOrderOperationDurn AS ManufacturingOrderOperation
INNER JOIN I_OrderItem AS OrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_OrderOperation AS _Extension ON OrderInternalBillOfOperations = _Extension.OrderInternalID AND OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID  -- association [1..1]
;

Learn More