I_OperationActivity

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 I_OperationActivity.
-- 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: IMPEOA

CREATE VIEW I_OperationActivity AS
SELECT
  OperationActivity.id AS OperationActivity,
  OperationActivity.version_no AS OperationActyVersionCounter,
  OperationActivity.activity_sasname AS OperationActStsAndActnSchema,
  OperationActivity.sfi_sasname AS SFIStatusAndActionSchema,
  OperationActivity.process_sequence AS AssemblySqncCheckIsRequired,
  OperationActivity.released AS IsReleased,
  OperationActivity.extended_quality_checks AS OpActyInspectionRelevance,
  OperationActivity.original_count AS OriginalChgAlertCount,
  OperationActivity.source_oa_id AS SourceOperationActivity,
  OperationActivity.source_group_id AS SourceOperationActivityGroup,
  OperationActivity.plnty_reft AS ShopFloorRtgTmplTaskListType,
  OperationActivity.plnnr_reft AS ShopFloorRtgTemplateGroup,
  OperationActivity.plnal_reft AS ShopFloorRtgTemplateGrpVariant,
  OperationActivity.versn_reft AS ShopFloorRtgTemplateVersion,
  OperationActivity.created_by AS CreatedByUser,
  OperationActivity.created_at AS CreationDateTime,
  OperationActivity.changed_by AS ChangedBy,
  OperationActivity.changed_at AS LastChangeDateTime
FROM mpe_oa AS OperationActivity
LEFT OUTER JOIN I_OperationActivityInternalID AS _OperationActivityInternalId ON OperationActivity = _OperationActivityInternalId.OperationActivity  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityText AS _Text ON OperationActivity = _Text.OperationActivity AND OperationActyVersionCounter = _Text.OperationActyVersionCounter  -- association [0..*]
LEFT OUTER JOIN I_SASOperationActivityVH AS _SASOpAct ON OperationActStsAndActnSchema = _SASOpAct.StatusAndActionSchema  -- association [1..1]
LEFT OUTER JOIN I_SASShopFloorItemOpActyVH AS _SASShopFloorItemOpAct ON SFIStatusAndActionSchema = _SASShopFloorItemOpAct.StatusAndActionSchema  -- association [1..1]
LEFT OUTER JOIN E_OperationActivity AS _Extension ON OperationActivity = _Extension.OperationActivity AND OperationActyVersionCounter = _Extension.OperationActyVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsVersion AS _ReferenceTemplateGroup ON ShopFloorRtgTmplTaskListType = _ReferenceTemplateGroup.BillOfOperationsType AND ShopFloorRtgTemplateGroup = _ReferenceTemplateGroup.BillOfOperationsGroup AND ShopFloorRtgTemplateGrpVariant = _ReferenceTemplateGroup.BillOfOperationsVariant AND ShopFloorRtgTemplateVersion = _ReferenceTemplateGroup.BillOfOperationsVersion  -- association [0..1]
;