Ars_Ship_Version_Information

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_Ship_Version_Information.
-- 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: ARSV_SHIP_INFO

CREATE VIEW Ars_Ship_Version_Information AS
SELECT
  api_root.object_type AS object_type,
  api_root.object_name AS object_name,
  snapshot.sw_component AS sw_component,
  snapshot.saprelease AS saprelease,
  snapshot.sp_level AS sp_level,
  snapshot.created_at AS created_at,
  api_node AS to_api_node
FROM ars_ship_api AS api_root
INNER JOIN ars_ship_snap AS snapshot ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ars_ship_node AS api_node ON api_root.api_version_uuid = api_node.api_version_uuid  -- association [1]
;