SAP table SETLEAF (Values in Sets)

SAP table SETLEAF has 5 primary key fields being MANDT,SETCLASS,SUBCLASS,SETNAME,LINEID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

SETLEAF foreign key relationships

Table Field Check Table Check Field
0 SETLEAF SETCLASS SETCLS Set Classes SETCLASS
1 SETLEAF SETNAME SETHEADER Set Header and Directory MANDT
1 SETLEAF SETNAME SETHEADER Set Header and Directory SETCLASS
1 SETLEAF SETNAME SETHEADER Set Header and Directory SETNAME