SAP PSHLPDB_OBJECT Table for storing object information for TREX indexing Table data and field list

PSHLPDB_OBJECT is a standard SAP Table which is used to store Table for storing object information for TREX indexing data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PSHLPDB_OBJECT table consists of various fields, each holding specific information or linking keys about Table for storing object information for TREX indexing data available in SAP. These include OBJNR (Object number), PROJ_EXT (Project Definition), IND_NTW_EXT (Order Number), LOAD_UNAME (User Who Loaded Data in TREX-Based Cache)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

PSHLPDB_OBJECT table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP PSHLPDB_OBJECT table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PSHLPDB_OBJECT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
OBJNR	Object number	J_OBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
PROJ_EXT	Project Definition	PS_PSPID	CHAR	24		ABPSN	PS_PSPID	PSP	PD_DUMMY
IND_NTW_EXT	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
LOAD_UNAME	User Who Loaded Data in TREX-Based Cache	LOAD_UNAME	CHAR	12			UNAME
LOAD_DATE	Date on Which Data Was Cached in TREX-Based Cache	LOAD_DATE	DATS	8
EXPIRY_DATE	Date from Which Cached Data Is Invalid	PS_EXPIRY_DATE	DATS	8

Key field

Non-key field

< PSHLPDB_HIER_TMP - Table to store temporary hierarchy data PSHLP_ACL_ALV_READ_ST - PSHLP : Read structure for ACL ALV UI >

How do I retrieve data from SAP table PSHLPDB_OBJECT using ABAP code

The following ABAP code Example will allow you to do a basic selection on PSHLPDB_OBJECT to SELECT all data from the table
DATA: WA_PSHLPDB_OBJECT TYPE PSHLPDB_OBJECT.

SELECT SINGLE *
FROM PSHLPDB_OBJECT
INTO CORRESPONDING FIELDS OF WA_PSHLPDB_OBJECT
WHERE...

How to access SAP table PSHLPDB_OBJECT

Within an ECC or HANA version of SAP you can also view further information about PSHLPDB_OBJECT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).