SAP ESH_EX_TPOINTER Transaction Change Pointer Storage Table data and field list

ESH_EX_TPOINTER is a standard SAP Table which is used to store Transaction Change Pointer Storage data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_EX_TPOINTER table consists of various fields, each holding specific information or linking keys about Transaction Change Pointer Storage data available in SAP. These include SW_COMP_ID (Software Component), OBJECT_TYPE_ID (Object Type), LOGICAL_QUEUE_ID (General ID), TRANSACTION_ID (General ID)... 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. .

ESH_EX_TPOINTER 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 ESH_EX_TPOINTER 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 ESH_EX_TPOINTER 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
SW_COMP_IDSoftware Component ESH_E_OM_SYSRELCHAR32
OBJECT_TYPE_IDObject Type ESH_E_OM_OBJECT_TYPECHAR20ESH_D_OM_OBJECT_TYPE
LOGICAL_QUEUE_IDGeneral ID ESH_E_IF_GENERAL_IDCHAR255ESH_D_IF_GENERAL_ID
TRANSACTION_IDGeneral ID ESH_E_IF_GENERAL_IDCHAR255ESH_D_IF_GENERAL_ID
ENTRY_TYPEChange Pointer Entry Type ESH_E_EX_CP_ENTRY_TYPECHAR1ESH_D_EX_CP_ENTRY_TYPE
TIMESTAMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
STATUSChange Pointer Processing Status ESH_E_EX_CP_PROC_STATUSCHAR1ESH_D_EX_CP_PROC_STATUS
HAS_ERRORProcessed with Error ESH_E_EX_CP_ERRORCHAR1ESH_D_EX_CP_ERROR
USER_IDUser Name SYUNAMECHAR12SYCHAR12
RETRY_COUNTERNatural Number INT4INT410INT4

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_EX_TPOINTER
INTO CORRESPONDING FIELDS OF WA_ESH_EX_TPOINTER
WHERE...

How to access SAP table ESH_EX_TPOINTER

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

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