C_ProcgExecOperationActyList

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_ProcgExecOperationActyList.
-- 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: CMPEOALIST

CREATE VIEW C_ProcgExecOperationActyList AS
SELECT
  ProcgExecOperationActivity.OpActyNtwkInstance AS OpActyNtwkInstance,
  ProcgExecOperationActivity.OpActyNtwkElement AS OpActyNtwkElement,
  $session.system_language AS Language,
  ProcgExecOperationActivity.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  _OANSegmentType._Text[1: Language=$session.system_language].OpActyNtwkSegmentTypeText AS OpActyNtwkSegmentTypeText,
  ProcgExecOperationActivity.OANElementDisplaySqncNumber AS OANElementDisplaySqncNumber,
  ProcgExecOperationActivity.ProductionPlant AS ProductionPlant,
  ProcgExecOperationActivity.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  _OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  ProcgExecOperationActivity.OperationActivityNetworkGroup AS OperationActivityNetworkGroup,
  ProcgExecOperationActivity.OperationActivity AS OperationActivity,
  LogisticsOrder.InspectionLot AS InspectionLot,
  ProcgExecOperationActivity.OpActyNtwkGroupVersionCounter AS OpActyNtwkGroupVersionCounter,
  ProcgExecOperationActivity.OperationActyVersionCounter AS OperationActyVersionCounter,
  ProcgExecOperationActivity.OpActyNtwkGroupExternalID AS OpActyNtwkGroupExternalID,
  ProcgExecOperationActivity.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  ProcgExecOperationActivity.MfgOrderOperationText AS MfgOrderOperationText,
  ProcgExecOperationActivity.OrderInternalID AS OrderInternalID,
  ProcgExecOperationActivity.OperationUnit AS OperationUnit,
  ProcgExecOperationActivity.ProductionUnit AS ProductionUnit,
  ProcgExecOperationActivity.OpActyHasAssignedComponents AS OpActyHasAssignedComponents,
  ProcgExecOperationActivity.OpActyHasAssgdWorkInstructions AS OpActyHasAssgdWorkInstructions,
  ProcgExecOperationActivity.OpActyHasAssgdProdnRsceTools AS OpActyHasAssgdProdnRsceTools,
  ProcgExecOperationActivity.OpActyHasAssgdInspCharcs AS OpActyHasAssgdInspCharcs,
  ProcgExecOperationActivity.OpActyHasMandatoryInspCharcs AS OpActyHasMandatoryInspCharcs,
  ProcgExecOperationActivity.ManufacturingOrder AS ManufacturingOrder,
  _MfgOrder.Material AS Material,
  _MfgOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ProcgExecOperationActivity.WorkCenter AS WorkCenter,
  ProcgExecOperationActivity._WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  ProcgExecOperationActivity.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  cast(_SASStatusText[1: Language=$session.system_language].SASStatusName as mpe_oa_status_description preserving type) AS SASStatusName,
  ProcgExecOperationActivity.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  ProcgExecOperationActivity.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  ProcgExecOperationActivity.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  ProcgExecOperationActivity.WorkInstruction AS WorkInstruction,
  ProcgExecOperationActivity.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  ProcgExecOperationActivity.BillOfOperations AS BillOfOperations,
  ProcgExecOperationActivity.BillOfOperationsVariant AS BillOfOperationsVariant,
  ProcgExecOperationActivity.BillOfOperationsVersion AS BillOfOperationsVersion,
  ProcgExecOperationActivity.BOOOperationInternalID AS BOOOperationInternalID,
  '' AS MfgWorkInstructionContent
FROM I_ProcgExecOperationActivity AS ProcgExecOperationActivity
LEFT OUTER JOIN I_LogisticsOrder AS LogisticsOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_OperationActyComponentList AS _OperationActivityComponent ON OpActyNtwkInstance = _OperationActivityComponent.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityComponent.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OpActyInstcePlndInspCharc AS _InspCharc ON OpActyNtwkInstance = _InspCharc.OpActyNtwkInstance AND OpActyNtwkElement = _InspCharc.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_OperationActivityText AS _OperationActivityText ON OperationActivity = _OperationActivityText.OperationActivity AND OperationActyVersionCounter = _OperationActivityText.OperationActyVersionCounter  -- association [0..*]
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_OpActyInstcePlndPRTNoDoc AS _OpActyInstcePlndPRTNoDoc ON OpActyNtwkInstance = _OpActyInstcePlndPRTNoDoc.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyInstcePlndPRTNoDoc.OpActyNtwkElement AND OrderInternalID = _OpActyInstcePlndPRTNoDoc.OrderInternalID  -- association [0..*]
LEFT OUTER JOIN C_OpActyInstcePlndComponent AS _OpActyInstcePlndComponent ON OpActyNtwkInstance = _OpActyInstcePlndComponent.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyInstcePlndComponent.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OpActyInstcePlndCompDsassy AS _OpActyInstcePlndCompDsassy ON OpActyNtwkInstance = _OpActyInstcePlndCompDsassy.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyInstcePlndCompDsassy.OpActyNtwkElement  -- association [0..*]
;