I_MfgOrderWrkcntrOper

DDL: I_MFGORDERWRKCNTROPER Type: view_entity COMPOSITE Package: ODATA_MPE_MFGORDER
45 Fields 1 Data Sources

Workcenter Manufacturing Order Operations

I_MfgOrderWrkcntrOper is a Composite CDS View (Dimension) that provides data about "Workcenter Manufacturing Order Operations" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationDurn) and exposes 45 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. Part of development package ODATA_MPE_MFGORDER.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationDurn ManufacturingOrderOperation from

Annotations (11)

NameValueLevelField
Analytics.technicalName IMFGOROBJPGWCOPR view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workcenter Manufacturing Order Operations view
VDM.viewType #COMPOSITE view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.representativeKey OrderIntBillOfOperationsItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (45)

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
ManufacturingOrderSequence I_MfgOrderOperationDurn ManufacturingOrderSequence
ManufacturingOrderOperation I_MfgOrderOperationDurn ManufacturingOrderOperation Activity
ManufacturingOrderSubOperation I_MfgOrderOperationDurn ManufacturingOrderSubOperation
ManufacturingOrderType I_MfgOrderOperationDurn ManufacturingOrderType
ProductionPlant I_MfgOrderOperationDurn ProductionPlant Prod plnt
BusinessProcessEntryUnit I_MfgOrderOperationDurn BusinessProcessEntryUnit
ManufacturingOrderCategory I_MfgOrderOperationDurn ManufacturingOrderCategory
Material
WorkCenter I_MfgOrderOperationDurn WorkCenter Work Center
MfgOrderOperationText I_MfgOrderOperationDurn MfgOrderOperationText
OpErlstSchedldExecStrtDte I_MfgOrderOperationDurn OpErlstSchedldExecStrtDte Earl.start date
OpErlstSchedldExecStrtTme I_MfgOrderOperationDurn OpErlstSchedldExecStrtTme
OpErlstSchedldExecEndDte I_MfgOrderOperationDurn OpErlstSchedldExecEndDte EarliestEndDate
OpErlstSchedldExecEndTme I_MfgOrderOperationDurn OpErlstSchedldExecEndTme
OpActualExecutionStartDate I_MfgOrderOperationDurn OpActualExecutionStartDate Execution Start Date
OpActualExecutionStartTime I_MfgOrderOperationDurn OpActualExecutionStartTime
OpActualExecutionEndDate I_MfgOrderOperationDurn OpActualExecutionEndDate Execution End Date
OpActualExecutionEndTime I_MfgOrderOperationDurn OpActualExecutionEndTime
OperationUnit I_MfgOrderOperationDurn OperationUnit Act/op UoM
OpPlannedTotalQuantity I_MfgOrderOperationDurn OpPlannedTotalQuantity
ErlstSchedldExecDurnInWorkdays I_MfgOrderOperationDurn ErlstSchedldExecDurnInWorkdays
OpActualExecutionDays I_MfgOrderOperationDurn OpActualExecutionDays
OpTotalConfirmedYieldQty I_MfgOrderOperationDurn OpTotalConfirmedYieldQty
WorkCenterInternalID I_MfgOrderOperationDurn WorkCenterInternalID Work Center
OperationIsReleased I_MfgOrderOperationDurn OperationIsReleased
OperationIsCreated I_MfgOrderOperationDurn OperationIsCreated
WorkCenterTypeCode I_MfgOrderOperationDurn WorkCenterTypeCode_2
MfgOrderOperationIsPhase I_MfgOrderOperationDurn MfgOrderOperationIsPhase
OperationIsPartiallyConfirmed I_MfgOrderOperationDurn OperationIsPartiallyConfirmed
OperationIsConfirmed I_MfgOrderOperationDurn OperationIsConfirmed
ManufacturingObject
_Material
_WorkCenter I_MfgOrderOperationDurn _WorkCenter_2
_WorkCenterType I_MfgOrderOperationDurn _WorkCenterType_2
_MfgOrderType I_MfgOrderOperationDurn _MfgOrderType
_MfgOrderCategory I_MfgOrderOperationDurn _MfgOrderCategory
_MfgOrder I_MfgOrderOperationDurn _MfgOrder
_MfgOrderSequence I_MfgOrderOperationDurn _MfgOrderSequence
_BusinessProcessEntryUnit I_MfgOrderOperationDurn _BusinessProcessEntryUnit
_OrdInternalBillOfOperations I_MfgOrderOperationDurn _OrdInternalBillOfOperations
_WorkCenterBySemanticKey I_MfgOrderOperationDurn _WorkCenterBySemanticKey
_ProductionPlant I_MfgOrderOperationDurn _ProductionPlant

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 I_MfgOrderWrkcntrOper.
-- 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 I_MfgOrderWrkcntrOper AS
SELECT
  ManufacturingOrderOperation.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  ManufacturingOrderOperation.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  ManufacturingOrderOperation.ManufacturingOrder AS ManufacturingOrder,
  ManufacturingOrderOperation.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  ManufacturingOrderOperation.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  ManufacturingOrderOperation.ManufacturingOrderSubOperation AS ManufacturingOrderSubOperation,
  ManufacturingOrderOperation.ManufacturingOrderType AS ManufacturingOrderType,
  ManufacturingOrderOperation.ProductionPlant AS ProductionPlant,
  ManufacturingOrderOperation.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  ManufacturingOrderOperation.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ManufacturingOrderOperation._MfgOrder.Material AS Material,
  ManufacturingOrderOperation.WorkCenter AS WorkCenter,
  ManufacturingOrderOperation.MfgOrderOperationText AS MfgOrderOperationText,
  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 WorkCenterInternalID,
  ManufacturingOrderOperation.OperationIsReleased AS OperationIsReleased,
  ManufacturingOrderOperation.OperationIsCreated AS OperationIsCreated,
  ManufacturingOrderOperation.WorkCenterTypeCode_2 AS WorkCenterTypeCode,
  ManufacturingOrderOperation.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  ManufacturingOrderOperation.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
  ManufacturingOrderOperation.OperationIsConfirmed AS OperationIsConfirmed,
  ManufacturingOrderOperation._MfgOrder.ManufacturingObject AS ManufacturingObject,
  ManufacturingOrderOperation._MfgOrder._Material AS _Material,
  ManufacturingOrderOperation._WorkCenter_2 AS _WorkCenter,
  ManufacturingOrderOperation._WorkCenterType_2 AS _WorkCenterType,
  ManufacturingOrderOperation._MfgOrderType AS _MfgOrderType,
  ManufacturingOrderOperation._MfgOrderCategory AS _MfgOrderCategory,
  ManufacturingOrderOperation._MfgOrder AS _MfgOrder,
  ManufacturingOrderOperation._MfgOrderSequence AS _MfgOrderSequence,
  ManufacturingOrderOperation._BusinessProcessEntryUnit AS _BusinessProcessEntryUnit,
  ManufacturingOrderOperation._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  ManufacturingOrderOperation._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  ManufacturingOrderOperation._ProductionPlant AS _ProductionPlant
FROM I_MfgOrderOperationDurn AS ManufacturingOrderOperation
;

Learn More