SADL_V_Annotations_RT

DDL: SADL_V_ANNOTATIONS_RT SQL: SADL_V_ANNO_RT Type: view
4 Fields 2 Data Sources

SADL_V_Annotations_RT is a CDS View in SAP S/4HANA. It reads from 2 data sources (snwd_pd, snwd_texts) and exposes 4 fields with key field ID.

Data Sources (2)

SourceAliasJoin Type
snwd_pd Product from
snwd_texts ProductDescription left_outer

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName SADL_V_ANNO_RT view
Search.searchable true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ID snwd_pd product_id Simulated Product ID
Language snwd_texts language Report Text Language
Name snwd_texts text User Group
Description snwd_texts text User Group

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 SADL_V_Annotations_RT.
-- 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: SADL_V_ANNO_RT

CREATE VIEW SADL_V_Annotations_RT AS
SELECT
  Product.product_id AS ID,
  ProductDescription.language AS Language,
  ProductDescription.text AS Name,
  ProductDescription.text AS Description
FROM snwd_pd AS Product
LEFT OUTER JOIN snwd_texts AS ProductDescription ON /* join condition not captured in parsed metadata */
;

Learn More