sycm_aps_i_atc_fnd

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_i_atc_fnd.
-- 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: SYCMVIATCFND

CREATE VIEW sycm_aps_i_atc_fnd AS
SELECT
  latest_atc_result_for_project.project_id AS project_id,
  finding_v.item_id AS item_id,
  header.display_id AS display_id,
  finding.module_ix AS module_ix,
  finding.message_ix AS message_ix,
  object.obj_type AS obj_type,
  object.obj_name AS obj_name,
  osy.package_name AS package_name,
  cast(finding_v.priority as sycm_aps_atc_priority preserving type) AS priority,
  osy.comp_short AS comp_short,
  cast( coalesce( ltrim(note.value, '0') , 'N/A' ) as abap.char( 10 )) AS note_number
FROM sycm_aps_i_atc_result_latest AS latest_atc_result_for_project
INNER JOIN satc_ac_resulth AS header ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_fnd_v AS finding_v ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_fnd AS finding ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_obj AS object ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_osy AS osy ON /* join condition not captured in parsed metadata */
INNER JOIN satc_ac_itm AS item ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sycm_aps_i_atc_attributes AS note ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sycm_aps_i_atc_attributes AS _ref_obj_type ON _ref_obj_type.item_id = item_id AND _ref_obj_type.name = 'REF_OBJ_TYPE'  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_attributes AS _ref_obj_name ON _ref_obj_name.item_id = item_id AND _ref_obj_name.name = 'REF_OBJ_NAME'  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_attributes AS _app_component ON _app_component.item_id = item_id AND _app_component.name = 'APPLICATION_COMPONENT'  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_attributes AS _sitem_state ON _sitem_state.item_id = item_id AND _sitem_state.name = 'SITEM_STATE'  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_attributes AS _change_category ON _change_category.item_id = item_id AND _change_category.name = 'CHANGE_CATEGORY'  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_attributes AS _additional_information ON _additional_information.item_id = item_id AND _additional_information.name = 'ADD_INFO'  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_note_url AS _note_url ON _note_url.note = note_number  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_msg_text_distin AS _check_title ON _check_title.module_ix = module_ix AND _check_title.message_ix = 0  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_msg_text_distin AS _check_message ON _check_message.module_ix = module_ix AND _check_message.message_ix = message_ix  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_note_text AS _note_title ON _note_title.note_number = note_number  -- association [0..1]
LEFT OUTER JOIN satc_ac_chm AS _check_class ON _check_class.module_ix = module_ix  -- association [0..1]
LEFT OUTER JOIN satc_ac_cmm AS _message_id ON _message_id.module_ix = module_ix AND _message_id.message_ix = message_ix  -- association [0..1]
;