C_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 C_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.
-- SQL view name: CMPEOAIEXECTP

CREATE VIEW C_ProcgExecOpActyInstceTP AS
SELECT
  ProcgExecOpActyInstceTP.OpActyNtwkInstance AS OpActyNtwkInstance,
  ProcgExecOpActyInstceTP.OpActyNtwkElement AS OpActyNtwkElement,
  ProcgExecOpActyInstceTP.OperationActivityNetwork AS OperationActivityNetwork,
  ProcgExecOpActyInstceTP.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  ProcgExecOpActyInstceTP.ConfirmationScrapQuantity AS ConfirmationScrapQuantity,
  ProcgExecOpActyInstceTP.ConfirmationSkippedQuantity AS ConfirmationSkippedQuantity,
  ProcgExecOpActyInstceTP.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  ProcgExecOpActyInstceTP.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  ProcgExecOpActyInstceTP.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  ProcgExecOpActyInstceTP.ProductionUnit AS ProductionUnit,
  ProcgExecOpActyInstceTP.OpActyExpdExecutionDuration AS OpActyExpdExecutionDuration,
  ProcgExecOpActyInstceTP.OpActyExpdExecutionLaborDurn AS OpActyExpdExecutionLaborDurn,
  ProcgExecOpActyInstceTP.DurationUnit AS DurationUnit,
  ProcgExecOpActyInstceTP.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  ProcgExecOpActyInstceTP.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  ProcgExecOpActyInstceTP.OrderInternalID AS OrderInternalID,
  ProcgExecOpActyInstceTP.OrderOperationInternalID AS OrderOperationInternalID,
  ProcgExecOpActyInstceTP.StatusAndActionSchema AS StatusAndActionSchema,
  ProcgExecOpActyInstceTP.ExtdQualityCheckIsRequired AS ExtdQualityCheckIsRequired,
  ProcgExecOpActyInstceTP.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  cast(_SASStatusText[1: Language=$session.system_language].SASStatusName as mpe_oa_status_description preserving type) AS StatusName,
  cast(ProcgExecOpActyInstceTP.OpActyNtwkElementExternalID as mpe_oa_number_ext preserving type) AS OpActyNtwkElementExternalID,
  ProcgExecOpActyInstceTP._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  ProcgExecOpActyInstceTP.OperationActivity AS OperationActivity,
  ProcgExecOpActyInstceTP.OperationActyVersionCounter AS OperationActyVersionCounter,
  ProcgExecOpActyInstceTP.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  ProcgExecOpActyInstceTP.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  ProcgExecOpActyInstceTP.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  ProcgExecOpActyInstceTP.SASStatusCategory AS SASStatusCategory,
  ProcgExecOpActyInstceTP.OpLtstSchedldExecStrtDteTme AS OpLtstSchedldExecStrtDteTme,
  ProcgExecOpActyInstceTP.DateIsActualDate AS DateIsActualDate,
  ProcgExecOpActyInstceTP.OperationActivityNetworkGroup AS OperationActivityNetworkGroup,
  ProcgExecOpActyInstceTP.OpActyNtwkGroupVersionCounter AS OpActyNtwkGroupVersionCounter,
  ProcgExecOpActyInstceTP.OpActyNtwkGroupExternalID AS OpActyNtwkGroupExternalID,
  ProcgExecOpActyInstceTP.Material AS Material,
  ProcgExecOpActyInstceTP._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ProcgExecOpActyInstceTP.ManufacturingOrder AS ManufacturingOrder,
  ProcgExecOpActyInstceTP.ManufacturingOrderText AS ManufacturingOrderText,
  ProcgExecOpActyInstceTP.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  cast(ProcgExecOpActyInstceTP.ManufacturingOrderOperation as manufacturingorderoperation preserving type) AS ManufacturingOrderOperation,
  ProcgExecOpActyInstceTP.MfgOrderOperationText AS MfgOrderOperationText,
  ProcgExecOpActyInstceTP.MfgOrderOperationOrSubOp AS MfgOrderOperationOrSubOp,
  ProcgExecOpActyInstceTP.ProductionPlant AS ProductionPlant,
  ProcgExecOpActyInstceTP.ProductionPlantName AS ProductionPlantName,
  ProcgExecOpActyInstceTP.WorkCenterInternalID AS WorkCenterInternalID,
  ProcgExecOpActyInstceTP.WorkCenterTypeCode AS WorkCenterTypeCode,
  ProcgExecOpActyInstceTP.WorkCenter AS WorkCenter,
  ProcgExecOpActyInstceTP.WorkCenterText AS WorkCenterText,
  ProcgExecOpActyInstceTP.LaborTrackingIsRequired AS LaborTrackingIsRequired,
  ProcgExecOpActyInstceTP.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  ProcgExecOpActyInstceTP.OperationUnit AS OperationUnit,
  ProcgExecOpActyInstceTP.NrOfOpActyUserAssignments AS NrOfOpActyUserAssignments,
  ProcgExecOpActyInstceTP.UserID AS UserID,
  ProcgExecOpActyInstceTP.UserDescription AS UserDescription,
  ProcgExecOpActyInstceTP.NrOfOpActyTeamAssignments AS NrOfOpActyTeamAssignments,
  ProcgExecOpActyInstceTP.RespyMgmtTeamID AS RespyMgmtTeamID,
  ProcgExecOpActyInstceTP.TeamName AS TeamName,
  ProcgExecOpActyInstceTP.OpActyHasMissingComponents AS OpActyHasMissingComponents,
  ProcgExecOpActyInstceTP.OperationExecutionAvailableQty AS OperationExecutionAvailableQty,
  cast('' as mpe_effectivity_parameter_desc) AS EffectivityParameterDesc,
  ProcgExecOpActyInstceTP.ProductionHold AS ProductionHold,
  ProcgExecOpActyInstceTP.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  ProcgExecOpActyInstceTP.MfgActionReasonCodeName AS MfgActionReasonCodeName,
  ProcgExecOpActyInstceTP.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  ProcgExecOpActyInstceTP.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  OpActyWorkInstructionAssgmt.WorkInstruction AS WorkInstruction,
  OpActyWorkInstructionAssgmt.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  _MfgWorkInstructionVersion.MfgWorkInstructionContent AS MfgWorkInstructionContent,
  OAInstceNrOfExtdQltyChkGrps.NrOfExtdQualityCheckGroups AS NrOfExtdQualityCheckGroups,
  OAInstceNrOfExtdQltyChkGrps.ExtendedQualityCheckGroup AS ExtendedQualityCheckGroup,
  ProcgExecOpActyInstceTP._MfgOrder AS _MfgOrder,
  ProcgExecOpActyInstceTP._Material AS _Material,
  ProcgExecOpActyInstceTP._MfgOrderDocInfoRecdObjLink AS _MfgOrderDocInfoRecdObjLink,
  ProcgExecOpActyInstceTP._MfgOrderOpDocInfoRecdObjLink AS _MfgOrderOpDocInfoRecdObjLink,
  ProcgExecOpActyInstceTP._OpActyDocInfoRecdObjLink AS _OpActyDocInfoRecdObjLink,
  ProcgExecOpActyInstceTP._OpActyNtwkInstance AS _OpActyNtwkInstance,
  ProcgExecOpActyInstceTP._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  ProcgExecOpActyInstceTP._OperationActivityNetwork AS _OperationActivityNetwork,
  ProcgExecOpActyInstceTP._OrderInternalID AS _OrderInternalID,
  ProcgExecOpActyInstceTP._ProductionPlant AS _ProductionPlant,
  ProcgExecOpActyInstceTP._SASSchema AS _SASSchema,
  ProcgExecOpActyInstceTP._SASStatus AS _SASStatus,
  ProcgExecOpActyInstceTP._WorkCenter AS _WorkCenter,
  ProcgExecOpActyInstceTP._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  ProcgExecOpActyInstceTP._WorkCenterType AS _WorkCenterType,
  ProcgExecOpActyInstceTP._OpActyUserAssgmt AS _OpActyUserAssgmt,
  ProcgExecOpActyInstceTP._OpActyRespyMgmtTeamAssgmt AS _OpActyRespyMgmtTeamAssgmt
