SAP table ESTPT (EHS: Language-Dependent Description for Phrase Sets)

SAP table ESTPT has 3 primary key fields being MANDT,RECN,ACTN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
RECN Sequential Number of Data Record NUMC 20 0 ESERECN
ACTN Sequential Number of the Change State NUMC 20 0 ESEACTN
VALFR Valid-From Date DATS 8 0 ESEVALFR
VALTO Valid-To Date DATS 8 0 ESEVALTO
AENNR Change Number CHAR 12 0 AENR ESEAENNR
DELFLG Deletion Indicator CHAR 1 0 ESEDELFLG
PARKFLG Data Record Is Inactive CHAR 1 0 ESEPARKFLG
CRDAT Created On DATS 8 0 ESECRDAT
CRNAM Created By CHAR 12 0 ESECRNAM
UPDDAT Last Changed On DATS 8 0 ESEUPDDAT
UPDNAM Last Changed By CHAR 12 0 ESEUPDNAM
SRSID Source of Data CHAR 10 0 TCG56 ESESRSID
OWNID Data Provider CHAR 10 0 * ESEVENDRID
RECNROOT Sequential Number of Data Record NUMC 20 0 * ESERECN
LANGU Language LANG 1 0 TCG65 ESELANGU
PHRSNAM Phrase Set Name CHAR 40 0 ESEPHRSNAM

ESTPT foreign key relationships

Table Field Check Table Check Field
0 ESTPT AENNR AENR Change Master AENNR
1 ESTPT LANGU TCG65 EHS: Phrase language (languages supported by phrase library) MANDT
1 ESTPT LANGU TCG65 EHS: Phrase language (languages supported by phrase library) PHRLANG
0 ESTPT MANDT T000 Clients MANDT
1 ESTPT SRSID TCG56 EHS: Data Origin MANDT
1 ESTPT SRSID TCG56 EHS: Data Origin SRSID