Saturday, May 18, 2024

SAP Table AEEF – ECM: effectivity

AEEF is a standard SAP table in SAP ECC (or) S/4HANA which stores ECM: effectivity data. There are total 20 fields in AEEF table.This blog post provides key technical details of SAP table AEEF, including its availability across SAP S/4HANA versions and the list of CDS views for AEEF 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 AEEF Table Fields

The following is the list of fields that are available in SAP AEEF table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
AENNR Change Number AENNR AENNR * CHAR (12)
AEEFZ Engin. change mgmt: counter in table key CC_AEEFZ CC_NUMC4 NUMC (4)
DATE_LO Date – lower limit CC_DATE_LO CC_DATUM DATS (8)
DATE_HI Date – upper limit CC_DATE_HI CC_DATUM DATS (8)
DATE_OI Date – open interval CC_DATE_OI CC_XFELD CHAR (1)
MATNR_LO Material number – lower limit CC_MATNR_LO CC_MATNR CHAR (40)
SERNR_LO Serial number – lower limit CC_SERNR_LO CC_GERNR CHAR (18)
SERNR_HI Serial number – upper limit CC_SERNR_HI CC_GERNR CHAR (18)
PRODUCT_LO Internal Number (GUID) for Product CC_PRODUCTID_LO CC_PRODUCTID CHAR (22)
CLASS_LO Class number KLASSE_D KLASSE CHAR (18)
CLASSTY_LO Class Type KLASSENART KLASSENART * CHAR (3)
PLANT_LO Plant CC_WERKS_D CC_WERKS * CHAR (4)
STARTUP_LO Start-Up Parameters for Effectivity CC_STARTUP CC_STARTUP CHAR (30)
LOCNO_LO Internal location number (customer, supplier or plant) CC_LOCID_LO CC_LOCID CHAR (22)
SERNR_OI Serial number – indicator CC_SERNR_OI CC_XFELD CHAR (1)
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)

Availability

The SAP table AEEF 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 AEEF table

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.