SAP ESH_EX_ZEXTP Customer Extraction Profiles for ESH Data Extraction Table data and field list

ESH_EX_ZEXTP is a standard SAP Table which is used to store Customer Extraction Profiles for ESH Data Extraction data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_EX_ZEXTP table consists of various fields, each holding specific information or linking keys about Customer Extraction Profiles for ESH Data Extraction data available in SAP. These include ZEXTP_KEY (Customer Extraction Profile Key), REF_EXTP_KEY (Referenced SAP Default Extraction Profile Key), EXTRACTION_ROLE (Custom Role for Data Extraction (Replacing SAP Default)), CREA_USER (User Name)... 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_ZEXTP table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_EX_ZEXTP 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_ZEXTP 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
ZEXTP_KEYCustomer Extraction Profile Key ESH_E_EX_Z_EXTP_KEYCHAR32ESH_D_EX_EXTP_KEY
REF_EXTP_KEYReferenced SAP Default Extraction Profile Key ESH_E_EX_R_EXTP_KEYCHAR32ESH_D_EX_EXTP_KEYESH_H_EX_EXTP
EXTRACTION_ROLECustom Role for Data Extraction (Replacing SAP Default) ESH_E_EX_Z_EXTRACTION_ROLECHAR30Assigned to domainAGR_NAMEAGR_NAME
CREA_USERUser Name SYUNAMECHAR12SYCHAR12
CREA_TSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_EX_ZEXTP
INTO CORRESPONDING FIELDS OF WA_ESH_EX_ZEXTP
WHERE...

How to access SAP table ESH_EX_ZEXTP

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

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