P_MfgProcgExecOperation

DDL: P_MFGPROCGEXECOPERATION SQL: PMPEOPER Type: view CONSUMPTION
67 Fields 2 Data Sources

P_MfgProcgExecOperation is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_MfgOrderOperationDelayBasic, I_OrderItem) and exposes 67 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem.

Data Sources (2)

SourceAliasJoin Type
I_MfgOrderOperationDelayBasic MfgOrderOperationDelayBasic from
I_OrderItem OrderItem inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMPEOPER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations I_MfgOrderOperationDelayBasic OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem I_MfgOrderOperationDelayBasic OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ManufacturingOrder I_MfgOrderOperationDelayBasic ManufacturingOrder Order
ManufacturingOrderCategory I_MfgOrderOperationDelayBasic ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrderOperationDelayBasic ManufacturingOrderType
Reservation I_MfgOrderOperationDelayBasic Reservation Reservation
ProdnProcgIsFlexible I_MfgOrderOperationDelayBasic ProdnProcgIsFlexible
ManufacturingOrderSequence I_MfgOrderOperationDelayBasic ManufacturingOrderSequence
ProductionPlant I_MfgOrderOperationDelayBasic ProductionPlant Prod plnt
ManufacturingOrderOperation I_MfgOrderOperationDelayBasic ManufacturingOrderOperation Activity
MfgOrderOperationText I_MfgOrderOperationDelayBasic MfgOrderOperationText
ProduceOpActyNtwkInstance I_MfgOrderOperationDelayBasic ProduceOpActyNtwkInstance
Material I_OrderItem Material Vehicle Model
WBSElementInternalID I_OrderItem WBSElementInternalID_2
WorkCenterInternalID I_MfgOrderOperationDelayBasic WorkCenterInternalID Work Center
WorkCenterTypeCode I_MfgOrderOperationDelayBasic WorkCenterTypeCode Object Type
PlantTimeZone I_MfgOrderOperationDelayBasic PlantTimeZone Time Zone
OpLtstSchedldExecStrtDte I_MfgOrderOperationDelayBasic OpLtstSchedldExecStrtDte Latest start
OpLtstSchedldExecStrtTme I_MfgOrderOperationDelayBasic OpLtstSchedldExecStrtTme
OpLtstSchedldExecStrtDteTme I_MfgOrderOperationDelayBasic OpLtstSchedldExecStrtDteTme Time Stamp
OpLtstSchedldExecEndDte I_MfgOrderOperationDelayBasic OpLtstSchedldExecEndDte Lat.finish date
OpLtstSchedldExecEndTme I_MfgOrderOperationDelayBasic OpLtstSchedldExecEndTme
OpLtstSchedldExecEndDteTme I_MfgOrderOperationDelayBasic OpLtstSchedldExecEndDteTme Time Stamp
OpActualExecutionStartDate I_MfgOrderOperationDelayBasic OpActualExecutionStartDate Execution Start Date
OpActualExecutionStartTime I_MfgOrderOperationDelayBasic OpActualExecutionStartTime
OpActualExecutionStartDateTime I_MfgOrderOperationDelayBasic OpActualExecutionStartDateTime Time Stamp
OpActualExecutionEndDate I_MfgOrderOperationDelayBasic OpActualExecutionEndDate Execution End Date
OpActualExecutionEndTime I_MfgOrderOperationDelayBasic OpActualExecutionEndTime
OpActualExecutionEndDateTime I_MfgOrderOperationDelayBasic OpActualExecutionEndDateTime Time Stamp
OpPlannedScrapQuantity
OpPlannedTotalQuantity I_MfgOrderOperationDelayBasic OpPlannedTotalQuantity
OpTotalConfirmedYieldQty I_MfgOrderOperationDelayBasic OpTotalConfirmedYieldQty
OpTotalConfirmedScrapQty I_MfgOrderOperationDelayBasic OpTotalConfirmedScrapQty
OpExecutionCompletedQuantity
OperationUnit I_MfgOrderOperationDelayBasic OperationUnit Act/op UoM
OperationExecutionStartIsLate I_MfgOrderOperationDelayBasic OperationExecutionStartIsLate
OpActyNtwkInstance OpActyNtwkInstance OpActyNtwkInstance Instance ID
OperationActivityNetwork OpActyNtwkInstance OperationActivityNetwork
OpActyNtwkVersionCounter OpActyNtwkInstance OpActyNtwkVersionCounter
OpActyConfIsSFIBased OpActyNtwkInstance OpActyConfIsSFIBased
OperationIsClosed
OperationIsTechlyCompleted I_MfgOrderOperationDelayBasic OperationIsTechlyCompleted
OperationIsDelivered I_MfgOrderOperationDelayBasic OperationIsDelivered
OperationIsPartiallyDelivered I_MfgOrderOperationDelayBasic OperationIsPartiallyDelivered
OperationIsPartiallyConfirmed I_MfgOrderOperationDelayBasic OperationIsPartiallyConfirmed
OperationIsPrinted I_MfgOrderOperationDelayBasic OperationIsPrinted
OperationIsReleased I_MfgOrderOperationDelayBasic OperationIsReleased
OperationIsCreated I_MfgOrderOperationDelayBasic OperationIsCreated
OperationIsScheduled I_MfgOrderOperationDelayBasic OperationIsScheduled
OperationIsConfirmed I_MfgOrderOperationDelayBasic OperationIsConfirmed
OperationIsDeleted I_MfgOrderOperationDelayBasic OperationIsDeleted
OperationExecutionEndIsLate I_MfgOrderOperationDelayBasic OperationExecutionEndIsLate
OperationYieldDeviationQty I_MfgOrderOperationDelayBasic OperationYieldDeviationQty
OperationStartDeviationDays
PlannedEndDateDvtnInDays
EffectivityParameterVariant I_OrderItem EffectivityParameterVariant
NumberOfWorkCenterHolds
NumberOfOrderHolds
NumberOfOperationHolds
NumberOfOperationActivityHolds
_Material I_OrderItem _Material
_WorkCenter I_MfgOrderOperationDelayBasic _WorkCenter
_ProductionPlant I_MfgOrderOperationDelayBasic _ProductionPlant
_OpActyNtwkInternalId OpActyNtwkInstance _OpActyNtwkInternalId
_OperationActivityNetwork OpActyNtwkInstance _OperationActivityNetwork
OrderIsShopFloorOrder
_WBSElementBasicData I_OrderItem _WBSElementBasicData2

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_MfgProcgExecOperation.
-- 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: PMPEOPER

