SETHANA_STATUS

Status of set hierarchies in HANA | #masterdata | Component: Sets
Column Name Description
MANDT Client
SETCLASS FK Set Class
SUBCLASS Organizational Unit as Set Subclass
HIERARCHY FK Set Name
Column Name Description
Column Name Description
Column Name Description
CRTDDATE Date hierarchy was created
CRTDTIME Time hierarchy was created
FULLDATE Date hierarchy was fully loaded
FULLTIME Time hierarchy was fully loaded
DLTADATE Date hierarchy was delta loaded
DLTATIME Time hierarchy was delta loaded
STATDATE Date hierarchy activated/inactivated
STATTIME Time hierarchy activated/inactivated
Column Name Description
STATUS Synchronization status for hierarchies Show values
XNONSTATIC Hierarchy with non-static components Show values
Column Name Description Domain name
CRTDUSER User who created hierarchy USNAM
FULLUSER User who fully loaded hierarchy USNAM
DLTAUSER User who delta loaded hierarchy USNAM
STATUSER User who activated/de-activated hierarchy USNAM
HIERVIEW Hierarchy view name DBOBJ_NAME
HIERTABLE Hierarchy table name DBOBJ_NAME
COUNTERNODE Counter for nodes in hierarchy table SETHANACOUNTER
COUNTERLEAF Counter for nodes in hierarchy table SETHANACOUNTER
CURRENTNODES Number of nodes in hierarchy table SETHANACOUNTER
CURRENTLEAFS Number of leaves in hierarchy table SETHANACOUNTER
Master Data Relations Join Conditions
Set Name
  • Set Name
  • Set Class
  • Organizational Unit as Set Subclass
Set classes supported for HANA hierarchies SETHANA_STATUS.SETCLASS == SETHANACLASSES.HIERCLASS