SAP table EST_CHANGE_DOCS (Change Documents in the System)
SAP table EST_CHANGE_DOCS has 8 primary key fields being MANDT,CHANGENR,SUBID,CHNG_RECN,CHNG_ACTN,CHNG_ATKEY,FNAME,TABNAME.
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 | * | MANDT | |||||||||||
| CHANGENR | Change Number of Document | CHAR | 10 | 0 | CDCHANGENR | ||||||||||||
| SUBID | Specification | CHAR | 12 | 0 | ESESUBID | ||||||||||||
| CHNG_RECN | Sequential Number of Data Record | NUMC | 20 | 0 | ESERECN | ||||||||||||
| CHNG_ACTN | Sequential Number of the Change State | NUMC | 20 | 0 | ESEACTN | ||||||||||||
| CHNG_ATKEY | Character String Length 32 | CHAR | 32 | 0 | EHSBE_CHAR0032 | ||||||||||||
| FNAME | Field Name | CHAR | 30 | 0 | * | FIELDNAME | |||||||||||
| TABNAME | Table Name | CHAR | 30 | 0 | * | TABNAME | |||||||||||
| CHNGIND | Type of Change | CHAR | 1 | 0 | CDCHNGIND |
|
|||||||||||
| USERNAME | User name of the person responsible in change document | CHAR | 12 | 0 | CDUSERNAME | ||||||||||||
| UDATE | Creation date of the change document | DATS | 8 | 0 | CDDATUM | ||||||||||||
| UTIME | Time changed | TIMS | 6 | 0 | CDUZEIT | ||||||||||||
| VALFR | Valid-From Date | DATS | 8 | 0 | ESEVALFR | ||||||||||||
| VALTO | Valid-To Date | DATS | 8 | 0 | ESEVALTO | ||||||||||||
| VALUE_OLD | Field contents of changed field | CHAR | 254 | 0 | ESECDVALUE | ||||||||||||
| VALUE_NEW | Field contents of changed field | CHAR | 254 | 0 | ESECDVALUE | ||||||||||||
| CONTEXT | Short Description of Operator | CHAR | 128 | 0 | ESDEXPOPNA | ||||||||||||
| ESTCAT | Value Assignment Type | CHAR | 30 | 0 | * | ESEESTCAT | |||||||||||
| ATNAM | Characteristic Name | CHAR | 30 | 0 | ATNAM | ||||||||||||
| IDENT | Identifier | CHAR | 132 | 0 | ESEIDENT | ||||||||||||
| REFERENCE | Specification | CHAR | 12 | 0 | ESESUBID | ||||||||||||
| MASTER_TAB | Name of Master Table | CHAR | 30 | 0 | ESENAMEMST | ||||||||||||
| MASTER_RECN | Reference to Master Table | NUMC | 20 | 0 | ESERECNMST | ||||||||||||
| SORT | Sort Order | NUMC | 4 | 0 | ESEORD | ||||||||||||
| LANGU | Language Key | LANG | 1 | 0 | * | SPRAS | |||||||||||
| TEXT_CASE | Text change flag ('X') | CHAR | 1 | 0 | CDTEXTIND | ||||||||||||
| CHANGED_BY | 3-Byte field | CHAR | 3 | 0 | CHAR3 | ||||||||||||
| BAD_CONTEXT | Truth Value | CHAR | 1 | 0 | ESEBOOLE | ||||||||||||
| PHRASE | Truth Value | CHAR | 1 | 0 | ESEBOOLE |