SAP Table MAPL
Assignment of Task Lists to Materials
MAPL (Assignment of Task Lists to Materials) 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 MAPL to other SAP tables.
MAPL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| PLNTY | Task List Type | PLNTY | TCA01 | 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 | |||||||
| AENNR | Change Number | AENNR | AENR | CHAR | 12 | 0 | ||||||
| LOEKZ | Deletion Indicator | LKENZ | CHAR | 1 | 0 |
Possible values
|
||||||
| PARKZ | Indicator: inactive changes | PARKZ | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | |||||||
| LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||||||
| KUNR | Account number of customer | CPKUNR | KNA1 | CHAR | 10 | 0 | ||||||
| SUCHFELD | Search Field for Customer-Specific Task List Selection | QSUCHFELD | CHAR | 20 | 0 | |||||||
| VBELN | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||||||
| POSNR | Sales Document Item | POSNR_VA | VBUP | NUMC | 6 | 0 | ||||||
| PSPNR | Work breakdown structure element (WBS element) | CS_PSPNR | NUMC | 8 | 0 | |||||||
| MS_OBJECT | Object for Multiple Specifications | Q_MS_OBJECT | TQMS2 | CHAR | 30 | 0 | ||||||
| MS_OBJTYPE | Type of Object for Multiple Specifications | Q_MS_OBJTYPE | TQMS1 | CHAR | 2 | 0 | ||||||
MAPL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MAPL | AENNR | MAPL | MANDT | AENR | Change Master | MANDT |
| MAPL | AENNR | MAPL | AENNR | AENR | Change Master | AENNR |
| MAPL | KUNR | MAPL | KUNR | KNA1 | General Data in Customer Master | KUNNR |
| MAPL | KUNR | MAPL | MANDT | KNA1 | General Data in Customer Master | MANDT |
| MAPL | LIFNR | MAPL | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| MAPL | LIFNR | MAPL | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| MAPL | MANDT | MAPL | MANDT | T000 | Clients | MANDT |
| MAPL | MATNR | MAPL | MANDT | MARA | General Material Data | MANDT |
| MAPL | MATNR | MAPL | MATNR | MARA | General Material Data | MATNR |
| MAPL | MS_OBJECT | MAPL | MANDT | TQMS2 | Objects for Multiple Specifications | MANDT |
| MAPL | MS_OBJECT | MAPL | MS_OBJECT | TQMS2 | Objects for Multiple Specifications | OBJECT |
| MAPL | MS_OBJTYPE | MAPL | MS_OBJTYPE | TQMS1 | Types for Multiple Specification Objects | OBJECTTYPE |
| MAPL | MS_OBJTYPE | MAPL | MANDT | TQMS1 | Types for Multiple Specification Objects | MANDT |
| MAPL | PLNTY | MAPL | MANDT | TCA01 | Task list types | MANDT |
| MAPL | PLNTY | MAPL | PLNTY | TCA01 | Task list types | PLNTY |
| MAPL | POSNR | MAPL | MANDT | VBUP | Sales Document: Item Status | MANDT |
| MAPL | POSNR | MAPL | VBELN | VBUP | Sales Document: Item Status | VBELN |
| MAPL | POSNR | MAPL | POSNR | VBUP | Sales Document: Item Status | POSNR |
| MAPL | VBELN | MAPL | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| MAPL | VBELN | MAPL | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| MAPL | WERKS | MAPL | MANDT | T001W | Plants/Branches | MANDT |
| MAPL | WERKS | MAPL | WERKS | T001W | Plants/Branches | WERKS |
