sycm_aps_i_scp_cust_objects

DDL: SYCM_APS_I_SCP_CUST_OBJECTS SQL: SYCMVISCPCUST Type: view
8 Fields 3 Data Sources

Customer objects with scope information

sycm_aps_i_scp_cust_objects is a CDS View that provides data about "Customer objects with scope information" in SAP S/4HANA. It reads from 3 data sources (sycma_prj_nspace, sycm_aps_i_scp, sycma_tadir_d) and exposes 8 fields with key fields project_id, object, obj_name.

Data Sources (3)

SourceAliasJoin Type
sycma_prj_nspace nspace inner
sycm_aps_i_scp scope from
sycma_tadir_d tadir inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SYCMVISCPCUST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customer objects with scope information view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY project_id sycm_aps_i_scp project_id Project UUID
KEY object sycm_aps_i_scp object TRFM Object
KEY obj_name sycm_aps_i_scp obj_name Object Name
devclass sycm_aps_i_scp devclass Package (Obsolete)
author sycm_aps_i_scp author User Name
_entry_point _entry_point
_findings _findings
_scope_text _scope_text

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_scp_cust_objects.
-- 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: SYCMVISCPCUST

CREATE VIEW sycm_aps_i_scp_cust_objects AS
SELECT
  scope.project_id AS project_id,
  scope.object AS object,
  scope.obj_name AS obj_name,
  scope.devclass AS devclass,
  scope.author AS author
FROM sycm_aps_i_scp AS scope
INNER JOIN sycma_tadir_d AS tadir ON /* join condition not captured in parsed metadata */
INNER JOIN sycma_prj_nspace AS nspace ON /* join condition not captured in parsed metadata */
;

Learn More