P_MDQltyModelTblFldSrchHelps

DDL: P_MDQLTYMODELTBLFLDSRCHHELPS SQL: PMMODTABFLDSH Type: view BASIC Package: MDQ_PF_DATA_MODEL_COMMON
7 Fields 4 Data Sources

MDQ Search Helps for Table and Field

P_MDQltyModelTblFldSrchHelps is a Basic CDS View that provides data about "MDQ Search Helps for Table and Field" in SAP S/4HANA. It reads from 4 data sources (dd04l, dd30l, dd30l, dd35l) and exposes 7 fields. Part of development package MDQ_PF_DATA_MODEL_COMMON.

Data Sources (4)

SourceAliasJoin Type
dd04l dd04l inner
dd30l dd30l inner
dd30l dd30l union
dd35l dd35l from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMODTABFLDSH view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (7)

KeyFieldSource TableSource FieldDescription
shlpname dd30l shlpname SearchHelpName
autosuggest dd30l autosuggest Autosuggest
tabname dd35l tabname Table/Constant Value
shlpname SearchHelpName
autosuggest dd30l autosuggest Autosuggest
tabname dd03l tabname Table/Constant Value
fieldname dd03l fieldname UI Group FieldName

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_MDQltyModelTblFldSrchHelps.
-- 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: PMMODTABFLDSH

CREATE VIEW P_MDQltyModelTblFldSrchHelps AS
SELECT
  dd30l.shlpname AS shlpname,
  dd30l.autosuggest AS autosuggest,
  dd35l.tabname AS tabname,
  dd03l.fieldname AS fieldname
FROM dd35l
INNER JOIN dd30l ON /* join condition not captured in parsed metadata */
INNER JOIN dd04l ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): dd30l
;

Learn More