SAP Table SHLP_DESCR

Description of Search Help

SHLP_DESCR (Description of Search Help) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SHLP_DESCR to other SAP tables.

SHLP_DESCR table fields

Field Data element Checktable Datatype Length Decimals
SHLPNAME Name of a Search Help SHLPNAME CHAR 30 0
SHLPTYPE Type of an input help (see fixed values) DDSHLPTYP CHAR 2 0
SH Search help
CH Check table
CT Check table with text table
FV Fixed values for domains
DV Fixed values from flow logic
CA Calendar help
CL Time help
SR Search help for data element (temporary)
MC Matchcode
MI Matchcode ID
IN Internal Table
INTDESCR SHLP_INTDS STRU 0 0
ISSIMPLE Flag if a search help is an elementary search help DDSHSIMPLE CHAR 1 0
NULL FALSE
X TRUE
HOTKEY Hot key for a search help DDSHHOTKEY CHAR 1 0
SELMTYPE Cat. of selection method of an elementary search help SELMTYPE CHAR 1 0
NULL No selection method
T Selection from table
X Selection from table with text table
V Selection from DB view or projection view
H Selection with a help view
F Selection by function module
SELMETHOD Selection method of an elementary search help SELMETHOD CHAR 30 0
TEXTTAB Text table for selection method SELMETHTXT CHAR 30 0
SELMEXIT Search help exit DDSHSELEXT CHAR 30 0
DIALOGTYPE Dialog type DDSHDIATYP CHAR 1 0
DDLANGUAGE Language Key DDLANGUAGE LANG 1 0
DDTEXT Explanatory short text DDTEXT CHAR 60 0
DIALOGINFO CHAR 1 0
F4STATE CHAR 1 0
TABNAME Table Name TABNAME CHAR 30 0
FIELDNAME Field Name FIELDNAME CHAR 30 0
TITLE Explanatory short text DDTEXT CHAR 60 0
HISTORY CHAR 1 0
HANDLE INT4 10 0
AUTOSUGGEST Proposal Search for Input Fields DDAUTOSUGGEST CHAR 1 0
NULL Off
X On
M On, over several columns
FUZZY_SEARCH Full Text Fuzzy Search DDFUZZY_SEARCH CHAR 1 0
NULL Fuzzy search off
X Fuzzy search on
FUZZY_SIMILARITY Accuracy Value for Error-Tolerant Full Text Search DDFUZZY_SIMILARITY DEC 2 1
0 Value range for similarity for fuzzy search
INTERFACE DDSHIFACES TTYP 0 0
FIELDDESCR DDFIELDS TTYP 0 0
FIELDPROP DDSHFPROPS TTYP 0 0
SELOPT DDSHSELOPS TTYP 0 0
TEXTSEARCH DDSHTEXTSEARCH STRU 0 0
REQUEST Dictionary Search Help: Text Search Request DDSH_TEXTSEARCH_REQUEST CHAR 60 0
FIELDS DDSH_TEXTSEARCH_FIELDS TTYP 0 0