R_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 R_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 R_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.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.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  cast(oa.ManufacturingOrderOperation as mpe_vornr_char preserving type ) AS ManufacturingOrderOperation,
  oa.MfgOrderOperationText AS MfgOrderOperationText,
  cast(oa.MfgOrderOperationOrSubOp as mpe_vornr_char preserving type ) AS MfgOrderOperationOrSubOp,
  oa.ProductionPlant AS ProductionPlant,
  oa.WorkCenter AS WorkCenter,
  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,
  cast('' as mpe_effectivity_parameter_desc) AS EffectivityParameterDesc,
  OpActyWorkInstructionAssgmt.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  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._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  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_OrderItem AS _OrderItem ON ManufacturingOrder = _OrderItem.OrderID AND _OrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_OANSegmentType AS _OANSegmentType ON OpActyNtwkSegmentType = _OANSegmentType.OpActyNtwkSegmentType  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterTextBySemanticKey AS _WorkCenterTextBySemanticKey ON WorkCenter = _WorkCenterTextBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterTextBySemanticKey.Plant  -- association [0..*]
;