SAP Table ESTPP
EHS: Phrase Item
ESTPP (EHS: Phrase Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ESTPP to other SAP tables.
ESTPP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| RECN | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| ACTN | Sequential Number of the Change State | ESEACTN | NUMC | 20 | 0 | |||||||
| VALFR | Valid-From Date | ESEVALFR | DATS | 8 | 0 | |||||||
| VALTO | Valid-To Date | ESEVALTO | DATS | 8 | 0 | |||||||
| AENNR | Change Number | ESEAENNR | AENR | CHAR | 12 | 0 | ||||||
| DELFLG | Deletion Indicator | ESEDELFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| CRDAT | Created On | ESECRDAT | DATS | 8 | 0 | |||||||
| CRNAM | Created By | ESECRNAM | CHAR | 12 | 0 | |||||||
| UPDDAT | Changed On | ESEUPDDAT | DATS | 8 | 0 | |||||||
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR | 12 | 0 | |||||||
| SRSID | Source of Data | ESESRSID | TCG56 | CHAR | 10 | 0 | ||||||
| OWNID | Data Provider | ESEVENDRID | CHAR | 10 | 0 | |||||||
| RECNROOT | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| LANGU | Language | ESELANGU | TCG65 | LANG | 1 | 0 | ||||||
| PHRCODE | Phrase Code | ESEPHRCODE | CHAR | 40 | 0 | |||||||
| PHRTEXT | Phrase Text | ESEPHRTEXT | CHAR | 132 | 0 | |||||||
| LTXTFLG | Long Text | ESELTXTFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| FORMATFLG | Formatting Available | ESEFORMATFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| REM | Note | ESEREM | CHAR | 60 | 0 | |||||||
| PHRGRAPH | Name of Graphics File | ESEPHRGRPH | CHAR | 30 | 0 | |||||||
| FLGWRLTXT | Phrase text is stored as SAPscript text | ESEWRLTXT | CHAR | 1 | 0 |
Possible values
|
||||||
| PPSTATE | Phrase Status | ESEPPSTATE | TCG67 | CHAR | 5 | 0 | ||||||
ESTPP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ESTPP | AENNR | SY | MANDT | AENR | Change Master | MANDT |
| ESTPP | AENNR | ESTPP | AENNR | AENR | Change Master | AENNR |
| ESTPP | LANGU | ESTPP | LANGU | TCG65 | EHS: Phrase language (languages supported by phrase library) | PHRLANG |
| ESTPP | LANGU | ESTPP | MANDT | TCG65 | EHS: Phrase language (languages supported by phrase library) | MANDT |
| ESTPP | MANDT | ESTPP | MANDT | T000 | Clients | MANDT |
| ESTPP | PPSTATE | ESTPP | MANDT | TCG67 | EHS: Phrase Item Status | MANDT |
| ESTPP | PPSTATE | ESTPP | PPSTATE | TCG67 | EHS: Phrase Item Status | PPSTATE |
| ESTPP | SRSID | * | TCG56 | EHS: Data Origin | MANDT | |
| ESTPP | SRSID | ESTPP | SRSID | TCG56 | EHS: Data Origin | SRSID |
