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.

Source: SETLEAF (Values in Sets)

SETLEAF table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MANDT

Client

MANDT

T000

CLNT

SETCLASS

Set class

SETCLASS

SETCLS

CHAR

SUBCLASS

Organizational Unit as Set Subclass

SETSUBCLS

CHAR

SETNAME

Set Name

SETNAMENEW

SETHEADER

CHAR

LINEID

Set line counter

SETLINE

NUMC

VALSIGN

SIGN field in creation of SELECT-OPTIONS tables

RALDB_SIGN

CHAR

Possible values

I	Select specified values
E	Exclude specified values

VALOPTION

OPTION field in structure of SELECT-OPTIONS tables

RALDB_OPTI

CHAR

Possible values

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

VALTO

To value

SETVALMAX

CHAR

SEQNR

Sequential number of set line

SETLNSEQNR

INT4

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