SETHANA_STATUS SAP (Status of set hierarchies in HANA) Table details
Dictionary Type: Table
Description: Status of set hierarchies in HANA
Description: Status of set hierarchies in HANA
ABAP Code to SELECT data from SETHANA_STATUS
Related tables to SETHANA_STATUS
Access table SETHANA_STATUS
Related tables to SETHANA_STATUS
Access table SETHANA_STATUS
Table field list including key, data, relationships and ABAP select examples
SETHANA_STATUS is a standard SAP Table which is used to store Status of set hierarchies in HANA data and is available within R/3 SAP systems depending on the version and release level.
The SETHANA_STATUS table consists of various fields, each holding specific information or linking keys about Status of set hierarchies in HANA data available in SAP. These include SETCLASS (Set class), SUBCLASS (Organizational Unit as Set Subclass), HIERARCHY (Set Name), CRTDUSER (User who created hierarchy).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP SETHANA_STATUS table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| SETCLASS | Set class | SETCLASS | CHAR | 4 | SETHANACLASSES | SETCLASS | GSC | ||
| SUBCLASS | Organizational Unit as Set Subclass | SETSUBCLS | CHAR | 12 | SETSUBCLS | ||||
| HIERARCHY | Set Name | SETNAMENEW | CHAR | 24 | SETHANA_HIER | SETNAME | GSE | ||
| CRTDUSER | User who created hierarchy | SETHANA_CRTD_USER | CHAR | 12 | USNAM | ||||
| CRTDDATE | Date hierarchy was created | SETHANA_CRTD_DATE | DATS | 8 | DATUM | ||||
| CRTDTIME | Time hierarchy was created | SETHANA_CRTD_TIME | TIMS | 6 | TIME | ||||
| FULLUSER | User who fully loaded hierarchy | SETHANA_FULL_USER | CHAR | 12 | USNAM | ||||
| FULLDATE | Date hierarchy was fully loaded | SETHANA_FULL_DATE | DATS | 8 | DATUM | ||||
| FULLTIME | Time hierarchy was fully loaded | SETHANA_FULL_TIME | TIMS | 6 | TIME | ||||
| DLTAUSER | User who delta loaded hierarchy | SETHANA_DLTA_USER | CHAR | 12 | USNAM | ||||
| DLTADATE | Date hierarchy was delta loaded | SETHANA_DLTA_DATE | DATS | 8 | DATUM | ||||
| DLTATIME | Time hierarchy was delta loaded | SETHANA_DLTA_TIME | TIMS | 6 | TIME | ||||
| STATUSER | User who activated/de-activated hierarchy | SETHANA_STAT_USER | CHAR | 12 | USNAM | ||||
| STATDATE | Date hierarchy activated/inactivated | SETHANA_STAT_DATE | DATS | 8 | DATUM | ||||
| STATTIME | Time hierarchy activated/inactivated | SETHANA_STAT_TIME | TIMS | 6 | TIME | ||||
| STATUS | Synchronization status for hierarchies | SETHANA_SYNC_STATUS | CHAR | 1 | SETHANA_SYNC_STATUS | ||||
| HIERVIEW | Hierarchy view name | SETHANA_VIEW | CHAR | 16 | DBOBJ_NAME | ||||
| HIERTABLE | Hierarchy table name | SETHANA_TABLE | CHAR | 16 | DBOBJ_NAME | ||||
| COUNTERNODE | Counter for nodes in hierarchy table | SETHANACOUNTER | INT4 | 10 | SETHANACOUNTER | ||||
| COUNTERLEAF | Counter for nodes in hierarchy table | SETHANACOUNTER | INT4 | 10 | SETHANACOUNTER | ||||
| CURRENTNODES | Number of nodes in hierarchy table | SETHANANODENO | INT4 | 10 | SETHANACOUNTER | ||||
| CURRENTLEAFS | Number of leaves in hierarchy table | SETHANALEAFNO | INT4 | 10 | SETHANACOUNTER | ||||
| XNONSTATIC | Hierarchy with non-static components | SETHANANONSTATIC | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table SETHANA_STATUS using ABAP code
The following ABAP code Example will allow you to do a basic selection on SETHANA_STATUS to SELECT all data from the tableDATA: WA_SETHANA_STATUS TYPE SETHANA_STATUS.
SELECT SINGLE *
FROM SETHANA_STATUS
INTO CORRESPONDING FIELDS OF WA_SETHANA_STATUS
WHERE...
How to access SAP table SETHANA_STATUS
Within an ECC or HANA version of SAP you can also view further information about SETHANA_STATUS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects