PSHLP_HIER_DB - Local cache:Project/Independent Network hierarchy
Local cache:Project/Independent Network hierarchy information is stored in SAP table PSHLP_HIER_DB.
It is part of development package PS_HLP_CACHE in software component PS. This development package consists of objects that can be grouped under "Handling Large Projects:-Cache".
It is part of development package PS_HLP_CACHE in software component PS. This development package consists of objects that can be grouped under "Handling Large Projects:-Cache".
Fields for table PSHLP_HIER_DB
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client ID | X | SYMANDT | CLNT | 6 | |
| OBJNR | Object number | X | J_OBJNR | CHAR | 44 | |
| OBJNR_HEADER | Object number | X | J_OBJNR | CHAR | 44 | |
| OBJNR_PARENT | Object number | J_OBJNR | CHAR | 44 | ||
| OBJNR_LEFT | Object number | J_OBJNR | CHAR | 44 | ||
| OBJNR_RIGHT | Object number | J_OBJNR | CHAR | 44 | ||
| OBJNR_DOWN | Object number | J_OBJNR | CHAR | 44 | ||
| TYPE | Node type | SEU_TYPE | CHAR | 8 | ||
| TLEVEL | Node level | SEU_LEVEL | NUMC | 4 | ||
| POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 48 | ||
| VORNR | Operation/Activity Number | VORNR | CHAR | 8 | ||
| UVORN | Suboperation | UVORN | CHAR | 8 | ||
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 20 | ||
| APLZL | General counter for order | CO_APLZL | NUMC | 16 | ||
| MLST_ZAEHL | Milestone number | MLST_ZAEHL | NUMC | 24 | ||
| AUFNR | Order Number | AUFNR | CHAR | 24 | ||
| AUFNT | Number of superior network | CO_TEILNET | CHAR | 24 | ||
| APLZT | General counter for order | CO_APLZL | NUMC | 16 | ||
| PROJ_EXT | Project definition | PS_PSPID | CHAR | 48 | ||
| PSPEL | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 16 | ||
| PRONR | Project definition | PS_PSP_PRO | NUMC | 16 | ||
| PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 16 | ||
| WERKS | Plant | WERKS_D | CHAR | 8 | ||
| VBUKR | Company code for the project | PS_VBUKR | CHAR | 8 | ||
| PBUKR | Company code for WBS element | PS_PBUKR | CHAR | 8 | ||
| VERNR | Number of the Responsible Person (Project Manager) | PS_VERNR | NUMC | 16 | ||
| AUART | Order Type | AUFART | CHAR | 8 | ||
| STEUS | Control key | STEUS | CHAR | 8 | ||
| STATUS_CODE | Status Combination | ACTCMB_DELE | INT1 | 1 | ||
| POST1 | PS: Short description (1st text line) | PS_POST1 | CHAR | 80 | ||
| EXPANDER | Hierarchy Expandable | EXPANDER_ELE | CHAR | 2 | ||
| SHORT_TEXT | Short Text | SHORT_TEXT_ELE | CHAR | 2 | ||
| NAME | Name of a Hierarchy Object | RSTH_NAME | CHAR | 100 | ||
| INDEP_NTWK | Boolean Variable (X = True, - = False, Space = Unknown) | BOOLEAN | CHAR | 2 | ||
| .INCLUDE | PSHLP_TREX_ADM_ST | 0 | ||||
| LOAD_UNAME | User Who Loaded Data in TREX-Based Cache | LOAD_UNAME | CHAR | 24 | ||
| LOAD_DATE | Date on Which Data Was Cached in TREX-Based Cache | LOAD_DATE | DATS | 16 | ||
| EXPIRY_DATE | Date from Which Cached Data Is Invalid | PS_EXPIRY_DATE | DATS | 16 |