SAP ABAP Table SETHANA_STATUS_V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SETHANA_STATUS_V	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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
5	DESCRIPTION	☐	SETHANATEXT40	TEXT40	CHAR	40	0	Description
6	STATUS	☐	SETHANA_SYNC_STATUS	SETHANA_SYNC_STATUS	CHAR	1	0	Synchronization status for hierarchies
7	PLANACTION	☐	SETHANA_PLAN_ACTION	SETHANA_PLAN_ACTION	CHAR	1	0	Planned Action for hierarchy
8	CRTDUSER	☐	SETHANA_CRTD_USER	USNAM	CHAR	12	0	User who created hierarchy
9	CRTDDATE	☐	SETHANA_CRTD_DATE	DATUM	DATS	8	0	Date hierarchy was created
10	CRTDTIME	☐	SETHANA_CRTD_TIME	TIME	TIMS	6	0	Time hierarchy was created
11	FULLUSER	☐	SETHANA_FULL_USER	USNAM	CHAR	12	0	User who fully loaded hierarchy
12	FULLDATE	☐	SETHANA_FULL_DATE	DATUM	DATS	8	0	Date hierarchy was fully loaded
13	FULLTIME	☐	SETHANA_FULL_TIME	TIME	TIMS	6	0	Time hierarchy was fully loaded
14	DLTAUSER	☐	SETHANA_DLTA_USER	USNAM	CHAR	12	0	User who delta loaded hierarchy
15	DLTADATE	☐	SETHANA_DLTA_DATE	DATUM	DATS	8	0	Date hierarchy was delta loaded
16	DLTATIME	☐	SETHANA_DLTA_TIME	TIME	TIMS	6	0	Time hierarchy was delta loaded
17	STATUSER	☐	SETHANA_STAT_USER	USNAM	CHAR	12	0	User who activated/de-activated hierarchy
18	STATDATE	☐	SETHANA_STAT_DATE	DATUM	DATS	8	0	Date hierarchy activated/inactivated
19	STATTIME	☐	SETHANA_STAT_TIME	TIME	TIMS	6	0	Time hierarchy activated/inactivated
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	HIERTABLE	☐	SETHANA_TABLE	DBOBJ_NAME	CHAR	16	0	Hierarchy table name
25	HIERVIEW	☐	SETHANA_VIEW	DBOBJ_NAME	CHAR	16	0	Hierarchy view name
26	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_V	SETCLASS	SETHANACLASSES	HIERCLASS

History

Last changed by/on	SAP	20130529
SAP Release Created in