SAP Table AEEF

ECM: effectivity

AEEF (ECM: effectivity) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AEEF to other SAP tables.

AEEF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
AENNR Change Number AENNR CHAR 12 0
AEEFZ Engin. change mgmt: counter in table key CC_AEEFZ NUMC 4 0
DATE_LO Date - lower limit CC_DATE_LO DATS 8 0
DATE_HI Date - upper limit CC_DATE_HI DATS 8 0
DATE_OI Date - open interval CC_DATE_OI CHAR 1 0
X Yes
NULL No
MATNR_LO Material number - lower limit CC_MATNR_LO CHAR 18 0
SERNR_LO Serial number - lower limit CC_SERNR_LO CHAR 18 0
SERNR_HI Serial number - upper limit CC_SERNR_HI CHAR 18 0
PRODUCT_LO Internal Number (GUID) for Product CC_PRODUCTID_LO CHAR 22 0
CLASS_LO Class number KLASSE_D CHAR 18 0
CLASSTY_LO Class Type KLASSENART CHAR 3 0
PLANT_LO Plant CC_WERKS_D CHAR 4 0
STARTUP_LO Start-Up Parameters for Effectivity CC_STARTUP CHAR 30 0
LOCNO_LO Internal location number (customer, supplier or plant) CC_LOCID_LO CHAR 22 0
SERNR_OI Serial number - indicator CC_SERNR_OI CHAR 1 0
X Yes
NULL No
ANDAT Date record created on CC_ANDAT DATS 8 0
ANNAM User who created record CC_ANNAM CHAR 12 0
AEDAT Date of Last Change CC_AEDAT DATS 8 0
AENAM Name of person who changed object CC_AENAM CHAR 12 0