P_Cfd_C0_Registrations_CDS_Ext

DDL: P_CFD_C0_REGISTRATIONS_CDS_EXT SQL: CFD_C0_REG_CEXT Type: view

Custom Fields: Registered Ext. Include

P_Cfd_C0_Registrations_CDS_Ext is a CDS View that provides data about "Custom Fields: Registered Ext. Include" in SAP S/4HANA. It reads from 3 data sources (ddldependency, P_Cfd_C0_Registrations_CDS_Rel, P_Cfd_C0_Registrations_CDS_COn) and exposes 4 fields with key fields tadir_object, object_type, object_key. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
ddldependency _stobDependency left_outer
P_Cfd_C0_Registrations_CDS_Rel is_released left_outer
P_Cfd_C0_Registrations_CDS_COn lastChangedOn inner

Associations (2)

CardinalityTargetAliasCondition
[1] P_Cfd_C0_Registrations_CDS_CBC lastChangedByCount lastChangedByCount.extension_incl_view_name = context.extension_incl_view_name and lastChangedByCount.last_changed_on = lastChangedOn.last_changed_on
[1] P_Cfd_C0_Registrations_CDS_CBy lastChangedBy lastChangedBy.extension_incl_view_name = context.extension_incl_view_name and lastChangedBy.last_changed_on = lastChangedOn.last_changed_on

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName CFD_C0_REG_CEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Custom Fields: Registered Ext. Include view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY tadir_object
KEY object_type
KEY object_key context extension_incl_view_name Extension Incl. View
changed_on P_Cfd_C0_Registrations_CDS_COn last_changed_on Time Stamp

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 P_Cfd_C0_Registrations_CDS_Ext.
-- 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: CFD_C0_REG_CEXT

CREATE VIEW P_Cfd_C0_Registrations_CDS_Ext AS
SELECT
  'DDLS' AS tadir_object,
  'CDS_STOB' AS object_type,
  context.extension_incl_view_name AS object_key,
  lastChangedOn.last_changed_on AS changed_on
LEFT OUTER JOIN P_Cfd_C0_Registrations_CDS_Rel AS is_released ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddldependency AS _stobDependency ON /* join condition not captured in parsed metadata */
INNER JOIN P_Cfd_C0_Registrations_CDS_COn AS lastChangedOn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Cfd_C0_Registrations_CDS_CBC AS lastChangedByCount ON lastChangedByCount.extension_incl_view_name = context.extension_incl_view_name AND lastChangedByCount.last_changed_on = lastChangedOn.last_changed_on  -- association [1]
LEFT OUTER JOIN P_Cfd_C0_Registrations_CDS_CBy AS lastChangedBy ON lastChangedBy.extension_incl_view_name = context.extension_incl_view_name AND lastChangedBy.last_changed_on = lastChangedOn.last_changed_on  -- association [1]
;