SYCM_APS_PROJECT

DDL: SYCM_APS_PROJECT Type: view_entity
2 Fields 1 Data Sources 2 Associations

CCM Projects

SYCM_APS_PROJECT is a CDS View that provides data about "CCM Projects" in SAP S/4HANA. It reads from 1 data source (sycma_project) and exposes 2 fields with key field project_id. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
sycma_project sycma_project from

Associations (2)

CardinalityTargetAliasCondition
[0..*] SATC_API_RESULT_HEADERS _atc_result_headers _atc_result_headers.RunSeries = $projection.atc_run_series
[0..*] SYCM_APS_ATC_FINDINGS _latest_atc_findings _latest_atc_findings.project_id = $projection.project_id

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label CCM Projects view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY project_id project_id Project UUID
description description Well Code Des.

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_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.

CREATE VIEW SYCM_APS_PROJECT AS
SELECT
  project_id,
  description
FROM sycma_project
LEFT OUTER JOIN SATC_API_RESULT_HEADERS AS _atc_result_headers ON _atc_result_headers.RunSeries = atc_run_series  -- association [0..*]
LEFT OUTER JOIN SYCM_APS_ATC_FINDINGS AS _latest_atc_findings ON _latest_atc_findings.project_id = project_id  -- association [0..*]
;

Learn More