ATOV_NAMESPACE_SETTINGS

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 ATOV_NAMESPACE_SETTINGS.
-- 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: ATOV_NSP_SET

CREATE VIEW ATOV_NAMESPACE_SETTINGS AS
SELECT
  dev_prefix AS namespace,
  'LOCAL_SYSTEM' AS tenant_id,
  category,
  created_by,
  created_at,
  description
FROM ato_prefix_set AS settings
LEFT OUTER JOIN ato_setup AS setup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_PREFIX_CATEGORY_TEXT AS _category_description ON _category_description.value = settings.category AND _category_description.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ATOV_PREFIX_CATEGORY_TEXT AS _english_category_description ON _english_category_description.value = settings.category AND _english_category_description.language = 'E'  -- association [0..1]
LEFT OUTER JOIN ATOV_USER AS _created_by ON _created_by.name = settings.created_by  -- association [0..1]
LEFT OUTER JOIN ATOV_USER AS _last_changed_by ON _last_changed_by.name = settings.last_changed_by  -- association [0..1]
LEFT OUTER JOIN ATOV_USER_ASSIGNMENT AS _user_assignment ON _user_assignment.namespace = namespace  -- association [0..*]
LEFT OUTER JOIN ATOV_USER_ASSIGNMENT AS _self_assignment ON _self_assignment.user_id = $session.user  -- association [0..1]
LEFT OUTER JOIN ATOV_INSTALLATION_KEY_LOG AS _installation_file_log ON _installation_file_log.namespace = namespace  -- association [0..*]
LEFT OUTER JOIN atov_prefix_adapt_type_support AS _adaptation_type_support ON _adaptation_type_support.Namespace = namespace  -- association [0..*]
-- UNION with additional select branch(es): ATOV_PK_NAMESPACE
;