C_ProcgExecOperationActivity

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_ProcgExecOperationActivity.
-- 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: CMPEOAEXEC

CREATE VIEW C_ProcgExecOperationActivity AS
SELECT
  ProcgExecOperationActivity.OpActyNtwkGroupVersionCounter AS OpActyNtwkGroupVersionCounter,
  ProcgExecOperationActivity.OpActyNtwkGroupExternalID AS OpActyNtwkGroupExternalID,
  _OpActyNtwkGroupText[1: Language=$session.system_language].OpActyNtwkGroupName AS OpActyNtwkGroupName,
  ProcgExecOperationActivity.MfgOrderOperationText AS MfgOrderOperationText,
  ProcgExecOperationActivity.OrderInternalID AS OrderInternalID,
  ProcgExecOperationActivity.OrderOperationInternalID AS OrderOperationInternalID,
  cast(coalesce(ProcgExecOperationActivity._OperationControlProfile.OperationIsReworkOperation, '') as rework preserving type) AS OperationIsReworkOperation,
  ProcgExecOperationActivity.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  ProcgExecOperationActivity.WorkCenterTypeCode AS WorkCenterTypeCode,
  ProcgExecOperationActivity.WorkCenter AS WorkCenter,
  ProcgExecOperationActivity._WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  ProcgExecOperationActivity.Reservation AS Reservation,
  ProcgExecOperationActivity.OrderHeaderProductionPlant AS OrderHeaderProductionPlant,
  ProcgExecOperationActivity.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  ProcgExecOperationActivity.SASStatusCategory AS SASStatusCategory,
  cast(_SASStatusText[1: Language=$session.system_language].SASStatusName as mpe_oa_status_description preserving type) AS SASStatusName,
  ProcgExecOperationActivity.OperationActivity AS OperationActivity,
  ProcgExecOperationActivity.OperationActyVersionCounter AS OperationActyVersionCounter,
  cast(ProcgExecOperationActivity.ProdnProcgIsFlexible as mpe_procg_flexibility_ind preserving type) AS ProdnProcgIsFlexible,
  _ProdnProcgFlexibilityIndTxt[1: Language=$session.system_language].ProdnProcgFlexibilityIndName AS ProdnProcgFlexibilityIndName,
  ProcgExecOperationActivity.ConfirmationSkippedQuantity AS ConfirmationSkippedQuantity,
  ProcgExecOperationActivity.ConfirmationYieldQuantity AS ConfirmationYieldQuantity,
  ProcgExecOperationActivity.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  ProcgExecOperationActivity.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  ProcgExecOperationActivity.NumberOfActiveShopFloorItems AS NumberOfActiveShopFloorItems,
  _OpActyChgAlertAssgmt.OriginalChgAlertCount AS OriginalChgAlertCount,
  cast( '' as boolean preserving type) AS OpActyChgAlertAcknIsRequired,
  ProcgExecOperationActivity.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  ProcgExecOperationActivity.OperationUnit AS OperationUnit,
  ProcgExecOperationActivity.ProductionUnit AS ProductionUnit,
  ProcgExecOperationActivity.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  ProcgExecOperationActivity.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  ProcgExecOperationActivity.OpActyHasAssignedComponents AS OpActyHasAssignedComponents,
  ProcgExecOperationActivity.OpActyHasAssgdWorkInstructions AS OpActyHasAssgdWorkInstructions,
  ProcgExecOperationActivity.OpActyHasAssgdProdnRsceTools AS OpActyHasAssgdProdnRsceTools,
  ProcgExecOperationActivity.OpActyHasAssgdInspCharcs AS OpActyHasAssgdInspCharcs,
  ProcgExecOperationActivity.OpActyHasMandatoryInspCharcs AS OpActyHasMandatoryInspCharcs,
  ProcgExecOperationActivity.MfgQualificationIsRequired AS MfgQualificationIsRequired,
  ProcgExecOperationActivity.OperationExecutionAvailableQty AS OperationExecutionAvailableQty,
  ProcgExecOperationActivity.LaborTrackingIsRequired AS LaborTrackingIsRequired,
  ProcgExecOperationActivity.BillOfMaterialCategory AS BillOfMaterialCategory,
  ProcgExecOperationActivity.BillOfMaterialVariant AS BillOfMaterialVariant,
  ProcgExecOperationActivity.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ProcgExecOperationActivity.BillOfMaterialVersion AS BillOfMaterialVersion,
  ProcgExecOperationActivity.BillOfOperationsType AS BillOfOperationsType,
  ProcgExecOperationActivity.BillOfOperations AS BillOfOperations,
  ProcgExecOperationActivity.BillOfOperationsVariant AS BillOfOperationsVariant,
  ProcgExecOperationActivity.BillOfOperationsVersion AS BillOfOperationsVersion,
  cast(hextobin('00000000000000000000000000000000') as cs_guidb preserving type ) AS BillOfMaterialHeaderUUID,
  cast ('' as sdok_phid) AS PhysicalDocument,
  cast('' as doknr) AS DocumentInfoRecordDocNumber,
  cast('' as doktl_d) AS DocumentInfoRecordDocPart,
  cast('' as dokvr) AS DocumentInfoRecordDocVersion,
  ProcgExecOperationActivity.WorkInstruction AS WorkInstruction,
  ProcgExecOperationActivity.WorkInstructionVersionCounter AS WorkInstructionVersionCounter,
  _MfgWorkInstructionVersionTP.MfgWorkInstructionContent AS MfgWorkInstructionContent,
  _MfgWorkInstructionVersionTP.MfgWorkInstructionMode AS MfgWorkInstructionMode,
  ProcgExecOperationActivity.ProductConfiguration AS ProductConfiguration,
  _UnitizedMaterial.EffectivityType AS EffectivityType,
  cast('' as mpe_effectivity_parameter_desc) AS EffectivityParameterDesc,
  cast('' as mpe_effectivity_parameter_desc) AS EffctyTypeCnctntdParamDesc,
  cast( ' ' as abap.char( 255 ) ) AS NetChangeAnalysisPath,
  cast( ' ' as boole_d preserving type ) AS ChangeImpactRelevanceFlagIsSet,
  cast( ' ' as boole_d preserving type ) AS OperationActivityIsImpacted,
  ProcgExecOperationActivity._BillOfMaterial AS _BillOfMaterial,
  ProcgExecOperationActivity._WorkCenter AS _WorkCenter,
  ProcgExecOperationActivity._WorkCenterType AS _WorkCenterType,
  ProcgExecOperationActivity._Material AS _Material,
  ProcgExecOperationActivity._ProductionPlant AS _ProductionPlant,
  ProcgExecOperationActivity._OrderHeaderProductionPlant AS _OrderHeaderProductionPlant
