sycm_atc_export_findings

DDL: SYCM_ATC_EXPORT_FINDINGS SQL: SYCM_ATC_FND Type: view
9 Fields 1 Data Sources 6 Associations

ATC fidings for ATC export

sycm_atc_export_findings is a CDS View that provides data about "ATC fidings for ATC export" in SAP S/4HANA. It reads from 1 data source (satc_Ac_Rstis_Ddlv) and exposes 9 fields with key fields item_id, display_id. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
satc_Ac_Rstis_Ddlv finding from

Associations (6)

CardinalityTargetAliasCondition
[0..1] SATC_AC_ATT_VAL_DDLV _note finding.item_id = _note.item_id and _note.name = 'NOTE'
[0..1] SATC_AC_ATT_VAL_DDLV _ref_obj_type _ref_obj_type.item_id = finding.item_id and _ref_obj_type.name = 'REF_OBJ_TYPE'
[0..1] SATC_AC_ATT_VAL_DDLV _ref_obj_name _ref_obj_name.item_id = finding.item_id and _ref_obj_name.name = 'REF_OBJ_NAME'
[0..1] SATC_AC_ATT_VAL_DDLV _sitem_state _sitem_state.item_id = finding.item_id and _sitem_state.name = 'SITEM_STATE'
[0..1] satc_ac_chm _check_class _check_class.module_id = finding.module_id and _check_class.module_ix = finding.module_ix
[0..1] sycm_aps_i_atc_find_alp ccm_findings finding.item_id = ccm_findings.item_id

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SYCM_ATC_FND view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ATC fidings for ATC export view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY item_id satc_Ac_Rstis_Ddlv item_id Simulation Item ID
KEY display_id satc_Ac_Rstis_Ddlv display_id Display ID
obj_name satc_Ac_Rstis_Ddlv obj_name Object Name
obj_type satc_Ac_Rstis_Ddlv obj_type Type
package_name satc_Ac_Rstis_Ddlv package_name Package Name
priority satc_Ac_Rstis_Ddlv priority Workflow priority
note
check_class _check_class ci_id Check Class
message_code satc_Ac_Rstis_Ddlv module_msg_key Message Code

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_atc_export_findings.
-- 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: SYCM_ATC_FND

CREATE VIEW sycm_atc_export_findings AS
SELECT
  finding.item_id AS item_id,
  finding.display_id AS display_id,
  finding.obj_name AS obj_name,
  finding.obj_type AS obj_type,
  finding.package_name AS package_name,
  finding.priority AS priority,
  cast ( _note.value as abap.numc( 10 ) ) AS note,
  _check_class.ci_id AS check_class,
  finding.module_msg_key AS message_code
FROM satc_Ac_Rstis_Ddlv AS finding
LEFT OUTER JOIN SATC_AC_ATT_VAL_DDLV AS _note ON finding.item_id = _note.item_id AND _note.name = 'NOTE'  -- association [0..1]
LEFT OUTER JOIN SATC_AC_ATT_VAL_DDLV AS _ref_obj_type ON _ref_obj_type.item_id = finding.item_id AND _ref_obj_type.name = 'REF_OBJ_TYPE'  -- association [0..1]
LEFT OUTER JOIN SATC_AC_ATT_VAL_DDLV AS _ref_obj_name ON _ref_obj_name.item_id = finding.item_id AND _ref_obj_name.name = 'REF_OBJ_NAME'  -- association [0..1]
LEFT OUTER JOIN SATC_AC_ATT_VAL_DDLV AS _sitem_state ON _sitem_state.item_id = finding.item_id AND _sitem_state.name = 'SITEM_STATE'  -- association [0..1]
LEFT OUTER JOIN satc_ac_chm AS _check_class ON _check_class.module_id = finding.module_id AND _check_class.module_ix = finding.module_ix  -- association [0..1]
LEFT OUTER JOIN sycm_aps_i_atc_find_alp AS ccm_findings ON finding.item_id = ccm_findings.item_id  -- association [0..1]
;

Learn More