SAP table SETNODE (Lower-level sets in sets)
SAP table SETNODE 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 | ||
| SUBSETCLS | Class of a Subordinate Set | CHAR | 4 | 0 | SETCLS | SUBSETCLS | |
| SUBSETSCLS | Subclass of a Subordinate Set | CHAR | 12 | 0 | SUBSETSCLS | ||
| SUBSETNAME | Subordinate Set ID | CHAR | 24 | 0 | SETHEADER | SUBSETNAME | |
| SEQNR | Sequential Number of Set Line | INT4 | 10 | 0 | SETLNSEQNR |
SETNODE foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 SETNODE | SETCLASS | SETCLS | Set Classes | SETCLASS |
| 1 SETNODE | SETNAME | SETHEADER | Set Header and Directory | MANDT |
| 1 SETNODE | SETNAME | SETHEADER | Set Header and Directory | SETCLASS |
| 1 SETNODE | SETNAME | SETHEADER | Set Header and Directory | SETNAME |
| 0 SETNODE | SUBSETCLS | SETCLS | Set Classes | SETCLASS |
| 1 SETNODE | SUBSETNAME | SETHEADER | Set Header and Directory | MANDT |
| 1 SETNODE | SUBSETNAME | SETHEADER | Set Header and Directory | SETCLASS |
| 1 SETNODE | SUBSETNAME | SETHEADER | Set Header and Directory | SETNAME |