AEDT is a standard SAP table in SAP ECC (or) S/4HANA which stores Engineering Change Management: Alternative Dates data. There are total 10 fields in AEDT table.This blog post provides key technical details of SAP table AEDT, including its availability across SAP S/4HANA versions and the list of CDS views for AEDT table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Engineering Change Management (CC) |
| Technical Component | Engineering Change Management (CA-GTF-ECM) |
SAP AEDT Table Fields
The following is the list of fields that are available in SAP AEDT table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| AENNR | Change Number | AENNR | AENNR | AENR | CHAR (12) |
| AEDTZ | Engineering change management: alternative date counter | AEDTZ | NUMC03 | NUMC (3) | |
| DATUV | Valid-From Date | CC_CCDAT | CC_DATUM | DATS (8) | |
| ANDAT | Date record created on | CC_ANDAT | CC_DATUM | DATS (8) | |
| ANNAM | User who created record | CC_ANNAM | CC_USNAM | CHAR (12) | |
| AEDAT | Date of Last Change | CC_AEDAT | CC_DATUM | DATS (8) | |
| AENAM | Name of person who changed object | CC_AENAM | CC_USNAM | CHAR (12) | |
| AEDTN | Alternative date external key | CC_AEDTN | CC_CHAR18 | CHAR (18) | |
| AEDTO | Indicator: Objects allocated | CC_AEDTO | CC_XFELD | CHAR (1) |
Availability
The SAP table AEDT is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AEDT table
The following is the list of AEDT CDS views, which can also be used instead of AEDT table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| A_CHANGEMASTERALTDATE | BASIC | Change Number Alternative Dates |
| I_CHANGEMASTERALTDATE | BASIC | Change Number Alternative Date |
| A_CHANGEMASTERALTDATE_1 | COMPOSITE | Change Number Alternative Date |
| A_CHANGEMSTROBJECTMGMTRECORD | COMPOSITE | Change Number Object Management Records |
| A_CHANGEMSTROBMGREDOCINFORECD | COMPOSITE | Change Number Object Management Records – DIR |
| A_CHANGEMSTROBMGREMATERIAL | COMPOSITE | Change Number Object Management Records – Material |
| A_CHANGEMSTROBMGREMATLBOM | COMPOSITE | Change Number Object Management Records – Material BOM |
| C_CHANGEMASTERALTDATE | CONSUMPTION | Change Number Alternative Date |
