P_MfgOrderWrkCntrOper

DDL: P_MFGORDERWRKCNTROPER SQL: PMFGORDERWRKOP Type: view COMPOSITE
48 Fields 1 Data Sources

Workcenter Manufacturing Order Operations

P_MfgOrderWrkCntrOper is a Composite CDS View that provides data about "Workcenter Manufacturing Order Operations" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationDelay) and exposes 48 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationDelay MfgOrderOper from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PMFGORDERWRKOP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Workcenter Manufacturing Order Operations view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.representativeKey OrderIntBillOfOperationsItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations I_MfgOrderOperationDelay OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem I_MfgOrderOperationDelay OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ManufacturingOrder I_MfgOrderOperationDelay ManufacturingOrder Order
ManufacturingOrderSequence I_MfgOrderOperationDelay ManufacturingOrderSequence
ManufacturingOrderOperation I_MfgOrderOperationDelay ManufacturingOrderOperation Activity
ManufacturingOrderSubOperation I_MfgOrderOperationDelay ManufacturingOrderSubOperation
ManufacturingOrderType I_MfgOrderOperationDelay ManufacturingOrderType
ProductionPlant I_MfgOrderOperationDelay ProductionPlant Prod plnt
BusinessProcessEntryUnit I_MfgOrderOperationDelay BusinessProcessEntryUnit
ManufacturingOrderCategory I_MfgOrderOperationDelay ManufacturingOrderCategory
Material
WorkCenter I_MfgOrderOperationDelay WorkCenter Work Center
MfgOrderOperationText I_MfgOrderOperationDelay MfgOrderOperationText
OpErlstSchedldExecStrtDte I_MfgOrderOperationDelay OpErlstSchedldExecStrtDte Earl.start date
OpErlstSchedldExecStrtTme I_MfgOrderOperationDelay OpErlstSchedldExecStrtTme
OpErlstSchedldExecEndDte I_MfgOrderOperationDelay OpErlstSchedldExecEndDte EarliestEndDate
OpErlstSchedldExecEndTme I_MfgOrderOperationDelay OpErlstSchedldExecEndTme
OpActualExecutionStartDate I_MfgOrderOperationDelay OpActualExecutionStartDate Execution Start Date
OpActualExecutionStartTime I_MfgOrderOperationDelay OpActualExecutionStartTime
OpActualExecutionEndDate I_MfgOrderOperationDelay OpActualExecutionEndDate Execution End Date
OpActualExecutionEndTime I_MfgOrderOperationDelay OpActualExecutionEndTime
OperationUnit I_MfgOrderOperationDelay OperationUnit Act/op UoM
OpPlannedTotalQuantity I_MfgOrderOperationDelay OpPlannedTotalQuantity
ErlstSchedldExecDurnInWorkdays durn ErlstSchedldExecDurnInWorkdays
OpActualExecutionDays durn actualexecutiondurninworkdays
OpTotalConfirmedYieldQty I_MfgOrderOperationDelay OpTotalConfirmedYieldQty
WorkCenterInternalID I_MfgOrderOperationDelay WorkCenterInternalID Work Center
OperationIsCreated I_MfgOrderOperationDelay OperationIsCreated
OperationIsReleased I_MfgOrderOperationDelay OperationIsReleased
WorkCenterTypeCode I_MfgOrderOperationDelay WorkCenterTypeCode_2
MfgOrderOperationIsPhase I_MfgOrderOperationDelay MfgOrderOperationIsPhase
OperationIsPartiallyConfirmed I_MfgOrderOperationDelay OperationIsPartiallyConfirmed
OperationIsConfirmed I_MfgOrderOperationDelay OperationIsConfirmed
WorkCenterTypeCode_2 I_MfgOrderOperationDelay WorkCenterTypeCode_2
ManufacturingObject
OpLtstSchedldExecStrtDte I_MfgOrderOperationDelay OpLtstSchedldExecStrtDte Latest start
OpLtstSchedldExecEndDte I_MfgOrderOperationDelay OpLtstSchedldExecEndDte Lat.finish date
_Material
_WorkCenter I_MfgOrderOperationDelay _WorkCenter_2
_WorkCenterType I_MfgOrderOperationDelay _WorkCenterType_2
_MfgOrderType I_MfgOrderOperationDelay _MfgOrderType
_MfgOrderCategory I_MfgOrderOperationDelay _MfgOrderCategory
_MfgOrder I_MfgOrderOperationDelay _MfgOrder
_MfgOrderSequence I_MfgOrderOperationDelay _MfgOrderSequence
_BusinessProcessEntryUnit I_MfgOrderOperationDelay _BusinessProcessEntryUnit
_OrdInternalBillOfOperations I_MfgOrderOperationDelay _OrdInternalBillOfOperations
_WorkCenterBySemanticKey I_MfgOrderOperationDelay _WorkCenterBySemanticKey
_ProductionPlant I_MfgOrderOperationDelay _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 P_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.
-- SQL view name: PMFGORDERWRKOP

