SAP ABAP Table PSHLP_HIER_DB (Local cache:Project/Independent Network hierarchy)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PS (Application Component) Project System
     ⤷ PS_HLP_CACHE (Package) Handling Large Projects:-Cache

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PSHLP_HIER_DB	Table Relationship Diagram
Short Description	Local cache:Project/Independent Network hierarchy

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	SYMANDT	MANDT	CLNT	3	0	Client ID	*
2	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
3	OBJNR_HEADER	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
4	OBJNR_PARENT	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
5	OBJNR_LEFT	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
6	OBJNR_RIGHT	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
7	OBJNR_DOWN	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
8	TYPE	☐	SEU_TYPE	SEU_TYPE	CHAR	4	0	Node type
9	TLEVEL	☐	SEU_LEVEL	SEU_LEVEL	NUMC	2	0	Node level
10	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
11	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
12	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
13	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
14	APLZL	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
15	MLST_ZAEHL	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
16	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
17	AUFNT	☐	CO_TEILNET	AUFNR	CHAR	12	0	Number of superior network	*
18	APLZT	☐	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	*
19	PROJ_EXT	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
20	PSPEL	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	*
21	PRONR	☐	PS_PSP_PRO	PS_PSPNR	NUMC	8	0	Project definition	*
22	PROJN	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	*
23	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
24	VBUKR	☐	PS_VBUKR	BUKRS	CHAR	4	0	Company code for the project	*
25	PBUKR	☐	PS_PBUKR	BUKRS	CHAR	4	0	Company code for WBS element	*
26	VERNR	☐	PS_VERNR	PS_VERNR	NUMC	8	0	Number of the responsible person (project manager)	*
27	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	*
28	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	*
29	STATUS_CODE	☐	ACTCMB_DELE	ACTCMB_DOM	INT1	3	0	Status Combination
30	POST1	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
31	EXPANDER	☐	EXPANDER_ELE	EXPANDER_DOM	CHAR	1	0	Hierarchy Expandable
32	SHORT_TEXT	☐	SHORT_TEXT_ELE	SHORT_TEXT_ELE	CHAR	1	0	Short Text
33	NAME	☐	RSTH_NAME	KEYID	CHAR	50	0	Name of a Hierarchy Object
34	INDEP_NTWK	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
35	.INCLUDE	☐				0	0	TREX Administration Data
36	LOAD_UNAME	☐	LOAD_UNAME	UNAME	CHAR	12	0	User Who Loaded Data in TREX-Based Cache
37	LOAD_DATE	☐	LOAD_DATE		DATS	8	0	Date on Which Data Was Cached in TREX-Based Cache
38	EXPIRY_DATE	☐	PS_EXPIRY_DATE		DATS	8	0	Date from Which Cached Data Is Invalid

History

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