SAP Table EAPL

Allocation of task lists to pieces of equipment

EAPL (Allocation of task lists to pieces of equipment) 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 EAPL to other SAP tables.

Source: EAPL (Allocation of task lists to pieces of equipment)

EAPL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
PLNTY Task List Type PLNTY CHAR 1 0
PLNNR Key for Task List Group PLNNR CHAR 8 0
PLNAL Group Counter PLNAL CHAR 2 0
ZKRIZ Counter for additional criteria DZKRIZ NUMC 7 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
DATUV Valid-From Date DATUV DATS 8 0
TECHV Technical status from TECHV CHAR 12 0
LOEKZ Deletion Indicator LKENZ CHAR 1 0
X Yes
NULL No
PARKZ Indicator: inactive changes PARKZ CHAR 1 0
X Yes
NULL No
AENNR Change Number AENNR AENR CHAR 12 0
SWERK Maintenance plant SWERK T001W CHAR 4 0
IWERK Maintenance Planning Plant IWERK CHAR 4 0
PLNVW Task list usage PLN_VERWE T411 CHAR 3 0
ANDAT Date record created on ANDAT DATS 8 0
ANNAM User who created record ANNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0

EAPL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EAPL AENNR EAPL MANDT AENR Change Master MANDT
EAPL AENNR EAPL AENNR AENR Change Master AENNR
EAPL EQUNR EAPL MANDT EQUI Equipment master data MANDT
EAPL EQUNR EAPL EQUNR EQUI Equipment master data EQUNR
EAPL MANDT EAPL MANDT T000 Clients MANDT
EAPL PLNVW EAPL MANDT T411 Task list usage MANDT
EAPL PLNVW EAPL PLNVW T411 Task list usage VERWE
EAPL SWERK EAPL MANDT T001W Plants/Branches MANDT
EAPL SWERK EAPL SWERK T001W Plants/Branches WERKS