DEMO_CDS_GUID_HIERA_SOURCE

DDL: DEMO_CDS_GUID_HIERA_SOURCE SQL: DEMOGHIERASOURCE Type: view
4 Fields 1 Data Sources 1 Associations

DEMO_CDS_GUID_HIERA_SOURCE is a CDS View in SAP S/4HANA. It reads from 1 data source (demo_guid_hiera) and exposes 4 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
demo_guid_hiera demo_guid_hiera from

Associations (1)

CardinalityTargetAliasCondition
[1..*] DEMO_CDS_GUID_HIERA_SOURCE _relat $projection.parent = _relat.id

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName DEMOGHIERASOURCE view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (4)

KeyFieldSource TableSource FieldDescription
_relat _relat
id id WorklistID
parent parent_id UUID
field field Logical Field

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 DEMO_CDS_GUID_HIERA_SOURCE.
-- 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: DEMOGHIERASOURCE

CREATE VIEW DEMO_CDS_GUID_HIERA_SOURCE AS
SELECT
  id,
  parent_id AS parent,
  field
FROM demo_guid_hiera
LEFT OUTER JOIN DEMO_CDS_GUID_HIERA_SOURCE AS _relat ON parent = _relat.id  -- association [1..*]
;

Learn More