SAP ABAP Table SETHANA_STATUS (Status of set hierarchies in HANA)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-SL-SL-MD-SE (Application Component) Sets
     ⤷ GBSE_HANA (Package) HANA extensions for Set Hierarchies

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SETHANA_STATUS	Table Relationship Diagram
Short Description	Status of set hierarchies in HANA

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SETCLASS	☑	SETCLASS	SETCLASS	CHAR	4	0	Set class	SETHANACLASSES
3	SUBCLASS	☑	SETSUBCLS	SETSUBCLS	CHAR	12	0	Organizational Unit as Set Subclass
4	HIERARCHY	☑	SETNAMENEW	SETNAME	CHAR	24	0	Set Name	SETHANA_HIER
5	CRTDUSER	☐	SETHANA_CRTD_USER	USNAM	CHAR	12	0	User who created hierarchy
6	CRTDDATE	☐	SETHANA_CRTD_DATE	DATUM	DATS	8	0	Date hierarchy was created
7	CRTDTIME	☐	SETHANA_CRTD_TIME	TIME	TIMS	6	0	Time hierarchy was created
8	FULLUSER	☐	SETHANA_FULL_USER	USNAM	CHAR	12	0	User who fully loaded hierarchy
9	FULLDATE	☐	SETHANA_FULL_DATE	DATUM	DATS	8	0	Date hierarchy was fully loaded
10	FULLTIME	☐	SETHANA_FULL_TIME	TIME	TIMS	6	0	Time hierarchy was fully loaded
11	DLTAUSER	☐	SETHANA_DLTA_USER	USNAM	CHAR	12	0	User who delta loaded hierarchy
12	DLTADATE	☐	SETHANA_DLTA_DATE	DATUM	DATS	8	0	Date hierarchy was delta loaded
13	DLTATIME	☐	SETHANA_DLTA_TIME	TIME	TIMS	6	0	Time hierarchy was delta loaded
14	STATUSER	☐	SETHANA_STAT_USER	USNAM	CHAR	12	0	User who activated/de-activated hierarchy
15	STATDATE	☐	SETHANA_STAT_DATE	DATUM	DATS	8	0	Date hierarchy activated/inactivated
16	STATTIME	☐	SETHANA_STAT_TIME	TIME	TIMS	6	0	Time hierarchy activated/inactivated
17	STATUS	☐	SETHANA_SYNC_STATUS	SETHANA_SYNC_STATUS	CHAR	1	0	Synchronization status for hierarchies
18	HIERVIEW	☐	SETHANA_VIEW	DBOBJ_NAME	CHAR	16	0	Hierarchy view name
19	HIERTABLE	☐	SETHANA_TABLE	DBOBJ_NAME	CHAR	16	0	Hierarchy table name
20	COUNTERNODE	☐	SETHANACOUNTER	SETHANACOUNTER	INT4	10	0	Counter for nodes in hierarchy table
21	COUNTERLEAF	☐	SETHANACOUNTER	SETHANACOUNTER	INT4	10	0	Counter for nodes in hierarchy table
22	CURRENTNODES	☐	SETHANANODENO	SETHANACOUNTER	INT4	10	0	Number of nodes in hierarchy table
23	CURRENTLEAFS	☐	SETHANALEAFNO	SETHANACOUNTER	INT4	10	0	Number of leaves in hierarchy table
24	XNONSTATIC	☐	SETHANANONSTATIC	XFELD	CHAR	1	0	Hierarchy with non-static components

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SETHANA_STATUS	HIERARCHY	SETHANA_HIER	HIERARCHY	KEY	1	C
2	SETHANA_STATUS	SETCLASS	SETHANACLASSES	HIERCLASS

History

Last changed by/on	SAP	20130529
SAP Release Created in	606