DDLA_RT_ANNOS_FILTERED

DDL: DDLA_RT_ANNOS_FILTERED SQL: SDDLA_ANNOS_FIL Type: view Package: SDDIC_DDLA_RT

DDLA_RT_ANNOS filtered by DDLA_HIDDEN

DDLA_RT_ANNOS_FILTERED is a CDS View that provides data about "DDLA_RT_ANNOS filtered by DDLA_HIDDEN" in SAP S/4HANA. It reads from 3 data sources (ddla_hidden, ddla_rt_annos, ddla_rt_header) and exposes 5 fields. Part of development package SDDIC_DDLA_RT.

Data Sources (3)

SourceAliasJoin Type
ddla_hidden ddla_hidden left_outer
ddla_rt_annos ddla_rt_annos inner
ddla_rt_header ddla_rt_header from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SDDLA_ANNOS_FIL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label DDLA_RT_ANNOS filtered by DDLA_HIDDEN view

Fields (5)

KeyFieldSource TableSource FieldDescription
ddlaname ddla_rt_header ddlaname Name of DDLA Source
key_upper ddla_rt_header key_upper DD: Key/Name for Annotation
key_raw ddla_rt_header key_raw DD: Key/Name for Annotation
path ddla_rt_annos path Path rule
value ddla_rt_annos value Value from table

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 DDLA_RT_ANNOS_FILTERED.
-- 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: SDDLA_ANNOS_FIL

CREATE VIEW DDLA_RT_ANNOS_FILTERED AS
SELECT
  ddla_rt_header.ddlaname AS ddlaname,
  ddla_rt_header.key_upper AS key_upper,
  ddla_rt_header.key_raw AS key_raw,
  ddla_rt_annos.path AS path,
  ddla_rt_annos.value AS value
FROM ddla_rt_header
LEFT OUTER JOIN ddla_hidden ON /* join condition not captured in parsed metadata */
INNER JOIN ddla_rt_annos ON /* join condition not captured in parsed metadata */
;