FROM I_ProcgExecOpActyInstceTP AS ProcgExecOpActyInstceTP
LEFT OUTER JOIN I_SASStatusText AS _SASStatusText ON StatusAndActionSchemaStatus = _SASStatusText.StatusAndActionSchemaStatus  -- association [0..*]
LEFT OUTER JOIN I_OANSegmentType AS _OANSegmentType ON OpActyNtwkSegmentType = _OANSegmentType.OpActyNtwkSegmentType  -- association [0..1]
LEFT OUTER JOIN C_OpActyUserAssgmtTP AS _OpActyUserAssgmtTP ON OpActyNtwkInstance = _OpActyUserAssgmtTP.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyUserAssgmtTP.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OpActyTeamAssgmtTP AS _OpActyTeamAssgmtTP ON OpActyNtwkInstance = _OpActyTeamAssgmtTP.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyTeamAssgmtTP.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_ShopFloorItemAtOpActy AS _ShopFloorItemAtOpActy ON OpActyNtwkInstance = _ShopFloorItemAtOpActy.OpActyNtwkInstance AND OpActyNtwkElement = _ShopFloorItemAtOpActy.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OperationActivityPlndMatlRet AS _OperationActivityPlndMatlRet ON OpActyNtwkInstance = _OperationActivityPlndMatlRet.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityPlndMatlRet.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OperationActivityComponent AS _OperationActivityComponent ON OpActyNtwkInstance = _OperationActivityComponent.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityComponent.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OperationActyPRTAssignment AS _OperationActyPRTAssignment ON OpActyNtwkInstance = _OperationActyPRTAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActyPRTAssignment.OpActyNtwkElement AND OrderInternalID = _OperationActyPRTAssignment.OrderInternalID  -- association [0..*]
LEFT OUTER JOIN C_OpActyInstcePlndPRTNoDoc AS _OpActyInstcePlndPRTNoDoc ON OpActyNtwkInstance = _OpActyInstcePlndPRTNoDoc.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyInstcePlndPRTNoDoc.OpActyNtwkElement AND OrderInternalID = _OpActyInstcePlndPRTNoDoc.OrderInternalID  -- association [0..*]
LEFT OUTER JOIN C_MfgQualifnOpActyAssgmt AS _MfgQualifnOpActyAssgmt ON OpActyNtwkInstance = _MfgQualifnOpActyAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _MfgQualifnOpActyAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_ShopFloorOrderDefect AS _MfgOrderDefectRecord ON OpActyNtwkInstance = _MfgOrderDefectRecord.OpActyNtwkInstance AND OpActyNtwkElement = _MfgOrderDefectRecord.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_MfgWorkInstructionVersion AS _MfgWorkInstructionVersion ON WorkInstruction = _MfgWorkInstructionVersion.MfgWorkInstruction AND WorkInstructionVersionCounter = _MfgWorkInstructionVersion.MfgWorkInstructionVersCounter AND _MfgWorkInstructionVersion.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_MatlNmbrOfProdnHolds AS _MatlNmbrOfProdnHolds ON Material = _MatlNmbrOfProdnHolds.Material  -- association [0..1]
LEFT OUTER JOIN P_MfgOrderNmbrOfOrderHolds AS _MfgOrderNmbrOfOrderHolds ON ManufacturingOrder = _MfgOrderNmbrOfOrderHolds.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN P_OperNmbrOfProdnHolds AS _OperNmbrOfProdnHolds ON OrderInternalID = _OperNmbrOfProdnHolds.OrderInternalID AND OrderOperationInternalID = _OperNmbrOfProdnHolds.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN P_WrkCtrNmbrOfProdnHolds AS _WrkCtrNmbrOfProdnHolds ON WorkCenterInternalID = _WrkCtrNmbrOfProdnHolds.WorkCenterInternalID AND WorkCenterTypeCode = _WrkCtrNmbrOfProdnHolds.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN P_OpActyNumberOfProdnHold AS _OpActyNumberOfProdnHold ON OpActyNtwkInstance = _OpActyNumberOfProdnHold.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyNumberOfProdnHold.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN C_OpActyAllManufacturingUsers AS _OpActyAllManufacturingUsers ON OpActyNtwkInstance = _OpActyAllManufacturingUsers.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyAllManufacturingUsers.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OpActyInstceExtdQltyChkGrp AS _OpActyInstceExtdQltyChkGrp ON OpActyNtwkInstance = _OpActyInstceExtdQltyChkGrp.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyInstceExtdQltyChkGrp.OpActyNtwkElement  -- association [0..*]
;