SAP Table
SETHEADER Set Header and Directory
SAP table SETHEADER has 4 primary key fields being MANDT,SETCLASS,SUBCLASS,SETNAME.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
SETHEADER columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeySETCLASS | Set Class | CHAR | 4 | 0 | SETCLS | SETCLASS | |||||||||
| KeySUBCLASS | Organizational Unit as Set Subclass | CHAR | 12 | 0 | SETSUBCLS | ||||||||||
| KeySETNAME | Set Name | CHAR | 24 | 0 | SETNAMENEW | ||||||||||
| SETTYPE | Set Type | CHAR | 1 | 0 | STYPE | ||||||||||
|
|||||||||||||||
| 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 | ||||||||||