sycm_aps_i_sap_objects

DDL: SYCM_APS_I_SAP_OBJECTS SQL: SYCMVISAPOBJ Type: view

All customer objects

sycm_aps_i_sap_objects is a CDS View that provides data about "All customer objects" in SAP S/4HANA. It reads from 2 data sources (sycma_prj_nspace, sycma_tadir_d) and exposes 8 fields with key fields project_id, object, obj_name. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
sycma_prj_nspace nspace left_outer
sycma_tadir_d tadir from

Associations (1)

CardinalityTargetAliasCondition
[1..1] sycm_aps_i_enh_mod_text _enh_or_mod_text _enh_or_mod_text.enh_or_mod = $projection.enh_or_mod

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SYCMVISAPOBJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label All customer objects view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY project_id sycma_tadir_d project_id Project UUID
KEY object sycma_tadir_d object TRFM Object
KEY obj_name sycma_tadir_d obj_name Object Name
author sycma_tadir_d author User Name
devclass sycma_tadir_d devclass Package (Obsolete)
genflag sycma_tadir_d genflag Generation Flag
modifiedflag sycma_tadir_d modifiedflag is modified SAP
parentcl sycma_tadir_d parentcl Superpackage

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_sap_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: SYCMVISAPOBJ

CREATE VIEW sycm_aps_i_sap_objects AS
SELECT
  tadir.project_id AS project_id,
  tadir.object AS object,
  tadir.obj_name AS obj_name,
  tadir.author AS author,
  tadir.devclass AS devclass,
  tadir.genflag AS genflag,
  tadir.modifiedflag AS modifiedflag,
  tadir.parentcl AS parentcl
FROM sycma_tadir_d AS tadir
LEFT OUTER JOIN sycma_prj_nspace AS nspace ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sycm_aps_i_enh_mod_text AS _enh_or_mod_text ON _enh_or_mod_text.enh_or_mod = enh_or_mod  -- association [1..1]
;