FROM I_ProcgExecOperationActivity AS ProcgExecOperationActivity
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON WorkCenter = _WorkCenterBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_OANSegmentType AS _OANSegmentType ON OpActyNtwkSegmentType = _OANSegmentType.OpActyNtwkSegmentType  -- association [0..1]
LEFT OUTER JOIN I_SASStatusText AS _SASStatusText ON StatusAndActionSchemaStatus = _SASStatusText.StatusAndActionSchemaStatus  -- association [0..*]
LEFT OUTER JOIN C_SASAction AS _SASAction ON StatusAndActionSchema = _SASAction.StatusAndActionSchema AND StatusAndActionSchemaStatus = _SASAction.SASActionStartStatus AND ProductionPlant = _SASAction.Plant  -- association [0..*]
LEFT OUTER JOIN C_ManufacturingActionSetting AS _ManufacturingActionSetting ON ProductionPlant = _ManufacturingActionSetting.Plant AND _ManufacturingActionSetting.MfgObjectType = '001'  -- association [0..*]
LEFT OUTER JOIN I_OperationActivityText AS _OperationActivityText ON OperationActivity = _OperationActivityText.OperationActivity AND OperationActyVersionCounter = _OperationActivityText.OperationActyVersionCounter  -- association [0..*]
LEFT OUTER JOIN C_OperationActivityComponent AS _OperationActivityComponent ON OpActyNtwkInstance = _OperationActivityComponent.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityComponent.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_OperationActivityPlndMatlRet AS _OperationActivityPlndMatlRet ON OpActyNtwkInstance = _OperationActivityPlndMatlRet.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityPlndMatlRet.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_OpActyChgAlertAssgmt AS _OpActyChgAlertAssgmt ON OperationActivity = _OpActyChgAlertAssgmt.OperationActivity AND OperationActyVersionCounter = _OpActyChgAlertAssgmt.OperationActyVersionCounter  -- association [0..1]
LEFT OUTER JOIN C_OperationActyPRTAssignment AS _OperationActyPRTAssignment ON OpActyNtwkInstance = _OperationActyPRTAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActyPRTAssignment.OpActyNtwkElement AND OrderInternalID = _OperationActyPRTAssignment.OrderInternalID  -- association [0..*]
LEFT OUTER JOIN P_OpActyReasonCodeNoteExists AS _OpActyReasonCodeNoteExists ON OpActyNtwkInstance = _OpActyReasonCodeNoteExists.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyReasonCodeNoteExists.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN P_OpActyConfirmationActionAgg AS _OpActyConfirmationActionAgg ON OpActyNtwkInstance = _OpActyConfirmationActionAgg.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyConfirmationActionAgg.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN P_OpActyNrOfMandComponents AS _OpActyNrOfMandComponents ON OpActyNtwkInstance = _OpActyNrOfMandComponents.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyNrOfMandComponents.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN I_MfgOrdAssldDgtlMockUpInstce AS _MfgOrdAssldDgtlMockUpInstce ON ManufacturingOrder = _MfgOrdAssldDgtlMockUpInstce.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN I_ShopFloorItemAtOpActy AS _ShopFloorItemAtOpActy ON OpActyNtwkInstance = _ShopFloorItemAtOpActy.OpActyNtwkInstance AND OpActyNtwkElement = _ShopFloorItemAtOpActy.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_ActiveShopFloorItemAtOpActy AS _ActiveShopFloorItemAtOpActy ON OpActyNtwkInstance = _ActiveShopFloorItemAtOpActy.OpActyNtwkInstance AND OpActyNtwkElement = _ActiveShopFloorItemAtOpActy.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN P_OperationActivityBuyOffCycle AS _OperationActivityBuyOffCycle ON OpActyNtwkInstance = _OperationActivityBuyOffCycle.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityBuyOffCycle.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN P_OperationActivityBuyOff AS _OperationActivityBuyOff ON OperationActivity = _OperationActivityBuyOff.OperationActivity AND OperationActyVersionCounter = _OperationActivityBuyOff.OperationActyVersionCounter  -- association [0..1]
LEFT OUTER JOIN C_MfgQualifnOpActyAssgmt AS _MfgQualifnOpActyAssgmt ON OpActyNtwkInstance = _MfgQualifnOpActyAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _MfgQualifnOpActyAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_MfgWorkInstructionVersionTP AS _MfgWorkInstructionVersionTP ON WorkInstruction = _MfgWorkInstructionVersionTP.MfgWorkInstruction AND WorkInstructionVersionCounter = _MfgWorkInstructionVersionTP.MfgWorkInstructionVersCounter  -- association [0..1]
LEFT OUTER JOIN C_MfgWorkInstructionVersion AS _MfgWorkInstructionVersion ON WorkInstruction = _MfgWorkInstructionVersion.WorkInstruction AND WorkInstructionVersionCounter = _MfgWorkInstructionVersion.WorkInstructionVersionCounter  -- association [0..*]
LEFT OUTER JOIN I_OpActyNtwkGroupText AS _OpActyNtwkGroupText ON OperationActivityNetworkGroup = _OpActyNtwkGroupText.OperationActivityNetworkGroup AND OpActyNtwkGroupVersionCounter = _OpActyNtwkGroupText.OpActyNtwkGroupVersionCounter  -- association [0..*]
LEFT OUTER JOIN C_OpActyInstanceAssembledComp AS _OpActyInstanceAssembledComp ON ManufacturingOrder = _OpActyInstanceAssembledComp.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN C_MfgOrderDefectRecord AS _MfgOrderDefectRecord ON OpActyNtwkInstance = _MfgOrderDefectRecord.OpActyNtwkInstance AND OpActyNtwkElement = _MfgOrderDefectRecord.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_ProdnProcgFlexibilityIndTxt AS _ProdnProcgFlexibilityIndTxt ON ProdnProcgIsFlexible = _ProdnProcgFlexibilityIndTxt.ProdnProcgIsFlexible  -- association [0..*]
LEFT OUTER JOIN I_ProdMfgInfoCamera AS _ProdMfgInfoCamera ON ProcgExecOperationActivity.OperationActivity = _ProdMfgInfoCamera.OperationActivity AND ProcgExecOperationActivity.OperationActyVersionCounter = _ProdMfgInfoCamera.OperationActyVersionCounter  -- association [0..*]
LEFT OUTER JOIN I_UnitizedMaterial AS _UnitizedMaterial ON Material = _UnitizedMaterial.Material  -- association [0..1]
LEFT OUTER JOIN C_MfgOrdVariantConfiguration AS _MfgOrdVariantConfiguration ON ManufacturingOrder = _MfgOrdVariantConfiguration.ManufacturingOrder  -- association [0..1]
;