sycm_aps_c_project

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_project.
-- 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: SYCMVCPROJECT

CREATE VIEW sycm_aps_c_project AS
SELECT
  project_id,
  description,
  request,
  _user.user_description AS created_by,
  projects.created_at AS created_at,
  project_type,
  _atc_run_state.s4h_state AS s4h_state,
  _atc_run_state.s4h_total AS s4h_total,
  _atc_run_state.s4h_failed AS s4h_failed,
  _field_control.s4h_disabled AS s4h_disabled,
  _field_control.cca_disabled AS cca_disabled,
  _log_handle.log_handle AS log_handle
FROM sycm_aps_i_project AS projects
LEFT OUTER JOIN sycm_aps_i_scp_for_project AS _number_all_objects ON _number_all_objects.project_id = projects.project_id AND _number_all_objects.type = 'A'  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_scp_for_project AS _number_scoped_objects ON _number_scoped_objects.project_id = projects.project_id AND _number_scoped_objects.type = 'S'  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_run_state AS _atc_run_state ON _atc_run_state.project_id = projects.project_id  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_fnd_by_project AS _number_findings ON _number_findings.project_id = project_id  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_project_log_handle AS _log_handle ON _log_handle.project_id = project_id  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_prj_field_control AS _field_control ON _field_control.project_id = project_id  -- association [0..1]
LEFT OUTER JOIN sycm_aps_c_target_release_vh AS _target_release_vh ON _target_release_vh.target_release = target_release  -- association [0..1]
LEFT OUTER JOIN sycm_aps_c_trans_scenario_vh AS _trans_scenario_vh ON _trans_scenario_vh.transition_scenario = transition_scenario  -- association [0..1]
LEFT OUTER JOIN sycm_aps_c_object_provider_vh AS _object_provider_vh ON _object_provider_vh.data_source_id = object_provider_id  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_project_status AS _project_status_text ON _project_status_text.project_status = project_status  -- association [0..1]
LEFT OUTER JOIN sycm_aps_c_request_text AS _request_text ON _request_text.request = request  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_chk_kind_ce_vh AS _atc_check_kind_vh ON _atc_check_kind_vh.atc_check_kind = atc_check_kind  -- association [0..1]
LEFT OUTER JOIN sycm_aps_c_atc_check_kind_text AS _atc_check_kind_text ON _atc_check_kind_text.atc_check_kind = atc_check_kind  -- association [0..1]
LEFT OUTER JOIN sycm_aps_c_project_type_vh AS _project_type_vh ON _project_type_vh.project_type = project_type  -- association [0..1]
LEFT OUTER JOIN satc_ci_chkv_value_help_cust AS _check_variant_vh ON _check_variant_vh.checkvariant = check_variant  -- association [0..1]
LEFT OUTER JOIN sycm_aps_c_prj_usg AS _prj_usg ON _prj_usg.project_id = project_id  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_atc_package_include AS _atc_package_include ON _atc_package_include.project_id = project_id  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_atc_package_exclude AS _atc_package_exclude ON _atc_package_exclude.project_id = project_id  -- association [0..*]
LEFT OUTER JOIN sycm_aps_i_prj_nspace AS _nspace ON _nspace.project_id = project_id  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_scp_overview AS _scope_overview ON _scope_overview.project_id = project_id  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_atc_overview_s4h AS _analysis_overview_s4h ON _analysis_overview_s4h.project_id = project_id  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_log AS _log ON _log.project_id = project_id  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_check_failure AS _check_failures ON _check_failures.project_id = project_id  -- association [0..*]
LEFT OUTER JOIN sycm_aps_c_atc_burndown AS _fnd_burndown ON _fnd_burndown.run_series_name = atc_run_series  -- association [0..*]
LEFT OUTER JOIN sycm_aps_i_user AS _user ON _user.UserID = projects.created_by  -- association [0..1]
;