SAP Table MAPLB
Record structure: Material allocation to task lists
MAPLB (Record structure: Material allocation to task lists) 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 MAPLB to other SAP tables.
MAPLB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FLG_SEL | Version is valid on key date entered | FLGSEL | CHAR | 1 | 0 |
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 |
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 | ||||||||
| VBKZ | Update indicator | VBKZ | CHAR | 1 | 0 |
Possible values
|
||||||||
| DATUB | Valid-to date | DATUB | DATS | 8 | 0 | |||||||||
| AENNR_AUS | Change Number | AENNR | CHAR | 12 | 0 | |||||||||
MAPLB foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MAPLB | AENNR | MAPLB | MANDT | AENR | Change Master | MANDT |
| MAPLB | AENNR | MAPLB | AENNR | AENR | Change Master | AENNR |
| MAPLB | KUNR | MAPLB | KUNR | KNA1 | General Data in Customer Master | KUNNR |
| MAPLB | KUNR | MAPLB | MANDT | KNA1 | General Data in Customer Master | MANDT |
| MAPLB | LIFNR | MAPLB | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| MAPLB | LIFNR | MAPLB | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| MAPLB | MANDT | MAPLB | MANDT | T000 | Clients | MANDT |
| MAPLB | MATNR | MAPLB | MANDT | MARA | General Material Data | MANDT |
| MAPLB | MATNR | MAPLB | MATNR | MARA | General Material Data | MATNR |
| MAPLB | MS_OBJECT | MAPLB | MANDT | TQMS2 | Objects for Multiple Specifications | MANDT |
| MAPLB | MS_OBJECT | MAPLB | MS_OBJECT | TQMS2 | Objects for Multiple Specifications | OBJECT |
| MAPLB | MS_OBJTYPE | MAPLB | MS_OBJTYPE | TQMS1 | Types for Multiple Specification Objects | OBJECTTYPE |
| MAPLB | MS_OBJTYPE | MAPLB | MANDT | TQMS1 | Types for Multiple Specification Objects | MANDT |
| MAPLB | PLNTY | MAPLB | MANDT | TCA01 | Task list types | MANDT |
| MAPLB | PLNTY | MAPLB | PLNTY | TCA01 | Task list types | PLNTY |
| MAPLB | POSNR | MAPLB | MANDT | VBUP | Sales Document: Item Status | MANDT |
| MAPLB | POSNR | MAPLB | VBELN | VBUP | Sales Document: Item Status | VBELN |
| MAPLB | POSNR | MAPLB | POSNR | VBUP | Sales Document: Item Status | POSNR |
| MAPLB | VBELN | MAPLB | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| MAPLB | VBELN | MAPLB | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| MAPLB | WERKS | MAPLB | MANDT | T001W | Plants/Branches | MANDT |
| MAPLB | WERKS | MAPLB | WERKS | T001W | Plants/Branches | WERKS |
