SETHANA_STATUS SAP table for – Status of set hierarchies in HANA

Here we would like to draw your attention to SETHANA_STATUS table in SAP. As we know it is being mainly used with the SAP FI-SL (Special Purpose Ledger in FI) component which is coming under FI module (Financial Accounting). SETHANA_STATUS is a SAP standard transp table used for storing Status of set hierarchies in HANA related data in SAP. It comes under the package GBSE_HANA.

SAP SETHANA_STATUS table

Table SETHANA_STATUS technical data

TableSETHANA_STATUS
Data storingStatus of set hierarchies in HANA
ModuleFI
Sub ModuleFI-SL-SL-MD-SE
SAP PackageGBSE_HANA
Delivery ClassL – Table for storing temporary data
ComponentSAP_FIN
Table CategoryTRANSP

SAP SETHANA_STATUS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in SETHANA_STATUS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SETCLASS : Set class
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SUBCLASS : Organizational Unit as Set Subclass
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • HIERARCHY : Set Name
    Its a key field. Its data type is CHAR (Character String) with field length 24
  • CRTDUSER : User who created hierarchy
    Its data type is CHAR (Character String) with field length 12
  • CRTDDATE : Date hierarchy was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRTDTIME : Time hierarchy was created
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • FULLUSER : User who fully loaded hierarchy
    Its data type is CHAR (Character String) with field length 12
  • FULLDATE : Date hierarchy was fully loaded
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FULLTIME : Time hierarchy was fully loaded
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DLTAUSER : User who delta loaded hierarchy
    Its data type is CHAR (Character String) with field length 12
  • DLTADATE : Date hierarchy was delta loaded
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DLTATIME : Time hierarchy was delta loaded
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • STATUSER : User who activated/de-activated hierarchy
    Its data type is CHAR (Character String) with field length 12
  • STATDATE : Date hierarchy activated/inactivated
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STATTIME : Time hierarchy activated/inactivated
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • STATUS : Synchronization status for hierarchies
    Its data type is CHAR (Character String) with field length 1
  • HIERVIEW : Hierarchy view name
    Its data type is CHAR (Character String) with field length 16
  • HIERTABLE : Hierarchy table name
    Its data type is CHAR (Character String) with field length 16
  • COUNTERNODE : Counter for nodes in hierarchy table
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • COUNTERLEAF : Counter for nodes in hierarchy table
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CURRENTNODES : Number of nodes in hierarchy table
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CURRENTLEAFS : Number of leaves in hierarchy table
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • XNONSTATIC : Hierarchy with non-static components
    Its data type is CHAR (Character String) with field length 1
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.