P_Domain_texts

DDL: P_DOMAIN_TEXTS SQL: PDDTEXTS Type: view BASIC
4 Fields 1 Data Sources

P_Domain_texts is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 4 fields.

Data Sources (1)

SourceAliasJoin Type
dd07t domain_texts from

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PDDTEXTS view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
domname dd07t domname Domain
ddlanguage dd07t ddlanguage Lang.
domain_val dd07t domvalue_l Lower Value
ddtext dd07t ddtext Short text

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_Domain_texts.
-- 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: PDDTEXTS

CREATE VIEW P_Domain_texts AS
SELECT
  domain_texts.domname AS domname,
  domain_texts.ddlanguage AS ddlanguage,
  domain_texts.domvalue_l AS domain_val,
  domain_texts.ddtext AS ddtext
FROM dd07t AS domain_texts
;

Learn More