sdsh_cds_assigned_search_helps

DDL: SDSH_CDS_ASSIGNED_SEARCH_HELPS Type: view_entity Package: SDSH
4 Fields 2 Data Sources

Search helps of a collective search help

sdsh_cds_assigned_search_helps is a CDS View that provides data about "Search helps of a collective search help" in SAP S/4HANA. It reads from 2 data sources (dd30l, dd31s) and exposes 4 fields. Part of development package SDSH.

Data Sources (2)

SourceAliasJoin Type
dd30l dd30l inner
dd31s dd31s from

Annotations (1)

NameValueLevelField
EndUserText.label Search helps of a collective search help view

Fields (4)

KeyFieldSource TableSource FieldDescription
shlpname dd31s shlpname SearchHelpName
subshlp dd31s subshlp Incl.SearchHelp
shposition dd31s shposition Position number of an included search help
autosuggest dd30l autosuggest Autosuggest

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 sdsh_cds_assigned_search_helps.
-- 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.

CREATE VIEW sdsh_cds_assigned_search_helps AS
SELECT
  dd31s.shlpname AS shlpname,
  dd31s.subshlp AS subshlp,
  dd31s.shposition AS shposition,
  dd30l.autosuggest AS autosuggest
FROM dd31s
INNER JOIN dd30l ON /* join condition not captured in parsed metadata */
;

Learn More