SAP PSHLPDB_CACHE_CP Store changepointers for local cache Table data and field list

PSHLPDB_CACHE_CP is a standard SAP Table which is used to store Store changepointers for local cache data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PSHLPDB_CACHE_CP table consists of various fields, each holding specific information or linking keys about Store changepointers for local cache data available in SAP. These include OBJNR (Object number), OBJNR_HEADER (Object number), DATASET (Data Set for Project Cache), OBJNR_PARENT (Object number)... 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_CACHE_CP 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: Cannot Be Enhanced

SAP PSHLPDB_CACHE_CP 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_CACHE_CP 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
OBJNR_HEADER	Object number	J_OBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
DATASET	Data Set for Project Cache	PS_DATASET	CHAR	20			PS_DATASET
OBJNR_PARENT	Object number	J_OBJNR	CHAR	22	Assigned to domain		J_OBJNR	ONR
EXPIRY_DATE	Date from Which Cached Data Is Invalid	PS_EXPIRY_DATE	DATS	8
CHANGE_TYPE	Change Type for Project Cache	PS_CHANGE_TYPE	CHAR	20			PS_CHANGE_TYPE

Key field

Non-key field

< PSHL - Text key for indexed objects in SAPfile PSHLPDB_HIER_TMP - Table to store temporary hierarchy data >

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

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

SELECT SINGLE *
FROM PSHLPDB_CACHE_CP
INTO CORRESPONDING FIELDS OF WA_PSHLPDB_CACHE_CP
WHERE...

How to access SAP table PSHLPDB_CACHE_CP

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

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