SAP AENR Change Master Table
Overview
AENR is a standard SAP S/4HANA table that stores Change Master data. There are total 33 fields in the AENR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AENR belongs to Engineering Change Management (CA-GTF-ECM) module and is located in the package Engineering Change Management (CC).
In addition, following links provide an overview of foreign key relationships, if any, that link AENR to other SAP tables and standard CDS views available based on AENR table in S/4HANA 2020.
Techincal Settings of AENR
Below are technical details of the table AENR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AENR Fields
The following table gives you an overview of the fields available in AENR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AENNR | Change Number | AENNR | CHAR | 12 | |
| AENST | Status of change number | AENST | T419S | NUMC | 2 |
| AENBE | Authorization group for change master record | CC_AENBE | CHAR | 4 | |
| DATUV | Valid-From Date | CC_CCDAT | DATS | 8 | |
| TECHV | Technical status from | CC_TECHV | CHAR | 12 | |
| ANDAT | Date record created on | CC_ANDAT | DATS | 8 | |
| ANNAM | User who created record | CC_ANNAM | CHAR | 12 | |
| AEDAT | Date of Last Change | CC_AEDAT | DATS | 8 | |
| AENAM | Name of person who changed object | CC_AENAM | CHAR | 12 | |
| AETXT | Change number description | CC_AETXT | CHAR | 40 | |
| LTXSP | Language: The long text was stored in this language | CC_LTXSP | LANG | 1 | |
| AEGRU | Reason for change | CC_AEGRU | CHAR | 40 | |
| CCART | Change type | CC_CCART | NUMC | 3 | |
| CCSTM | Maximum partial status keys in engineering change management | CCSTM_D | NUMC | 8 | |
| DYDAT | Indicator: change number with dynamic date | CC_DYDAT | CHAR | 1 | |
| CONT1 | Digital signature (process improvement) | CC_DSIGN | CHAR | 1 | |
| AEFUN | Change number function | CC_AEFUN | CHAR | 1 | |
| UESTR | Indicator: Overriding possible | CC_UESTR | CHAR | 1 | |
| RLKEY | Release Key for Change Master Record | CC_RLKEY | TCC10 | NUMC | 2 |
| LVORM | Deletion Flag for Change Number (Reorganization) | CC_LOEKZ | CHAR | 1 | |
| CLINT | Internal class number describing effectivity type | CC_CLINT | NUMC | 10 | |
| AERNG | ECM: rank of change number | CC_AERNG | NUMC | 2 | |
| RLDAT | Date when the release key was changed | CC_RLDAT | DATS | 8 | |
| RLTIM | Time when the release key was changed | CC_RLTIM | TIMS | 6 | |
| TEREL | Indicator: Technical release occurs | CC_TEREL | CHAR | 1 | |
| NACHT | Indicator: Change Package Created After Release | CC_NACHT | CHAR | 1 | |
| INDAT | Effective Date of Statutory Regulation | CC_INDAT | DATS | 8 | |
| AUDAT | End Date for Transitional Period (Prescribed by Law) | CC_AUDAT | DATS | 8 | |
| FLUSE | Change number was used for data definition | CC_FLUSE | CHAR | 1 | |
| AEDIF | ECM: Distinguish Effectivity Types | CC_AEDIF | NUMC | 10 | |
| ERLED | Indicator for basic change | CC_AEERL | CHAR | 1 | |
| LASTCHANGEDDATETIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 21 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AENR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AENR | AENST | 1: CN | T419S |
| AENR | MANDT | 1: CN | T000 |
| AENR | RLKEY | 1: CN | TCC10 |