ARS_V_API_VERSION_CURRENT

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 ARS_V_API_VERSION_CURRENT.
-- 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: ARS_V_APIV_CURR

CREATE VIEW ARS_V_API_VERSION_CURRENT AS
SELECT
  api_id,
  coalesce(inactive_version.version, active_version.version) AS version
FROM ars_w_apiv AS api_version
LEFT OUTER JOIN ars_w_apiv AS active_version ON active_version.api_id = api_version.api_id AND active_version.major_release = api_version.major_release AND active_version.minor_release = api_version.minor_release AND active_version.version = #AS4LOCAL.'A'  -- association [0..1]
LEFT OUTER JOIN ars_w_apiv AS inactive_version ON inactive_version.api_id = api_version.api_id AND inactive_version.major_release = api_version.major_release AND inactive_version.minor_release = api_version.minor_release AND inactive_version.version = #AS4LOCAL.'N'  -- association [0..1]
;