I_ProcgExecOpActyInstceTP

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_ProcgExecOpActyInstceTP.
-- 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_ProcgExecOpActyInstceTP AS
SELECT
  oa.OpActyNtwkInstance AS OpActyNtwkInstance,
  oa.OpActyNtwkElement AS OpActyNtwkElement,
  oa.OperationActivityNetwork AS OperationActivityNetwork,
  oa.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  cast( 0 as mpe_scrapped_frm_prcssg ) AS ConfirmationScrapQuantity,
  cast( 0 as mpe_skipped_qty ) AS ConfirmationSkippedQuantity,
  cast( 0 as lmnga ) AS ConfirmationYieldQuantity,
  oa.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  oa.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  oa.ProductionUnit AS ProductionUnit,
  cast( 0 as mpe_target_duration_quan ) AS OpActyExpdExecutionDuration,
  cast( 0 as mpe_target_labor_durn_quan ) AS OpActyExpdExecutionLaborDurn,
  cast('' as durationunit) AS DurationUnit,
  oa.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  oa.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  oa.OrderInternalID AS OrderInternalID,
  oa.OrderOperationInternalID AS OrderOperationInternalID,
  oa.StatusAndActionSchema AS StatusAndActionSchema,
  oa.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  oa.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  oa.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  oa.OperationActivity AS OperationActivity,
  oa.OperationActyVersionCounter AS OperationActyVersionCounter,
  oa.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  oa.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  oa.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  oa.OANElementDisplaySqncNumber AS OANElementDisplaySqncNumber,
  oa.SASStatusCriticality AS SASStatusCriticality,
  oa.SASStatusCategory AS SASStatusCategory,
  oa.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  oa.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  oa.OpLtstSchedldExecStrtDteTme AS OpLtstSchedldExecStrtDteTme,
  oa.DateIsActualDate AS DateIsActualDate,
  cast( 0 as mpe_group_id ) AS OperationActivityNetworkGroup,
  cast( 0 as mpe_group_version_no ) AS OpActyNtwkGroupVersionCounter,
  cast( '' as mpe_group_number_ext ) AS OpActyNtwkGroupExternalID,
  _OrderItem.Material AS Material,
  oa.ManufacturingOrder AS ManufacturingOrder,
  oa.ManufacturingOrderText AS ManufacturingOrderText,
  oa.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  cast(ManufacturingOrderOperation as mpe_vornr_char preserving type) AS ManufacturingOrderOperation,
  oa.MfgOrderOperationText AS MfgOrderOperationText,
  oa.MfgOrderOperationOrSubOp AS MfgOrderOperationOrSubOp,
  oa.ProductionPlant AS ProductionPlant,
  oa.ProductionPlantName AS ProductionPlantName,
  oa.WorkCenterInternalID AS WorkCenterInternalID,
  oa.WorkCenterTypeCode AS WorkCenterTypeCode,
  oa.WorkCenter AS WorkCenter,
  oa.WorkCenterText AS WorkCenterText,
  oa.LaborTrackingIsRequired AS LaborTrackingIsRequired,
  oa.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  oa.OperationUnit AS OperationUnit,
  cast( 0 as mpe_ready_qty ) AS OperationExecutionAvailableQty,
  cast( 0 as mpe_hold_nmbr ) AS ProductionHold,
  cast( '' as qcode) AS ManufacturingActionReasonCode,
  cast( '' as qcodegrp ) AS MfgActionReasonCodeGroup,
  cast('' as qkatart) AS MfgActionReasonCodeGroupCtlg,
  cast('' as qtxt_code) AS MfgActionReasonCodeName,
  oa._MfgOrder AS _MfgOrder,
  oa._MfgOrderDocInfoRecdObjLink AS _MfgOrderDocInfoRecdObjLink,
  oa._MfgOrderOpDocInfoRecdObjLink AS _MfgOrderOpDocInfoRecdObjLink,
  oa._OpActyDocInfoRecdObjLink AS _OpActyDocInfoRecdObjLink,
  oa._OpActyNtwkInstance AS _OpActyNtwkInstance,
  oa._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  oa._OperationActivityNetwork AS _OperationActivityNetwork,
  oa._OperationActivityText AS _OperationActivityText,
  oa._OrderInternalID AS _OrderInternalID,
  oa._ProductionPlant AS _ProductionPlant,
  oa._SASSchema AS _SASSchema,
  oa._SASStatus AS _SASStatus,
  oa._WorkCenter AS _WorkCenter,
  oa._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  oa._WorkCenterType AS _WorkCenterType,
  oa._OpActyMainWrkCtrMfgUser AS _OpActyMainWrkCtrMfgUser,
  _OrderItem._Material AS _Material
FROM P_ProcgExecOperationActivity AS oa
LEFT OUTER JOIN I_OpActyUserAssgmt AS _OpActyUserAssgmt ON OpActyNtwkInstance = _OpActyUserAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyUserAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_OpActyRespyMgmtTeamAssgmt AS _OpActyRespyMgmtTeamAssgmt ON OpActyNtwkInstance = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON ManufacturingOrder = _OrderItem.OrderID AND _OrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_OpActyUserAssgmtTP AS _OpActyUserAssgmtTP ON OpActyNtwkInstance = _OpActyUserAssgmtTP.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyUserAssgmtTP.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_OpActyTeamAssgmtTP AS _OpActyTeamAssgmtTP ON OpActyNtwkInstance = _OpActyTeamAssgmtTP.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyTeamAssgmtTP.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN E_OperationActivity AS _Extension ON OperationActivity = _Extension.OperationActivity AND OperationActyVersionCounter = _Extension.OperationActyVersionCounter  -- association [0..1]
;