CREATE VIEW P_MfgProcgExecOperation AS
SELECT
  MfgOrderOperationDelayBasic.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  MfgOrderOperationDelayBasic.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  MfgOrderOperationDelayBasic.ManufacturingOrder AS ManufacturingOrder,
  MfgOrderOperationDelayBasic.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrderOperationDelayBasic.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrderOperationDelayBasic.Reservation AS Reservation,
  MfgOrderOperationDelayBasic.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  MfgOrderOperationDelayBasic.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  MfgOrderOperationDelayBasic.ProductionPlant AS ProductionPlant,
  MfgOrderOperationDelayBasic.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  MfgOrderOperationDelayBasic.MfgOrderOperationText AS MfgOrderOperationText,
  MfgOrderOperationDelayBasic.ProduceOpActyNtwkInstance AS ProduceOpActyNtwkInstance,
  OrderItem.Material AS Material,
  OrderItem.WBSElementInternalID_2 AS WBSElementInternalID,
  MfgOrderOperationDelayBasic.WorkCenterInternalID AS WorkCenterInternalID,
  MfgOrderOperationDelayBasic.WorkCenterTypeCode AS WorkCenterTypeCode,
  MfgOrderOperationDelayBasic.PlantTimeZone AS PlantTimeZone,
  MfgOrderOperationDelayBasic.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  MfgOrderOperationDelayBasic.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  MfgOrderOperationDelayBasic.OpLtstSchedldExecStrtDteTme AS OpLtstSchedldExecStrtDteTme,
  MfgOrderOperationDelayBasic.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  MfgOrderOperationDelayBasic.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  MfgOrderOperationDelayBasic.OpLtstSchedldExecEndDteTme AS OpLtstSchedldExecEndDteTme,
  MfgOrderOperationDelayBasic.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  MfgOrderOperationDelayBasic.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  MfgOrderOperationDelayBasic.OpActualExecutionStartDateTime AS OpActualExecutionStartDateTime,
  MfgOrderOperationDelayBasic.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  MfgOrderOperationDelayBasic.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  MfgOrderOperationDelayBasic.OpActualExecutionEndDateTime AS OpActualExecutionEndDateTime,
  MfgOrderOperationDelayBasic.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  MfgOrderOperationDelayBasic.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  MfgOrderOperationDelayBasic.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  cast(0 as lmnga) AS OpExecutionCompletedQuantity,
  MfgOrderOperationDelayBasic.OperationUnit AS OperationUnit,
  MfgOrderOperationDelayBasic.OperationExecutionStartIsLate AS OperationExecutionStartIsLate,
  OpActyNtwkInstance.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyNtwkInstance.OperationActivityNetwork AS OperationActivityNetwork,
  OpActyNtwkInstance.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  OpActyNtwkInstance.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  MfgOrderOperationDelayBasic.OperationIsTechlyCompleted AS OperationIsTechlyCompleted,
  MfgOrderOperationDelayBasic.OperationIsDelivered AS OperationIsDelivered,
  MfgOrderOperationDelayBasic.OperationIsPartiallyDelivered AS OperationIsPartiallyDelivered,
  MfgOrderOperationDelayBasic.OperationIsPartiallyConfirmed AS OperationIsPartiallyConfirmed,
  MfgOrderOperationDelayBasic.OperationIsPrinted AS OperationIsPrinted,
  MfgOrderOperationDelayBasic.OperationIsReleased AS OperationIsReleased,
  MfgOrderOperationDelayBasic.OperationIsCreated AS OperationIsCreated,
  MfgOrderOperationDelayBasic.OperationIsScheduled AS OperationIsScheduled,
  MfgOrderOperationDelayBasic.OperationIsConfirmed AS OperationIsConfirmed,
  MfgOrderOperationDelayBasic.OperationIsDeleted AS OperationIsDeleted,
  MfgOrderOperationDelayBasic.OperationExecutionEndIsLate AS OperationExecutionEndIsLate,
  MfgOrderOperationDelayBasic.OperationYieldDeviationQty AS OperationYieldDeviationQty,
  cast(MfgOrderOperationDelayBasic.PlannedCurrentStrtDateDvtnDurn as abap.fltp)/ 86400.00 AS OperationStartDeviationDays,
  cast(MfgOrderOperationDelayBasic.PlannedCurrentEndDateDvtnDurn as abap.fltp)/ 86400.00 AS PlannedEndDateDvtnInDays,
  OrderItem.EffectivityParameterVariant AS EffectivityParameterVariant,
  cast(coalesce(WrkCtrNmbrOfProdnHolds.NumberOfHolds, 0) as mpe_number_of_holds preserving type) AS NumberOfWorkCenterHolds,
  cast(coalesce(OrderNmbrOfProdnHolds.NumberOfHolds, 0) as mpe_number_of_holds preserving type) AS NumberOfOrderHolds,
  cast(coalesce(OperNmbrOfProdnHolds.NumberOfHolds, 0) as mpe_number_of_holds preserving type) AS NumberOfOperationHolds,
  cast(coalesce(MfgOrderOpNmbrOfOpActyOnHold.OpActyWithoutHold, 0) as mpe_number_of_holds) AS NumberOfOperationActivityHolds,
  OrderItem._Material AS _Material,
  MfgOrderOperationDelayBasic._WorkCenter AS _WorkCenter,
  MfgOrderOperationDelayBasic._ProductionPlant AS _ProductionPlant,
  OpActyNtwkInstance._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  OpActyNtwkInstance._OperationActivityNetwork AS _OperationActivityNetwork,
  case when OpActyNtwkInstance.OpActyNtwkInstance is null then '' else 'X' end AS OrderIsShopFloorOrder,
  OrderItem._WBSElementBasicData2 AS _WBSElementBasicData
FROM I_MfgOrderOperationDelayBasic AS MfgOrderOperationDelayBasic
INNER JOIN I_OrderItem AS OrderItem ON /* join condition not captured in parsed metadata */
;

Learn More