sycm_aps_c_atc_find_alp

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_atc_find_alp.
-- 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: SYCMVCATCFNDALP

CREATE VIEW sycm_aps_c_atc_find_alp AS
SELECT
  finding.item_id AS item_id,
  finding.project_id AS project_id,
  finding.display_id AS display_id,
  finding.priority AS priority,
  finding.check_title AS check_title,
  finding.obj_type AS obj_type,
  finding.obj_name AS obj_name,
  finding.package_name AS package_name,
  finding.note_number AS note_number,
  finding.note_title AS note_title,
  check_class,
  message_id,
  finding.counter_fnd AS counter_fnd,
  finding.link_to_note AS link_to_note
FROM sycm_aps_i_atc_find_alp AS finding
LEFT OUTER JOIN sycm_aps_c_alp_usage_vh AS _usage_info_text ON _usage_info_text.usage_information = finding.usage_information  -- association [1]
LEFT OUTER JOIN sycm_aps_c_alp_scope_vh AS _scope_info_text ON _scope_info_text.scope_information = finding.scope_information  -- association [1]
LEFT OUTER JOIN sycm_aps_c_alp_sitem_vh AS _sitem_state_text ON _sitem_state_text.sitem_state = finding.simplification_item_state  -- association [1]
LEFT OUTER JOIN sycm_aps_c_alp_change_categ_vh AS _change_category_text ON _change_category_text.change_category = finding.change_category  -- association [1]
LEFT OUTER JOIN sycm_aps_c_alp_quickfix_vh AS _has_quickfixes ON _has_quickfixes.has_quickfixes = finding.has_quickfixes  -- association [1]
LEFT OUTER JOIN sycma_fnd_urls AS _link_to_source_code ON _link_to_source_code.project_id = project_id AND _link_to_source_code.item_id = item_id  -- association [1]
LEFT OUTER JOIN sycm_aps_i_atc_message_detail AS _check_message_detail ON _check_message_detail.item_id = item_id AND _check_message_detail.project_id = project_id AND _check_message_detail.display_id = display_id  -- association [1]
;