SAP table SETHEADER (Set Header and Directory)

SAP table SETHEADER has 4 primary key fields being MANDT,SETCLASS,SUBCLASS,SETNAME.

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 SETNAMENEW
SETTYPE Set Type CHAR 1 0 STYPE
B Basic set
D Key figure set
M Multi-dimension set
S Single-dimension set
XDYNAMIC Flag: Dynamic Set CHAR 1 0 SETFLGDYN
AUTHGR Authorization group CHAR 4 0 TBRG AUTHGR
XUNIQ X Flag: Must Be Unique CHAR 1 0 SETFLGSUQ
RVALUE Representative Value of a Set CHAR 40 0 SETVALREP
CREUSER Created By CHAR 12 0 CRNAM
CREDATE Creation date DATS 8 0 CRDAT
CRETIME Creation Time TIMS 6 0 CR_TIME
UPDUSER Last Changed By CHAR 12 0 UPNAM
UPDDATE Date on which object was last changed DATS 8 0 UPDAT
UPDTIME Time of last change TIMS 6 0 UP_TIME
SAPRL Release of SAP System CHAR 4 0 SYSAPRL
TABNAME Table Name CHAR 30 0 * TABNAME
FIELDNAME Field Name CHAR 30 0 * FIELDNAME
ROLLNAME Representative Data Element in a Set CHAR 30 0 * SETDTEL_D
SET_OLANGU Original Language for Sets (SAP Internal Only) LANG 1 0 * SET_OLANGU
NO_RWSHEADER No Entries Exist in Table RWSHEADER for This Set CHAR 1 0 SET_NO_RWSHEADER
NO_RWSLINE No Entries Exist in Table RWSLINE for This Set CHAR 1 0 SET_NO_RWSLINE
NO_SETLINET No Entries Exist in Table SETLINET for This Set CHAR 1 0 SET_NO_SETLINET

SETHEADER foreign key relationships

Table Field Check Table Check Field
0 SETHEADER AUTHGR TBRG Authorization groups MANDT
0 SETHEADER AUTHGR TBRG Authorization groups BRGRU
1 SETHEADER SETCLASS SETCLS Set Classes SETCLASS