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
⤷ 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 |