1. Home
  2. Resources
  3. SAP Tables
  4. DD32S - Search Help Parameter

SAP Table DD32S

Search Help Parameter

DD32S (Search Help Parameter) 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 DD32S to other SAP tables.

DD32S table fields

Field Data element Checktable Datatype Length Decimals
SHLPNAME Name of a Search Help SHLPNAME DD30L CHAR 30 0
FIELDNAME Name of a search help parameter SHLPFIELD CHAR 30 0
AS4LOCAL Activation Status of a Repository Object AS4LOCAL CHAR 1 0
A Entry activated or generated in this form
L Lock entry (first N version)
N Entry edited, but not activated
S Previously active entry, backup copy
T Temporary version when editing
FLPOSITION Position of a search help field SFPOSITION NUMC 4 0
ROLLNAME Assigned data element SHLPSPARDE DD04L CHAR 30 0
SHLPINPUT Flag for IMPORT Parameters for Search Help SHLPINPUT CHAR 1 0
NULL Do not set flag
X Set flag
SHLPOUTPUT Flag for EXPORT Parameters for Search Help SHLPOUTPUT CHAR 1 0
NULL Do not set flag
X Set flag
SHLPSELPOS Position in dialog box of an elementary search help SHLPSELPOS NUMC 2 0
SHLPSELDIS Display field in dialog box of an elementary search help SHLPSELDIS CHAR 1 0
NULL Do not set flag
X Set flag
SHLPLISPOS Position in the hit list of an elementary search help SHLPLISPOS NUMC 2 0
SHLPUPPER Flag: Upper/lower case sensitive MCNOUPPER CHAR 1 0
NULL Do not set flag
X Set flag
DEFAULTVAL Default value for a search help parameter DDSHDEFVAL CHAR 21 0
DEFAULTTYP Default type of a search help parameter DDSHDEFTYP CHAR 1 0
NULL No default
L Literal
S System variable
G GET paramter
SQLTAB Table Name TABNAME DD12L CHAR 30 0
INDEXNAME Unique Index ID in a Table INDEXID CHAR 3 0
DATATYPE Data Type in ABAP Dictionary DATATYPE_D CHAR 4 0
ACCP Posting period YYYYMM
CHAR Character String
CLNT Client
CUKY Currency key, referenced by CURR fields
CURR Currency field, stored as DEC
D16D Decimal Floating Point, 16 Digits, DEC on Database
D16R Decimal Floating Point, 16 Digits, RAW on Database
D16S Decimal Floating Point. 16 Digits, with Scale Field
D34D Decimal Floating Point, 34 Digits, DEC on Database
D34R Decimal Floating Point, 34 Digits, RAW on Database
D34S Decimal Floating Point, 34 Digits, with Scale Field
DATS Date field (YYYYMMDD) stored as char(8)
DEC Counter or amount field with comma and sign
FLTP Floating point number, accurate to 8 bytes
INT1 1-byte integer, integer number <= 255
INT2 2-byte integer, only for length field before LCHR or LRAW
INT4 4-byte integer, integer number with sign
LANG Language key
LCHR Long character string, requires preceding INT2 field
LRAW Long byte string, requires preceding INT2 field
NUMC Character string with only digits
PREC Obsolete data type, do not use
QUAN Quantity field, points to a unit field with format UNIT
RAW Uninterpreted sequence of bytes
RSTR Byte String of Variable Length
SSTR Short Character String of Variable Length
STRG Character String of Variable Length
TIMS Time field (hhmmss), stored as char(6)
UNIT Unit key for QUAN fields
VARC Long character string, no longer supported from Rel. 3.0
LENG Length (No. of Characters) DDLENG NUMC 6 0
DECIMALS Number of Decimal Places DECIMALS NUMC 6 0
ROLLCHANGE Data elem. of parameter indep. of field of selection method DDSHROLLCH CHAR 1 0
NULL Data element coupled to the field of the selection method
X Data element uncoupled from field of the selection method
N No corresponding field of selection method exists

DD32S foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DD32S ROLLNAME DD32S ROLLNAME DD04L Data elements ROLLNAME
DD32S ROLLNAME * DD04L Data elements AS4LOCAL
DD32S ROLLNAME * DD04L Data elements AS4VERS
DD32S SHLPNAME DD32S SHLPNAME DD30L Search helps SHLPNAME
DD32S SHLPNAME * DD30L Search helps AS4LOCAL
DD32S SQLTAB * DD12L R/3 S_SECINDEX: secondary indexes, header; AS4VERS
DD32S SQLTAB DD32S SQLTAB DD12L R/3 S_SECINDEX: secondary indexes, header; SQLTAB
DD32S SQLTAB DD32S INDEXNAME DD12L R/3 S_SECINDEX: secondary indexes, header; INDEXNAME
DD32S SQLTAB 'A' DD12L R/3 S_SECINDEX: secondary indexes, header; AS4LOCAL