P_ProcgExecOperationActivity

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_ProcgExecOperationActivity.
-- 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: PMPEOAEXEC

CREATE VIEW P_ProcgExecOperationActivity AS
SELECT
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceOpActyNtwkElmnt.OperationActivityNetwork AS OperationActivityNetwork,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  OpActyInstceOpActyNtwkElmnt.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  OpActyInstceOpActyNtwkElmnt.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  OpActyInstceOpActyNtwkElmnt.ProductionUnit AS ProductionUnit,
  OpActyInstceOpActyNtwkElmnt.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  OpActyInstceOpActyNtwkElmnt.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  OpActyInstceOpActyNtwkElmnt.OrderInternalID AS OrderInternalID,
  OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID AS OrderOperationInternalID,
  OpActyInstceOpActyNtwkElmnt.StatusAndActionSchema AS StatusAndActionSchema,
  OpActyInstanceStatusBasic.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  cast(OpActyInstceOpActyNtwkElmnt.OpActyConfIsSFIBased as boolean preserving type) AS OpActyConfIsSFIBased,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OpActyInstceOpActyNtwkElmnt.OperationActivity AS OperationActivity,
  OpActyInstceOpActyNtwkElmnt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyInstceOpActyNtwkElmnt.OANElementDisplaySqncNumber AS OANElementDisplaySqncNumber,
  OpActyInstanceStatusBasic._SASStatus.SASStatusCategory AS SASStatusCategory,
  MfgOrderOperation.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  MfgOrderOperation.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  MfgOrderOperation.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  MfgOrderOperation.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  MfgOrderOperation.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  MfgOrderOperation.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  MfgOrderOperation.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  MfgOrderOperation.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  OpActyInstceOpActyNtwkElmnt.ManufacturingOrder AS ManufacturingOrder,
  LogisticsOrder.ManufacturingOrderText AS ManufacturingOrderText,
  LogisticsOrder.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  MfgOrderOperation.Operation AS ManufacturingOrderOperation,
  MfgOrderOperation.OperationText AS MfgOrderOperationText,
  MfgOrderOperation.Operation AS MfgOrderOperationOrSubOp,
  MfgOrderOperation.Plant AS ProductionPlant,
  MfgOrderOperation.PlantName AS ProductionPlantName,
  MfgOrderOperation.WorkCenterInternalID AS WorkCenterInternalID,
  MfgOrderOperation.WorkCenterTypeCode AS WorkCenterTypeCode,
  MfgOrderOperation._WorkCenter.WorkCenter AS WorkCenter,
  MfgOrderOperation._WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  MfgOrderOperation._WorkCenter.LaborTrackingIsRequired AS LaborTrackingIsRequired,
  MfgOrderOperation.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  MfgOrderOperation.OperationUnit AS OperationUnit,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt._SASSchema AS _SASSchema,
  OpActyInstanceStatusBasic._SASStatus AS _SASStatus,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  OpActyInstceOpActyNtwkElmnt._OperationActivityNetwork AS _OperationActivityNetwork,
  OpActyInstceOpActyNtwkElmnt._OrderInternalID AS _OrderInternalID,
  OpActyInstceOpActyNtwkElmnt._MfgOrder AS _MfgOrder,
  OpActyInstceOpActyNtwkElmnt._OperationActivityText AS _OperationActivityText,
  MfgOrderOperation._WorkCenter AS _WorkCenter
FROM I_OpActyInstanceStatusBasic AS OpActyInstanceStatusBasic
INNER JOIN I_ExecRlvtOAInstceOANElmnt AS OpActyInstceOpActyNtwkElmnt ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationDateTime AS MfgOrderOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrderBasic AS LogisticsOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderDocInfoRecdObjLink AS _MfgOrderDocInfoRecdObjLink ON ManufacturingOrder = _MfgOrderDocInfoRecdObjLink.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderOpDocInfoRecdObjLink AS _MfgOrderOpDocInfoRecdObjLink ON ManufacturingOrder = _MfgOrderOpDocInfoRecdObjLink.ManufacturingOrder AND OrderOperationInternalID = _MfgOrderOpDocInfoRecdObjLink.OrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_OpActyDocInfoRecdObjLink AS _OpActyDocInfoRecdObjLink ON OpActyNtwkInstance = _OpActyDocInfoRecdObjLink.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyDocInfoRecdObjLink.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON workcenter = _WorkCenterBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_OpActyMainWrkCtrMfgUser AS _OpActyMainWrkCtrMfgUser ON OpActyNtwkInstance = _OpActyMainWrkCtrMfgUser.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyMainWrkCtrMfgUser.OpActyNtwkElement  -- association [0..*]
;