SAP MAPL Table in S/4 HANA - Assignment of Task Lists to Materials
MAPL is a standard SAP Table which is used to store Assignment of Task Lists to Materials data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MAPL table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type)
Dictionary Type: Transparent table
Database Table: MAPL
MAPL table structure field list
Below is the full MAPL field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
WERKS | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
PLNTY | Task List Type | PLNTY | CHAR | 1(0) | TCA01 | PLNTY | PTY | H_TCA01 | PLNTY | |
PLNNR | Key for Task List Group | PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
PLNAL | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
ZKRIZ | Counter for additional criteria | DZKRIZ | NUMC | 7(0) | ZKRIZ | |||||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
DATUV | Valid-From Date | DATUV | DATS | 8(0) | DATUM | |||||
TECHV | Technical status from | TECHV | CHAR | 12(0) | TECHS | |||||
AENNR | Change Number | AENNR | CHAR | 12(0) | AENR | AENNR | AENNR | AEN | ||
LOEKZ | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
PARKZ | Indicator: inactive changes | PARKZ | CHAR | 1(0) | XFELD | |||||
ANDAT | Date Record Created On | ANDAT | DATS | 8(0) | DATUM | |||||
ANNAM | User who created record | ANNAM | CHAR | 12(0) | USNAM | |||||
AEDAT | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
AENAM | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
LIFNR | Vendor's account number | ELIFN | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
KUNR | Account number of customer | CPKUNR | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | KUN | ||
SUCHFELD | Search Field for Customer-Specific Task List Selection | QSUCHFELD | CHAR | 20(0) | CHAR20 | |||||
VBELN | Sales Document | VBELN_VA | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
POSNR | Sales Document Item | POSNR_VA | NUMC | 6(0) | POSNR | APO | ||||
PSPNR | Work breakdown structure element (WBS element) | CS_PSPNR | NUMC | 8(0) | ABPSP | PS_POSNR | PEI | |||
VALID_TO | Valid-to date | DATUB | DATS | 8(0) | DATUM | |||||
LOEKZ_INHERITED | Deletion Indicator | LKENZ | CHAR | 1(0) | XFELD | |||||
VERSN | Routing Version | PLNVERSN | CHAR | 4(0) | ALPHA | PLNVERSN | ||||
VERSN_SOURCE | Source Routing Version | PLNVERSN_SOURCE_VERSN | CHAR | 4(0) | ALPHA | PLNVERSN | ||||
VERSN_SOURCE_ZKRIZ | Task List Version: Source number mat. assgnmt. to task | PLNVERSN_SOURCE_ZKRIZ | NUMC | 7(0) | ZKRIZ | |||||
MS_OBJECT | Object for Multiple Specifications | Q_MS_OBJECT | CHAR | 30(0) | TQMS2 | Q_MS_OBJECT | ||||
MS_OBJTYPE | Type of Object for Multiple Specifications | Q_MS_OBJTYPE | CHAR | 2(0) | TQMS1 | Q_MS_OBJTYPE |
Search for further information about these or an SAP related objects