| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SETCLASS | Set class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | SUBCLASS | Organizational Unit as Set Subclass | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | HIERARCHY | Set Name | nvarchar | 24 | 0 | | | | Allow NULL? |
| 5 | CRTDUSER | User who created hierarchy | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | CRTDDATE | Date hierarchy was created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | CRTDTIME | Time hierarchy was created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 8 | FULLUSER | User who fully loaded hierarchy | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | FULLDATE | Date hierarchy was fully loaded | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | FULLTIME | Time hierarchy was fully loaded | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | DLTAUSER | User who delta loaded hierarchy | nvarchar | 12 | 0 | | | | Allow NULL? |
| 12 | DLTADATE | Date hierarchy was delta loaded | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DLTATIME | Time hierarchy was delta loaded | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | STATUSER | User who activated/de-activated hierarchy | nvarchar | 12 | 0 | | | | Allow NULL? |
| 15 | STATDATE | Date hierarchy activated/inactivated | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | STATTIME | Time hierarchy activated/inactivated | nvarchar | 6 | 0 | | | | Allow NULL? |
| 17 | STATUS | Synchronization status for hierarchies | char | 1 | 0 | | | | Allow NULL? |
| 18 | HIERVIEW | Hierarchy view name | nvarchar | 16 | 0 | | | | Allow NULL? |
| 19 | HIERTABLE | Hierarchy table name | nvarchar | 16 | 0 | | | | Allow NULL? |
| 20 | COUNTERNODE | Counter for nodes in hierarchy table | int | 10 | 0 | | | | Allow NULL? |
| 21 | COUNTERLEAF | Counter for nodes in hierarchy table | int | 10 | 0 | | | | Allow NULL? |
| 22 | CURRENTNODES | Number of nodes in hierarchy table | int | 10 | 0 | | | | Allow NULL? |
| 23 | CURRENTLEAFS | Number of leaves in hierarchy table | int | 10 | 0 | | | | Allow NULL? |
| 24 | XNONSTATIC | Hierarchy with non-static components | char | 1 | 0 | | | | Allow NULL? |
