I_ATPResultHeader

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_ATPResultHeader.
-- 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: IATPRESULTHEADER

CREATE VIEW I_ATPResultHeader AS
SELECT
  cid AS ATPCheckUUID,
  appid AS TransactionCode,
  variant_uuid AS ABOPVariantUUID,
  variant_name AS ABOPVariantName,
  uname AS StartedByUser,
  time_start AS ATPCheckStartUTCDateTime,
  time_end AS ATPCheckEndUTCDateTime,
  cast(status as atp_process_status) AS ATPCheckStatus,
  master_variant_cid AS ParentATPCheckUUID,
  master_variant_uuid AS ABOPMasterVariantUUID,
  simulation AS ABOPExecutionMode,
  application_log_hndl AS ApplicationLogHandle,
  summary_cid AS ATPCheckSummaryUUID,
  execution_order AS ATPCheckExecutionOrder
FROM atp_result_head
LEFT OUTER JOIN I_ATPResultRequirement AS _Requirements ON ATPCheckUUID = _Requirements.ATPCheckUUID  -- association [0..*]
LEFT OUTER JOIN I_ABOPVariant AS _Variant ON ABOPVariantUUID = _Variant.ABOPVariantUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _StartedByUser ON StartedByUser = _StartedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_ATPResultHeader AS _ParentATPCheck ON ParentATPCheckUUID = _ParentATPCheck.ATPCheckUUID  -- association [0..1]
LEFT OUTER JOIN I_ABOPVariant AS _MasterVariant ON ABOPMasterVariantUUID = _MasterVariant.ABOPVariantUUID  -- association [0..1]
LEFT OUTER JOIN I_ATPResultHeader AS _ATPCheckSummary ON ParentATPCheckUUID = _ATPCheckSummary.ATPCheckUUID  -- association [0..1]
;