1. Home
  2. Resources
  3. SAP Tables
  4. SETLEAF - Values in Sets

SAP Table SETLEAF

Values in Sets

SETLEAF (Values in Sets) 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 SETLEAF to other SAP tables.

SETLEAF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SETCLASS Set class SETCLASS SETCLS CHAR 4 0
SUBCLASS Organizational Unit as Set Subclass SETSUBCLS CHAR 12 0
SETNAME Set Name SETNAMENEW SETHEADER CHAR 24 0
LINEID Set line counter SETLINE NUMC 10 0
VALSIGN SIGN field in creation of SELECT-OPTIONS tables RALDB_SIGN CHAR 1 0
I Select specified values
E Exclude specified values
VALOPTION OPTION field in structure of SELECT-OPTIONS tables RALDB_OPTI CHAR 2 0
EQ Equal: Single value
NE Not Equal: Everything apart from the specified single value
BT Between: Range of values
NB Not Between: Everything outside the range
LE Less or Equal: Everything <= value in field LOW
GT Greater Than: Everything > value in field LOW
GE Greater or Equal >= value in field LOW
LT Less Than: Everything < value in field LOW
CP Contains Pattern: Masked input: Find pattern
NP Not Contains Pattern: Masked input: Reject pattern
VALFROM From Value SETVALMIN CHAR 24 0
VALTO To value SETVALMAX CHAR 24 0
SEQNR Sequential number of set line SETLNSEQNR INT4 10 0

SETLEAF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SETLEAF MANDT SETLEAF MANDT T000 Clients MANDT
SETLEAF SETCLASS SETLEAF SETCLASS SETCLS Set Classes SETCLASS
SETLEAF SETNAME SETLEAF MANDT SETHEADER Set Header and Directory MANDT
SETLEAF SETNAME SETLEAF SETCLASS SETHEADER Set Header and Directory SETCLASS
SETLEAF SETNAME SETLEAF SUBCLASS SETHEADER Set Header and Directory SUBCLASS
SETLEAF SETNAME SETLEAF SETNAME SETHEADER Set Header and Directory SETNAME