SAP table EAPL (Allocation of task lists to pieces of equipment)
SAP table EAPL has 7 primary key fields being MANDT,EQUNR,PLNTY,PLNNR,PLNAL,ZKRIZ,ZAEHL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| EQUNR | Equipment Number | CHAR | 18 | 0 | EQUI | EQUNR | |
| PLNTY | Task List Type | CHAR | 1 | 0 | * | PLNTY | |
| PLNNR | Key for Task List Group | CHAR | 8 | 0 | PLNNR | ||
| PLNAL | Group Counter | CHAR | 2 | 0 | PLNAL | ||
| ZKRIZ | Counter for Additional Criteria | NUMC | 7 | 0 | DZKRIZ | ||
| ZAEHL | Internal counter | NUMC | 8 | 0 | CIM_COUNT | ||
| DATUV | Valid-From Date | DATS | 8 | 0 | DATUV | ||
| TECHV | Technical status from | CHAR | 12 | 0 | TECHV | ||
| LOEKZ | Deletion Indicator | CHAR | 1 | 0 | LKENZ | ||
| PARKZ | Indicator: inactive changes | CHAR | 1 | 0 | PARKZ | ||
| AENNR | Change Number | CHAR | 12 | 0 | AENR | AENNR | |
| SWERK | Maintenance Plant | CHAR | 4 | 0 | T001W | SWERK | |
| IWERK | Maintenance Planning Plant | CHAR | 4 | 0 | * | IWERK | |
| PLNVW | Task List Usage | CHAR | 3 | 0 | T411 | PLN_VERWE | |
| ANDAT | Date Record Created On | DATS | 8 | 0 | ANDAT | ||
| ANNAM | User who created record | CHAR | 12 | 0 | ANNAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM |
EAPL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 EAPL | AENNR | AENR | Change Master | AENNR |
| 1 EAPL | EQUNR | EQUI | Equipment master data | MANDT |
| 0 EAPL | MANDT | T000 | Clients | MANDT |
| 1 EAPL | PLNVW | T411 | Task list usage | MANDT |
| 0 EAPL | SWERK | T001W | Plants/Branches | MANDT |
| 0 EAPL | SWERK | T001W | Plants/Branches | WERKS |