SATC_API_RESULT_HEADERS_BASE

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 SATC_API_RESULT_HEADERS_BASE.
-- 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 SATC_API_RESULT_HEADERS_BASE AS
SELECT
  ATCResultHeaders.display_id AS ResultId,
  ATCResultHeaders.title AS Title,
  ATCResultHeaders.count_prio1 AS CountPrio1,
  ATCResultHeaders.count_prio2 AS CountPrio2,
  ATCResultHeaders.count_prio3 AS CountPrio3,
  ATCResultHeaders.count_prio4 AS CountPrio4,
  ATCResultHeaders.count_plnerr AS CountCheckFailure,
  ATCResultHeaders.scheduled_sys AS ScheduledSystemId,
  ATCResultHeaders.scheduled_clt AS ScheduledClient,
  ATCResultHeaders.scheduled_by AS ScheduledBy,
  ATCResultHeaders.scheduled_on_ts AS ScheduledOnTimestamp,
  ATCResultHeaders.proj_id AS ProjectId,
  ATCResultHeaders.exec_id AS ExecutionId,
  ATCResultHeaders.valid_to AS ValidToTimestamp,
  ATCResultHeaders.is_complete AS IsComplete,
  ATCResultHeaders.is_transient AS IsTransient,
  ATCResultHeaders.is_mass_test AS IsMassTest,
  ATCResultHeaders.is_central_run AS IsCentralRun,
  ATCResultHeaders.is_composite AS IsComposite,
  ATCResultHeaders.is_reworked AS IsReworked,
  ATCResultHeaders.is_imported AS IsImported,
  case when ATCResultHeaders.display_id = ActiveResults.display_id then 'X' else '' end AS IsActiveResult,
  case when ATCResultHeaders.display_id = BaselineResults.display_id then 'X' else '' end AS IsInBaseline,
  case when ATCResultHeaders.display_id = BaselineResults.display_id then BaselineResults.created_by else '' end AS AddedToBaselineBy,
  ATCResultHeaders.chk_profile_name AS CheckVariant,
  ATCResultHeaders.configuration AS Configuration,
  ATCResultHeaders.run_series_name AS RunSeries,
  ATCResultHeaders.mode_fndng_xmptd_in_code AS PseudoCommentPragmaHandling,
  ATCResultHeaders.update_on AS ChangedOnTimestamp,
  ATCResultHeaders.data_source_id AS ObjectProvider,
  ATCResultHeaders.annotation AS ResultAnnotation,
  ATCResultHeaders.check_run_ix AS CheckRunIndex,
  ATCResultHeaders.raw_data_ix AS RawDataIndex,
  ATCResultHeaders.system_ix AS SystemIndex,
  _system_info.system_id AS SystemId,
  _system_info.unique_system_id AS UniqueSystemId
FROM satc_ac_resulth AS ATCResultHeaders
LEFT OUTER JOIN satc_ac_act_res AS ActiveResults ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN satc_ac_bsh AS BaselineResults ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN satc_ac_sys AS _system_info ON SystemIndex = _system_info.system_ix  -- association [0..1]
;