ARS_OBJECTS_TO_BE_STABLE

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_OBJECTS_TO_BE_STABLE.
-- 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_OBJ_STBL

CREATE VIEW ARS_OBJECTS_TO_BE_STABLE AS
SELECT
  api.object_type AS object_type,
  object_name
FROM ars_w_api_state AS api
LEFT OUTER JOIN V_ARS_RELEASE_CONTRACT AS _release_contract_text ON _release_contract_text.release_contract = api.compatibility_contract  -- association [0..1]
LEFT OUTER JOIN v_ars_release_state AS _release_state_text ON _release_state_text.state = api.release_state  -- association [0..1]
LEFT OUTER JOIN ars_s_obj_type_t AS _object_type_text ON _object_type_text.object_type = api.object_type AND _object_type_text.sub_object_type = api.sub_object_type AND _object_type_text.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ars_s_obj_type_t AS _english_object_type_text ON _english_object_type_text.object_type = api.object_type AND _english_object_type_text.sub_object_type = api.sub_object_type AND _english_object_type_text.language = 'E'  -- association [0..1]
;