| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SETCLASS | Set class | nvarchar | 4 | 0 | CHAR | (N' ') | No | SETHANACLASSES | SETCLASS | Allow NULL? |
| 3 | SUBCLASS | Organizational Unit as Set Subclass | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SETSUBCLS | Allow NULL? |
| 4 | HIERARCHY | Set Name | nvarchar | 24 | 0 | CHAR | (N' ') | No | SETHANA_HIER | SETNAMENEW | Allow NULL? |
| 5 | CRTDUSER | User who created hierarchy | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETHANA_CRTD_USER | Allow NULL? |
| 6 | CRTDDATE | Date hierarchy was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SETHANA_CRTD_DATE | Allow NULL? |
| 7 | CRTDTIME | Time hierarchy was created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SETHANA_CRTD_TIME | Allow NULL? |
| 8 | FULLUSER | User who fully loaded hierarchy | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETHANA_FULL_USER | Allow NULL? |
| 9 | FULLDATE | Date hierarchy was fully loaded | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SETHANA_FULL_DATE | Allow NULL? |
| 10 | FULLTIME | Time hierarchy was fully loaded | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SETHANA_FULL_TIME | Allow NULL? |
| 11 | DLTAUSER | User who delta loaded hierarchy | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETHANA_DLTA_USER | Allow NULL? |
| 12 | DLTADATE | Date hierarchy was delta loaded | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SETHANA_DLTA_DATE | Allow NULL? |
| 13 | DLTATIME | Time hierarchy was delta loaded | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SETHANA_DLTA_TIME | Allow NULL? |
| 14 | STATUSER | User who activated/de-activated hierarchy | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETHANA_STAT_USER | Allow NULL? |
| 15 | STATDATE | Date hierarchy activated/inactivated | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SETHANA_STAT_DATE | Allow NULL? |
| 16 | STATTIME | Time hierarchy activated/inactivated | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SETHANA_STAT_TIME | Allow NULL? |
| 17 | STATUS | Synchronization status for hierarchies | char | 1 | 0 | CHAR | (N' ') | Yes | | SETHANA_SYNC_STATUS | Allow NULL? |
| 18 | HIERVIEW | Hierarchy view name | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SETHANA_VIEW | Allow NULL? |
| 19 | HIERTABLE | Hierarchy table name | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | SETHANA_TABLE | Allow NULL? |
| 20 | COUNTERNODE | Counter for nodes in hierarchy table | int | 10 | 0 | INT4 | ((0)) | Yes | | SETHANACOUNTER | Allow NULL? |
| 21 | COUNTERLEAF | Counter for nodes in hierarchy table | int | 10 | 0 | INT4 | ((0)) | Yes | | SETHANACOUNTER | Allow NULL? |
| 22 | CURRENTNODES | Number of nodes in hierarchy table | int | 10 | 0 | INT4 | ((0)) | Yes | | SETHANANODENO | Allow NULL? |
| 23 | CURRENTLEAFS | Number of leaves in hierarchy table | int | 10 | 0 | INT4 | ((0)) | Yes | | SETHANALEAFNO | Allow NULL? |
| 24 | XNONSTATIC | Hierarchy with non-static components | char | 1 | 0 | CHAR | (N' ') | Yes | | SETHANANONSTATIC | Allow NULL? |