CREATE VIEW P_MfgOrderWrkCntrOper AS
SELECT
  MfgOrderOper.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  MfgOrderOper.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  MfgOrderOper.ManufacturingOrder AS ManufacturingOrder,
  MfgOrderOper.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  MfgOrderOper.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  MfgOrderOper.ManufacturingOrderSubOperation AS ManufacturingOrderSubOperation,
  MfgOrderOper.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrderOper.ProductionPlant AS ProductionPlant,
  MfgOrderOper.BusinessProcessEntryUnit AS BusinessProcessEntryUnit,
  MfgOrderOper.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrderOper._MfgOrder.Material AS Material,
  MfgOrderOper.WorkCenter AS WorkCenter,
  MfgOrderOper.MfgOrderOperationText AS MfgOrderOperationText,
  MfgOrderOper.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  MfgOrderOper.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  MfgOrderOper.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  MfgOrderOper.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  MfgOrderOper.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  MfgOrderOper.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  MfgOrderOper.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  MfgOrderOper.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  MfgOrderOper.OperationUnit AS OperationUnit,
  MfgOrderOper.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  durn.ErlstSchedldExecDurnInWorkdays AS ErlstSchedldExecDurnInWorkdays,
  durn.actualexecutiondurninworkdays AS OpActualExecutionDays,
  MfgOrderOper.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  MfgOrderOper.WorkCenterInternalID AS WorkCenterInternalID,
  MfgOrderOper.OperationIsCreated AS OperationIsCreated,
  MfgOrderOper.OperationIsReleased AS OperationIsReleased,
  MfgOrderOper.WorkCenterTypeCode_2 AS WorkCenterTypeCode,
  MfgOrderOper.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  MfgOrderOper.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
  MfgOrderOper.OperationIsConfirmed AS OperationIsConfirmed,
  MfgOrderOper.WorkCenterTypeCode_2 AS WorkCenterTypeCode_2,
  MfgOrderOper._MfgOrder.ManufacturingObject AS ManufacturingObject,
  MfgOrderOper.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  MfgOrderOper.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  MfgOrderOper._MfgOrder._Material AS _Material,
  MfgOrderOper._WorkCenter_2 AS _WorkCenter,
  MfgOrderOper._WorkCenterType_2 AS _WorkCenterType,
  MfgOrderOper._MfgOrderType AS _MfgOrderType,
  MfgOrderOper._MfgOrderCategory AS _MfgOrderCategory,
  MfgOrderOper._MfgOrder AS _MfgOrder,
  MfgOrderOper._MfgOrderSequence AS _MfgOrderSequence,
  MfgOrderOper._BusinessProcessEntryUnit AS _BusinessProcessEntryUnit,
  MfgOrderOper._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  MfgOrderOper._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  MfgOrderOper._ProductionPlant AS _ProductionPlant
FROM I_MfgOrderOperationDelay AS MfgOrderOper
;

Learn More