sycm_aps_c_check_failure

DDL: SYCM_APS_C_CHECK_FAILURE SQL: SYCMVCHECKFAIL Type: view Package: SYCM_APS

ATC check failures

sycm_aps_c_check_failure is a CDS View that provides data about "ATC check failures" in SAP S/4HANA. It reads from 4 data sources (satc_ac_resultp, satc_ac_resultp, SYCM_APS_I_ATC_REF_LATEST, sycm_aps_i_atc_result_latest) and exposes 12 fields with key fields project_id, obj_type, obj_name, module_id, message_key. Part of development package SYCM_APS.

Data Sources (4)

SourceAliasJoin Type
satc_ac_resultp check_failures from
satc_ac_resultp check_failures union_all
SYCM_APS_I_ATC_REF_LATEST latest_reference inner
sycm_aps_i_atc_result_latest latest_result inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SYCMVCHECKFAIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ATC check failures view
Metadata.allowExtensions true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY project_id project_id Project UUID
KEY obj_type obj_type Type
KEY obj_name obj_name Object Name
KEY module_id module_id Module Key
KEY message_key message_key Message key
check_title
KEY obj_type obj_type Type
KEY obj_name obj_name Object Name
KEY module_id module_id Module Key
KEY message_key message_key Message key
check_title
message

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_check_failure.
-- 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: SYCMVCHECKFAIL

CREATE VIEW sycm_aps_c_check_failure AS
SELECT
  project_id,
  obj_type,
  obj_name,
  module_id,
  message_key,
  cast('' as sycm_aps_check_title) AS check_title,
  cast( '' as sycm_aps_log_message ) AS message
FROM satc_ac_resultp AS check_failures
INNER JOIN sycm_aps_i_atc_result_latest AS latest_result ON /* join condition not captured in parsed metadata */
INNER JOIN SYCM_APS_I_ATC_REF_LATEST AS latest_reference ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): satc_ac_resultp
;