SAP table MAPL (Assignment of Task Lists to Materials)
SAP table MAPL has 8 primary key fields being MANDT,MATNR,WERKS,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 | |
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| PLNTY | Task List Type | CHAR | 1 | 0 | TCA01 | 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 | ||
| AENNR | Change Number | CHAR | 12 | 0 | AENR | AENNR | |
| LOEKZ | Deletion Indicator | CHAR | 1 | 0 | LKENZ | ||
| PARKZ | Indicator: inactive changes | CHAR | 1 | 0 | PARKZ | ||
| 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 | ||
| LIFNR | Vendor's account number | CHAR | 10 | 0 | LFA1 | ELIFN | |
| KUNR | Account number of customer | CHAR | 10 | 0 | KNA1 | CPKUNR | |
| SUCHFELD | Search Field for Customer-Specific Task List Selection | CHAR | 20 | 0 | QSUCHFELD | ||
| VBELN | Sales Document | CHAR | 10 | 0 | VBELN_VA | ||
| POSNR | Sales Document Item | NUMC | 6 | 0 | POSNR_VA | ||
| PSPNR | Work breakdown structure element (WBS element) | NUMC | 8 | 0 | CS_PSPNR | ||
| VALID_TO | Valid-to date | DATS | 8 | 0 | DATUB | ||
| LOEKZ_INHERITED | Deletion Indicator | CHAR | 1 | 0 | LKENZ | ||
| VERSN | Routing Version | CHAR | 4 | 0 | PLNVERSN | ||
| VERSN_SOURCE | Source Routing Version | CHAR | 4 | 0 | PLNVERSN_SOURCE_VERSN | ||
| VERSN_SOURCE_ZKRIZ | Task List Version: Source number mat. assgnmt. to task | NUMC | 7 | 0 | PLNVERSN_SOURCE_ZKRIZ | ||
| MS_OBJECT | Object for Multiple Specifications | CHAR | 30 | 0 | TQMS2 | Q_MS_OBJECT | |
| MS_OBJTYPE | Type of Object for Multiple Specifications | CHAR | 2 | 0 | TQMS1 | Q_MS_OBJTYPE |
MAPL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 MAPL | AENNR | AENR | Change Master | AENNR |
| 1 MAPL | KUNR | KNA1 | General Data in Customer Master | MANDT |
| 1 MAPL | KUNR | KNA1 | General Data in Customer Master | KUNNR |
| 0 MAPL | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 0 MAPL | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 MAPL | MANDT | T000 | Clients | MANDT |
| 0 MAPL | MATNR | MARA | General Material Data | MANDT |
| 0 MAPL | MATNR | MARA | General Material Data | MATNR |
| 1 MAPL | MS_OBJECT | TQMS2 | Objects for Multiple Specifications | OBJECT |
| 0 MAPL | MS_OBJTYPE | TQMS1 | Types for Multiple Specification Objects | OBJECTTYPE |
| 1 MAPL | PLNTY | TCA01 | Task list types | MANDT |
| 0 MAPL | WERKS | T001W | Plants/Branches | MANDT |
| 0 MAPL | WERKS | T001W | Plants/Branches | WERKS |