SAP ABAP Table QADBHIER (Reference Hierarchy Transfer Structure to QADB)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ SV-ASA-QAD (Application Component) Question & Answer Database
     ⤷ SBEIF (Package) Reference Structure and Process Maintenance Interface

Basic Data

Table Category	INTTAB	Structure
Structure	QADBHIER	Table Relationship Diagram
Short Description	Reference Hierarchy Transfer Structure to QADB

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	ROW_NUMBER	☐			INT4	10	0
2	NODE_ID	☑	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
3	NODE_TYPE	☐	HIER_NODET	HIER_NODET	CHAR	4	0	Valid Node Types in Structure Repository	*
4	NODE_LEVEL	☐	SEU_LEVEL	SEU_LEVEL	NUMC	2	0	Node level
5	EXTENSION	☐	HIER_NAMES	HIER_NAMES	CHAR	15	0	Structure enhancement ID	*
6	PARENT_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
7	SEQUENCE	☐	HIER_SEQU		INT2	5	0	Sequential number
8	BROTHER_ID	☐	HIER_BR_ID	CHAR40	CHAR	40	0	ID of predecessor on same level
9	TREE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
10	REFNODE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
11	REFTREE_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
12	LOCAL_FLAG	☐	HIER_LOCAL	HIER_YESNO	CHAR	1	0	Local use: Must not be referenced
13	VALID_F_R	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
14	VALID_T_R	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
15	VALID_F_D	☐	SYDATUM	SYDATS	DATS	8	0	System Date
16	VALID_T_D	☐	SYDATUM	SYDATS	DATS	8	0	System Date
17	FORCE_PLUS	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
18	W_SUBNODES	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
19	FILTER_ID	☐	HIER_GUID	SYCHAR32	CHAR	32	0	Unique ID - 32 characters
20	.INCLUDE	☐				0	0	Creation data and change data for gen. hierarchy storage
21	FUSER	☐	HIER_FUSER	HIER_USER	CHAR	12	0	Created by
22	FDATE	☐	HIER_FDATE	SYDATS	DATS	8	0	Created on
23	FTIME	☐	HIER_FTIME	SYTIME	TIMS	6	0	Created at
24	FRELEASE	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
25	LUSER	☐	HIER_LUSER	HIER_USER	CHAR	12	0	Last changed by
26	LDATE	☐	HIER_LDATE	SYDATS	DATS	8	0	Last Changed On
27	LTIME	☐	HIER_LTIME	SYTIME	TIMS	6	0	Time of Last Change
28	LRELEASE	☐	SYSAPRL	SYCHAR04	CHAR	4	0	Release of SAP System
29	REF_TYPE	☐	HIER_RTYPE	HIER_RTYPE	CHAR	4	0	Valid Reference Types in Structure Repository	*
30	REF_OBJECT	☐	HIER_ROBJE	CHAR70	CHAR	70	0	Referenced object for node
31	DEL_FLAG	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
32	FROM_RNODE	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
33	SPRAS	☐	HIER_LAN	SPRAS	LANG	1	0	Documentation language	*
34	TEXT	☐	HIER_TEXT	HIER_TEXT	CHAR	75	0	Explanatory text
35	FROM_OBJ	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
36	IMG_FLAG	☐	HIER_YESNO	HIER_YESNO	CHAR	1	0	Flag with values ' ' and 'X'
37	LEAF	☐	UFFLAG	UFFLAG	CHAR	1	0	Data element for Flag - Any use
38	IBU	☐	UFFLAG	UFFLAG	CHAR	1	0	Data element for Flag - Any use

History

Last changed by/on	SAP	20130604
SAP Release Created in