SAP PSHLP_CACHE_DB_N Maintains Project Cache Information Table data and field list

PSHLP_CACHE_DB_N is a standard SAP Table which is used to store Maintains Project Cache Information data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PSHLP_CACHE_DB_N table consists of various fields, each holding specific information or linking keys about Maintains Project Cache Information data available in SAP. These include OBJNR (Object number), PROJECT (Project Definition), IND_NTWK (Order Number), OBJECT_TYPE ()... 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. .

PSHLP_CACHE_DB_N table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP PSHLP_CACHE_DB_N 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 PSHLP_CACHE_DB_N 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 ID	SYMANDT	CLNT	3	Assigned to domain		MANDT
OBJNR	Object number	J_OBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
PROJECT	Project Definition	PS_PSPID	CHAR	24		ABPSN	PS_PSPID	PSP	PD_DUMMY
IND_NTWK	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
OBJECT_TYPE				0
NTWK	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
WBS	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
ACTY	Operation/Activity Number	VORNR	CHAR	4		NUMCV	VORNR	VGN
MLST	Milestone number	MLST_ZAEHL	NUMC	12			NUM12
LOAD_DATE	Cache Load Date	CACHE_LOAD_DATE	DATS	8			DATUM
EXPIRY_DATE	Cache Expiry Date	CACHE_EXPIRY_DATE	DATS	8			DATUM	EXP_DATE
CHANGE_TYPE				0
USERNAME	User Name	SYUNAME	CHAR	12			SYCHAR12
HIERARCHY				0
MASTERDATA				0
STATUS				0
STATUS_PROFILE				0
ACL				0
SHORTTEXT				0
ACTY_RELATIONS				0

Key field

Non-key field

< PSHLP_CACHE_DB - Maintains Project Cache Information PSHLP_CACHE_DS_ST - Datasets stored in cache for each object >

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

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

SELECT SINGLE *
FROM PSHLP_CACHE_DB_N
INTO CORRESPONDING FIELDS OF WA_PSHLP_CACHE_DB_N
WHERE...

How to access SAP table PSHLP_CACHE_DB_N

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

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