The ESTDJ table in SAP ERP or S/4HANA stores Assignment of Specifications to Reports data. There are total 16 fields in ESTDJ table. The Assignment of Specifications to Reports 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 ESTDJ table. It is in Company Environment Information System (CBUI) ABAP package and is part of the Product Safety (EHS-SAF) module.
SAP ESTDJ Table Fields
Following is the list of fields that are available in SAP ESTDJ 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) |
| RECNREF | Reference to Reference Specification Header | ESERECNREF | NUMC (20) |
