I_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 I_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: IMPEOAEXEC

CREATE VIEW I_ProcgExecOperationActivity AS
SELECT
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstceOpActyNtwkElmnt.OperationActivityNetwork AS OperationActivityNetwork,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  cast( 0 as mpe_skipped_qty ) AS ConfirmationSkippedQuantity,
  cast( 0 as lmnga ) AS ConfirmationYieldQuantity,
  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,
  OpActyInstanceStatusBasic.OpActyIsSeldForRtactvPostg AS OpActyIsSeldForRtactvPostg,
  cast(OpActyInstceOpActyNtwkElmnt.OpActyConfIsSFIBased as boolean preserving type) AS OpActyConfIsSFIBased,
  coalesce(OpActNrOfActiveSFI.NumberOfActiveShopFloorItems, 0) AS NumberOfActiveShopFloorItems,
  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,
  OpActyInstceOpActyNtwkElmnt.OpActyHasAssgdBuyOffs AS OpActyHasAssgdBuyOffs,
  OpActyInstanceStatusBasic._SASStatus.SASStatusCategory AS SASStatusCategory,
  OpActyInstceOpActyNtwkElmnt._OperationActivity.AssemblySqncCheckIsRequired AS AssemblySqncCheckIsRequired,
  OpActyInstceOpActyNtwkElmnt._OperationActivity.OpActyInspectionRelevance AS OpActyInspectionRelevance,
  OpActyNtwkGroupElement.OpActyNtwkElementElement AS OperationActivityNetworkGroup,
  OpActyNtwkGroupElement.OpActyNtwkElementElmntVersCntr AS OpActyNtwkGroupVersionCounter,
  cast(OpActyNtwkGroupElement.OpActyNtwkElementExternalID as mpe_group_number_ext preserving type) AS OpActyNtwkGroupExternalID,
  OpActyInstceOpActyNtwkElmnt.ManufacturingOrder AS ManufacturingOrder,
  cast(MfgOrderOperation.Operation as manufacturingorderoperation preserving type) AS ManufacturingOrderOperation,
  MfgOrderOperation.OperationText AS MfgOrderOperationText,
  MfgOrderOperation.Plant AS ProductionPlant,
  MfgOrderOperation.WorkCenterInternalID AS WorkCenterInternalID,
  MfgOrderOperation.WorkCenterTypeCode AS WorkCenterTypeCode,
  MfgOrderOperation.OperationControlProfile AS OperationControlProfile,
  _WorkCenter.WorkCenter AS WorkCenter,
  MfgOrderOperation.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  MfgOrderOperation.OperationUnit AS OperationUnit,
  MfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrder.Material AS Material,
  MfgOrder.ProductionPlant AS OrderHeaderProductionPlant,
  MfgOrder.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  MfgOrder.ExtdQualityCheckIsRequired AS ExtdQualityCheckIsRequired,
  MfgOrder.BillOfMaterialCategory AS BillOfMaterialCategory,
  MfgOrder.BillOfMaterialVariant AS BillOfMaterialVariant,
  MfgOrder.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MfgOrder.BillOfMaterialVersion AS BillOfMaterialVersion,
  MfgOrder.BillOfOperations AS BillOfOperations,
  MfgOrder.BillOfOperationsVariant AS BillOfOperationsVariant,
  MfgOrder.BillOfOperationsVersion AS BillOfOperationsVersion,
  MfgOrderOperation.BOOOperationInternalID AS BOOOperationInternalID,
  MfgOrder.ProductConfiguration AS ProductConfiguration,
  MfgOrder.InspectionLot AS InspectionLot,
  cast(_WorkCenter.LaborTrackingIsRequired as boolean preserving type) AS LaborTrackingIsRequired,
  _OpActyWorkInstructionAssgmt.WorkInstruction AS WorkInstruction,
  _OpActyWorkInstructionAssgmt.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  OpActyInstceOpActyNtwkElmnt._UnitOfMeasure AS _UnitOfMeasure,
  OpActyInstceOpActyNtwkElmnt._SASSchema AS _SASSchema,
  OpActyInstanceStatusBasic._SASStatus AS _SASStatus,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  OpActyInstceOpActyNtwkElmnt._OperationActivityNetwork AS _OperationActivityNetwork,
  OpActyInstceOpActyNtwkElmnt._OrderInternalID AS _OrderInternalID,
  OpActyInstceOpActyNtwkElmnt._MfgOrder AS _MfgOrder,
  MfgOrder._MfgOrderType AS _MfgOrderType,
  MfgOrder._BillOfMaterial AS _BillOfMaterial,
  MfgOrder._Material AS _Material
FROM I_ExecRlvtOAInstceOANElmnt AS OpActyInstceOpActyNtwkElmnt
INNER JOIN I_OpActyInstanceStatusBasic AS OpActyInstanceStatusBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperation AS MfgOrderOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrder AS MfgOrder ON /* join condition not captured in parsed metadata */
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 ManufacturingOrder = _OpActyDocInfoRecdObjLink.ManufacturingOrder AND ( OpActyNtwkInstance <> _OpActyDocInfoRecdObjLink.OpActyNtwkInstance OR OpActyNtwkElement <> _OpActyDocInfoRecdObjLink.OpActyNtwkElement )  -- association [0..*]
LEFT OUTER JOIN I_SFIDocInfoRecdObjLink AS _SFIDocInfoRecdObjLink ON ManufacturingOrder = _SFIDocInfoRecdObjLink.ManufacturingOrder AND ( OpActyNtwkInstance <> _SFIDocInfoRecdObjLink.OpActyNtwkInstance OR OpActyNtwkElement <> _SFIDocInfoRecdObjLink.OpActyNtwkElement )  -- association [0..*]
LEFT OUTER JOIN I_OpActyWorkInstructionAssgmt AS _OpActyWorkInstructionAssgmt ON OpActyNtwkElementElement = _OpActyWorkInstructionAssgmt.OperationActivity AND OpActyNtwkElementElmntVersCntr = _OpActyWorkInstructionAssgmt.OperationActyVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON workcenter = _WorkCenterBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON ManufacturingOrder = _OrderItem.OrderID AND _OrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _OrderHeaderProductionPlant ON OrderHeaderProductionPlant = _OrderHeaderProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
LEFT OUTER JOIN E_OperationActivity AS _Extension ON OperationActivity = _Extension.OperationActivity AND OperationActyVersionCounter = _Extension.OperationActyVersionCounter  -- association [0..1]
;