SAP ABAP View SETHANA_STATUS_V (Administrate HDB hierarchy views)

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

View Type	C	Maintenance View
Maintenance View	SETHANA_STATUS_V
Short Description	Administrate HDB hierarchy views
Root table	SETHANA_HIER	Status of set hierarchies in HANA

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SETHANA_HIER	SETHANA_HIER
2	SETHANA_STATUS	SETHANA_HIER	HIERARCHY	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SETHANA_HIER	MANDT		☐	MANDT	☐	Client
2	SETCLASS	SETHANA_HIER	SETCLASS	S	☐	SETCLASS	☐	Set class
3	SUBCLASS	SETHANA_HIER	SUBCLASS	S	☐	SETSUBCLS	☐	Organizational Unit as Set Subclass
4	HIERARCHY	SETHANA_HIER	HIERARCHY		☐	SETNAMENEW	☐	Set Name
5	DESCRIPTION	SETHANA_HIER	DESCRIPTION		☐	SETHANATEXT40	☐	Description
6	STATUS	SETHANA_STATUS	STATUS	H	☐	SETHANA_SYNC_STATUS	☐	Synchronization status for hierarchies
7	PLANACTION	SETHANA_HIER	PLANACTION		☐	SETHANA_PLAN_ACTION	☐	Planned Action for hierarchy
8	CRTDUSER	SETHANA_STATUS	CRTDUSER	R	☐	SETHANA_CRTD_USER	☐	User who created hierarchy
9	CRTDDATE	SETHANA_STATUS	CRTDDATE	R	☐	SETHANA_CRTD_DATE	☐	Date hierarchy was created
10	CRTDTIME	SETHANA_STATUS	CRTDTIME	R	☐	SETHANA_CRTD_TIME	☐	Time hierarchy was created
11	FULLUSER	SETHANA_STATUS	FULLUSER	R	☐	SETHANA_FULL_USER	☐	User who fully loaded hierarchy
12	FULLDATE	SETHANA_STATUS	FULLDATE	R	☐	SETHANA_FULL_DATE	☐	Date hierarchy was fully loaded
13	FULLTIME	SETHANA_STATUS	FULLTIME	R	☐	SETHANA_FULL_TIME	☐	Time hierarchy was fully loaded
14	DLTAUSER	SETHANA_STATUS	DLTAUSER	R	☐	SETHANA_DLTA_USER	☐	User who delta loaded hierarchy
15	DLTADATE	SETHANA_STATUS	DLTADATE	R	☐	SETHANA_DLTA_DATE	☐	Date hierarchy was delta loaded
16	DLTATIME	SETHANA_STATUS	DLTATIME	R	☐	SETHANA_DLTA_TIME	☐	Time hierarchy was delta loaded
17	STATUSER	SETHANA_STATUS	STATUSER	R	☐	SETHANA_STAT_USER	☐	User who activated/de-activated hierarchy
18	STATDATE	SETHANA_STATUS	STATDATE	R	☐	SETHANA_STAT_DATE	☐	Date hierarchy activated/inactivated
19	STATTIME	SETHANA_STATUS	STATTIME	R	☐	SETHANA_STAT_TIME	☐	Time hierarchy activated/inactivated
20	COUNTERNODE	SETHANA_STATUS	COUNTERNODE	H	☐	SETHANACOUNTER	☐	Counter for nodes in hierarchy table
21	COUNTERLEAF	SETHANA_STATUS	COUNTERLEAF	H	☐	SETHANACOUNTER	☐	Counter for nodes in hierarchy table
22	CURRENTNODES	SETHANA_STATUS	CURRENTNODES	R	☐	SETHANANODENO	☐	Number of nodes in hierarchy table
23	CURRENTLEAFS	SETHANA_STATUS	CURRENTLEAFS	R	☐	SETHANALEAFNO	☐	Number of leaves in hierarchy table
24	HIERTABLE	SETHANA_STATUS	HIERTABLE	R	☐	SETHANA_TABLE	☐	Hierarchy table name
25	HIERVIEW	SETHANA_STATUS	HIERVIEW	R	☐	SETHANA_VIEW	☐	Hierarchy view name
26	XNONSTATIC	SETHANA_STATUS	XNONSTATIC	R	☐	SETHANANONSTATIC	☐	Hierarchy with non-static components

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

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