SETHANA_STATUS - Status of set hierarchies in HANA
Status of set hierarchies in HANA information is stored in SAP table SETHANA_STATUS.
It is part of development package GBSE_HANA in software component FI-SL-SL-MD-SE. This development package consists of objects that can be grouped under "HANA extensions for Set Hierarchies".
It is part of development package GBSE_HANA in software component FI-SL-SL-MD-SE. This development package consists of objects that can be grouped under "HANA extensions for Set Hierarchies".
Fields for table SETHANA_STATUS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| SETCLASS | Set Class | X | SETCLASS | CHAR | 8 | SETHANACLASSES |
| SUBCLASS | Organizational Unit as Set Subclass | X | SETSUBCLS | CHAR | 24 | |
| HIERARCHY | Set Name | X | SETNAMENEW | CHAR | 48 | SETHANA_HIER |
| CRTDUSER | User who created hierarchy | SETHANA_CRTD_USER | CHAR | 24 | ||
| CRTDDATE | Date hierarchy was created | SETHANA_CRTD_DATE | DATS | 16 | ||
| CRTDTIME | Time hierarchy was created | SETHANA_CRTD_TIME | TIMS | 12 | ||
| FULLUSER | User who fully loaded hierarchy | SETHANA_FULL_USER | CHAR | 24 | ||
| FULLDATE | Date hierarchy was fully loaded | SETHANA_FULL_DATE | DATS | 16 | ||
| FULLTIME | Time hierarchy was fully loaded | SETHANA_FULL_TIME | TIMS | 12 | ||
| DLTAUSER | User who delta loaded hierarchy | SETHANA_DLTA_USER | CHAR | 24 | ||
| DLTADATE | Date hierarchy was delta loaded | SETHANA_DLTA_DATE | DATS | 16 | ||
| DLTATIME | Time hierarchy was delta loaded | SETHANA_DLTA_TIME | TIMS | 12 | ||
| STATUSER | User who activated/de-activated hierarchy | SETHANA_STAT_USER | CHAR | 24 | ||
| STATDATE | Date hierarchy activated/inactivated | SETHANA_STAT_DATE | DATS | 16 | ||
| STATTIME | Time hierarchy activated/inactivated | SETHANA_STAT_TIME | TIMS | 12 | ||
| STATUS | Synchronization status for hierarchies | SETHANA_SYNC_STATUS | CHAR | 2 | ||
| HIERVIEW | Hierarchy view name | SETHANA_VIEW | CHAR | 32 | ||
| HIERTABLE | Hierarchy table name | SETHANA_TABLE | CHAR | 32 | ||
| COUNTERNODE | Counter for nodes in hierarchy table | SETHANACOUNTER | INT4 | 4 | ||
| COUNTERLEAF | Counter for nodes in hierarchy table | SETHANACOUNTER | INT4 | 4 | ||
| CURRENTNODES | Number of nodes in hierarchy table | SETHANANODENO | INT4 | 4 | ||
| CURRENTLEAFS | Number of leaves in hierarchy table | SETHANALEAFNO | INT4 | 4 | ||
| XNONSTATIC | Hierarchy with non-static components | SETHANANONSTATIC | CHAR | 2 |