sycm_aps_c_scp_by_ep_e

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 sycm_aps_c_scp_by_ep_e.
-- 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 sycm_aps_c_scp_by_ep_e AS
SELECT
  scope.project_id AS project_id,
  scope.last_used AS last_used,
  scope.h_index AS h_index
FROM sycm_aps_i_scp_by_ep AS scope
LEFT OUTER JOIN sycm_aps_i_scp_info_text AS _scope_text ON _scope_text.scope_information = scope_information  -- association [1]
LEFT OUTER JOIN sycm_aps_c_scp_by_ep_item_e AS _object ON _object.project_id = scope.project_id AND _object.entry_point_type = scope.entry_point_type AND _object.entry_point_name = scope.entry_point_name  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_usage_by_procedure AS _procedure ON _procedure.project_id = scope.project_id AND _procedure.entry_point_type = scope.entry_point_type AND _procedure.entry_point_name = scope.entry_point_name  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_atc_fnd_by_ep AS _finding ON _finding.project_id = scope.project_id AND _finding.entry_point_type = scope.entry_point_type AND _finding.entry_point_name = scope.entry_point_name  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_sap_objects_usage AS _sap_object ON _sap_object.project_id = scope.project_id AND _sap_object.entry_point_name = scope.entry_point_name AND _sap_object.entry_point_type = scope.entry_point_type  -- association [0..*]
;