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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
PARKZ
Indicator: inactive changes
|
PARKZ |
CHAR
|
1 | 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 | ||||||||
|
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 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| MAPL | KUNR | MAPL | KUNR |
KNA1
General Data in Customer Master
|
KUNNR |
| 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 | MS_OBJECT |
TQMS2
Objects for Multiple Specifications
|
OBJECT |
| MAPL | MS_OBJECT | MAPL | MANDT |
TQMS2
Objects for Multiple Specifications
|
MANDT |
| MAPL | MS_OBJTYPE | MAPL | MANDT |
TQMS1
Types for Multiple Specification Objects
|
MANDT |
| MAPL | MS_OBJTYPE | MAPL | MS_OBJTYPE |
TQMS1
Types for Multiple Specification Objects
|
OBJECTTYPE |
| 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 |