SAP AEEF ECM: effectivity Table
Overview
AEEF is a standard SAP S/4HANA table that stores ECM: effectivity data. There are total 20 fields in the AEEF table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AEEF 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 AEEF to other SAP tables and standard CDS views available based on AEEF table in S/4HANA 2020.
Techincal Settings of AEEF
Below are technical details of the table AEEF
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AEEF Fields
The following table gives you an overview of the fields available in AEEF
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| AENNR | Change Number | AENNR | * | CHAR | 12 |
| AEEFZ | Engin. change mgmt: counter in table key | CC_AEEFZ | NUMC | 4 | |
| DATE_LO | Date - lower limit | CC_DATE_LO | DATS | 8 | |
| DATE_HI | Date - upper limit | CC_DATE_HI | DATS | 8 | |
| DATE_OI | Date - open interval | CC_DATE_OI | CHAR | 1 | |
| MATNR_LO | Material number - lower limit | CC_MATNR_LO | CHAR | 40 | |
| SERNR_LO | Serial number - lower limit | CC_SERNR_LO | CHAR | 18 | |
| SERNR_HI | Serial number - upper limit | CC_SERNR_HI | CHAR | 18 | |
| PRODUCT_LO | Internal Number (GUID) for Product | CC_PRODUCTID_LO | CHAR | 22 | |
| CLASS_LO | Class number | KLASSE_D | CHAR | 18 | |
| CLASSTY_LO | Class Type | KLASSENART | * | CHAR | 3 |
| PLANT_LO | Plant | CC_WERKS_D | * | CHAR | 4 |
| STARTUP_LO | Start-Up Parameters for Effectivity | CC_STARTUP | CHAR | 30 | |
| LOCNO_LO | Internal location number (customer, supplier or plant) | CC_LOCID_LO | CHAR | 22 | |
| SERNR_OI | Serial number - indicator | CC_SERNR_OI | CHAR | 1 | |
| 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 |
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 AEEF