1. SAP Tutorial
  2. FI Module

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

    • SETHANA_STATUS related tables

    • SETHANA_HIER : Status of set hierarchies in HANA
    • HDB_SETNODE : Node view for SLT hierarchy replication
    • HDB_SETLEAF1 : Leaf view for SLT hierarchy replication (primary)
    • SETHANAHIER0109 : Hierarchy table for Account Groups
    • HDB_SETLEAF2 : Leaf view for SLT hierarchy replication (secondary)
    • SETHANAHIER0102 : Hierarchy table for Cost Element Groups
    • SETHANACLASSES : Hierarchy classes with HANA acceleleration
    • SETHANAHIER0106 : Hierarchy table for Profit Center Groups
    • SETHANAHIER0103 : Hierarchy table for Order Groups
    • SETHANAHIER0101 : Hierarchy table for Cost Center Groups
    • SETHANA_HVIEW__T : Generation template for HANA hierarchy views
    • SETHANA_STATUS : Status of set hierarchies in HANA

    SETHANA_STATUS related transaction codes under SAP package GBSE_HANA

    • SETHANA_ACTIVATOR : Activation of HANA set hierarchies
    • HDBHIER : Maintain set hierarchies for HDB

    Related References

    Related Tutorials

    SETHANA_HIER SAP table for – Status of set hierarchies in HANA

    SETHANA_HIER table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Status...

    SETHANA_ACTIVATOR SAP tcode for – Activation of HANA set hierarchies

    SETHANA_ACTIVATOR tcode in SAP FI (Special Purpose Ledger in FI) module. This transaction code is used for Activation of HANA...

    SETHANA_HVIEW__T SAP table for – Generation template for HANA hierarchy views

    SETHANA_HVIEW__T table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Generation...

    SETHANACLASSES SAP table for – Hierarchy classes with HANA acceleleration

    SETHANACLASSES table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Hierarchy...

    HDBHIER SAP tcode for – Maintain set hierarchies for HDB

    HDBHIER tcode in SAP FI (Special Purpose Ledger in FI) module. This transaction code is used for Maintain set hierarchies...

    SETHANAHIER0102 SAP table for – Hierarchy table for Cost Element Groups

    SETHANAHIER0102 table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Hierarchy...

    SETHANAHIER0103 SAP table for – Hierarchy table for Order Groups

    SETHANAHIER0103 table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Hierarchy...

    «
    »