Monday, March 4, 2024

SAP Table AEDT – Engineering Change Management: Alternative Dates

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