The ESTPP table in SAP ERP or S/4HANA stores EHS: Phrase Item data. There are total 24 fields in ESTPP table. The EHS: Phrase Item table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ESTPP table. It is in Phrase Master Data (CBEHS_PHR) ABAP package and is part of the Environment, Health and Safety: Master Data (CA-GTF-EHS) module.
SAP ESTPP Table Fields
Following is the list of fields that are available in SAP ESTPP table. The primary key fields of the table are MANDT (Client), RECN (Sequential Number of Data Record), ACTN (Sequential Number of the Change State).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| RECN | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| ACTN | Sequential Number of the Change State | ESEACTN | NUMC (20) | |
| VALFR | Valid-From Date | ESEVALFR | DATS (8) | |
| VALTO | Valid-To Date | ESEVALTO | DATS (8) | |
| AENNR | Change Number | ESEAENNR | AENR | CHAR (12) |
| DELFLG | Deletion Indicator | ESEDELFLG | CHAR (1) | |
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR (1) | |
| CRDAT | Created On | ESECRDAT | DATS (8) | |
| CRNAM | Created By | ESECRNAM | CHAR (12) | |
| UPDDAT | Last Changed On | ESEUPDDAT | DATS (8) | |
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR (12) | |
| SRSID | Source of Data | ESESRSID | TCG56 | CHAR (10) |
| OWNID | Data Provider | ESEVENDRID | * | CHAR (10) |
| RECNROOT | Sequential Number of Data Record | ESERECN | * | NUMC (20) |
| LANGU | Language | ESELANGU | TCG65 | LANG (1) |
| PHRCODE | Phrase Code | ESEPHRCODE | CHAR (40) | |
| PHRTEXT | Phrase Text | ESEPHRTEXT | CHAR (132) | |
| LTXTFLG | Long Text | ESELTXTFLG | CHAR (1) | |
| FORMATFLG | Formatted | ESEFORMATFLG | CHAR (1) | |
| REM | Note | ESEREM | CHAR (60) | |
| PHRGRAPH | Name of Graphics File | ESEPHRGRPH | CHAR (30) | |
| FLGWRLTXT | Phrase text is stored as SAPscript text | ESEWRLTXT | CHAR (1) | |
| PPSTATE | Phrase Status | ESEPPSTATE | TCG67 | CHAR (5) |
