C_ProcgExecOpActyInstceTP_2

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_2.
-- 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 C_ProcgExecOpActyInstceTP_2 AS
SELECT
  OpActyNtwkInstance,
  OpActyNtwkElement,
  OperationActivityNetwork,
  OpActyNtwkVersionCounter,
  ConfirmationScrapQuantity,
  ConfirmationSkippedQuantity,
  ConfirmationYieldQuantity,
  OpPlannedScrapQuantity,
  OpPlannedYieldQuantity,
  ProductionUnit,
  OpActyExpdExecutionDuration,
  OpActyExpdExecutionLaborDurn,
  DurationUnit,
  OpActyExpdExecDurnInSeconds,
  OpActyExpdExecLaborDurnInSecs,
  OrderInternalID,
  OrderOperationInternalID,
  StatusAndActionSchema,
  StatusAndActionSchemaStatus,
  _SASStatus._Text[1: Language=$session.system_language].SASStatusName AS StatusName,
  OpActyConfIsSFIBased,
  cast( OpActyNtwkElementExternalID as mpe_oa_number_ext preserving type ) AS OpActyNtwkElementExternalID,
  _OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OperationActivity,
  OperationActyVersionCounter,
  OpActyNtwkElementElement,
  OpActyNtwkElementElmntVersCntr,
  OpActyNtwkSegmentType,
  _OANSegmentType._Text[1: Language=$session.system_language].OpActyNtwkSegmentTypeText AS OpActyNtwkSegmentTypeText,
  OANElementDisplaySqncNumber,
  SASStatusCriticality,
  SASStatusCategory,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  OpLtstSchedldExecStrtDteTme,
  DateIsActualDate,
  OperationActivityNetworkGroup,
  OpActyNtwkGroupVersionCounter,
  OpActyNtwkGroupExternalID,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ManufacturingOrderImportance,
  MfgOrderOperationText,
  MfgOrderOperationOrSubOp,
  _WorkCenterTextBySemanticKey[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  LaborTrackingIsRequired,
  OpPlannedTotalQuantity,
  OperationUnit,
  NrOfOpActyUserAssignments,
  UserID,
  UserDescription,
  NrOfOpActyTeamAssignments,
  RespyMgmtTeamID,
  TeamName,
  OpActyHasMissingComponents,
  virtual OpActyHasTeamAssignments : xfeld AS virtualOpActyHasTeamAssignmentsxfeld,
  virtual OpActyHasUserAssignments : xfeld AS virtualOpActyHasUserAssignmentsxfeld,
  OperationExecutionAvailableQty,
  ProductionHold,
  ManufacturingActionReasonCode,
  MfgActionReasonCodeGroup,
  MfgActionReasonCodeGroupCtlg,
  MfgActionReasonCodeName,
  EffectivityParameterDesc,
  WorkInstructionVersionCounter
FROM R_ProcgExecOpActyInstceTP
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_MfgQualifnOpActyAssgmt AS _MfgQualifnOpActyAssgmt ON OpActyNtwkInstance = _MfgQualifnOpActyAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _MfgQualifnOpActyAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_MfgOrderDefectRecord AS _MfgOrderDefectRecord ON OpActyNtwkInstance = _MfgOrderDefectRecord.OpActyNtwkInstance AND OpActyNtwkElement = _MfgOrderDefectRecord.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OpActyAllManufacturingUsers AS _OpActyAllManufacturingUsers ON OpActyNtwkInstance = _OpActyAllManufacturingUsers.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyAllManufacturingUsers.OpActyNtwkElement  -- association [0..*]
;