SAP Table MDDMAP
Mapping Table for External User for MRP Evaluations
MDDMAP (Mapping Table for External User for MRP Evaluations) 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 MDDMAP to other SAP tables.
MDDMAP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||
| UNAME | User Name | SYUNAME | CHAR | 12 | 0 | |||||||||||
| VIEWN | Key for planning result view | MD_VIEWN | CHAR | 15 | 0 | |||||||||||
| PLSCN | Planning Scenario of Long-Term Planning | PLSCN | PLSC | NUMC | 3 | 0 | ||||||||||
| DISPO | MRP Controller (Materials Planner) | DISPO | T024D | CHAR | 3 | 0 | ||||||||||
| FILBZ | Name of display filter | FILBZ | T463 | CHAR | 8 | 0 | ||||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||
| BERID | MRP Area | BERID | MDLV | CHAR | 10 | 0 | ||||||||||
| PRGRP | Name of the product group | PRGRP | MARA | CHAR | 18 | 0 | ||||||||||
| LIFNR | Vendor Key | MD_LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||
| BANKZ | Select by purchase requisitions | BANKZ | CHAR | 1 | 0 | |||||||||||
| BSTKZ | Select by purchase orders | BSTKZ | CHAR | 1 | 0 | |||||||||||
| PAUKZ | Select by planned orders | PAUKZ | CHAR | 1 | 0 | |||||||||||
| DTLFV | Start of delivery date interval | DTLFV | DEC | 4 | 0 | |||||||||||
| DTLFB | End of delivery date interval | DTLFB | DEC | 4 | 0 | |||||||||||
| DSP01 | MRP Controller (Materials Planner) | DISPO | T024D | CHAR | 3 | 0 | ||||||||||
| DTDFV | MRP date from - relative value | DTDFV | NUMC | 3 | 0 | |||||||||||
| DTDFB | MRP date to - relative value | DTDFB | NUMC | 3 | 0 | |||||||||||
| DTDBV | Processing date from - relative value | DTDBV | NUMC | 3 | 0 | |||||||||||
| DTDBB | Processing date to - relative value | DTDBB | NUMC | 3 | 0 | |||||||||||
| BERW1 | Stock Days' Supply Without Receipts | BERW1 | DEC | 4 | 1 | |||||||||||
| BERW2 | First Receipt Days' Supply | BERW2 | DEC | 4 | 1 | |||||||||||
| BERW4 | Second Receipt Days' Supply | BERW4 | DEC | 4 | 1 | |||||||||||
| MAABC | ABC Indicator | MAABC | TMABC | CHAR | 1 | 0 | ||||||||||
| DISMM | MRP Type | DISMM | T438A | CHAR | 2 | 0 | ||||||||||
| BESKZ | Procurement Type | BESKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| SOBSL | Special procurement type | SOBSL | T460A | CHAR | 2 | 0 | ||||||||||
| SELKZ1 | Selection indicator for exception groups | SLKZX | CHAR | 1 | 0 | |||||||||||
| SELKZ2 | Selection indicator for exception groups | SLKZX | CHAR | 1 | 0 | |||||||||||
| SELKZ3 | Selection indicator for exception groups | SLKZX | CHAR | 1 | 0 | |||||||||||
| SELKZ4 | Selection indicator for exception groups | SLKZX | CHAR | 1 | 0 | |||||||||||
| SELKZ5 | Selection indicator for exception groups | SLKZX | CHAR | 1 | 0 | |||||||||||
| SELKZ6 | Selection indicator for exception groups | SLKZX | CHAR | 1 | 0 | |||||||||||
| SELKZ7 | Selection indicator for exception groups | SLKZX | CHAR | 1 | 0 | |||||||||||
| SELKZ8 | Selection indicator for exception groups | SLKZX | CHAR | 1 | 0 | |||||||||||
| JBEKZ | Selection indicator for processed MRP lists | JBEKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| NBEKZ | Selection indicator for unprocessed MRP lists | NBEKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| NAUKZ | Indicator: new exception in the MRP list | NAUKZ | CHAR | 1 | 0 | |||||||||||
MDDMAP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MDDMAP | BERID | MDDMAP | MANDT | MDLV | Customizing MRP Area | MANDT |
| MDDMAP | BERID | MDDMAP | BERID | MDLV | Customizing MRP Area | BERID |
| MDDMAP | DISMM | SYST | MANDT | T438A | MRP Type | MANDT |
| MDDMAP | DISMM | MDDMAP | DISMM | T438A | MRP Type | DISMM |
| MDDMAP | DISPO | MDDMAP | MANDT | T024D | MRP controllers | MANDT |
| MDDMAP | DISPO | MDDMAP | WERKS | T024D | MRP controllers | WERKS |
| MDDMAP | DISPO | MDDMAP | DISPO | T024D | MRP controllers | DISPO |
| MDDMAP | DSP01 | * | T024D | MRP controllers | WERKS | |
| MDDMAP | DSP01 | MDDMAP | DSP01 | T024D | MRP controllers | DISPO |
| MDDMAP | DSP01 | SYST | MANDT | T024D | MRP controllers | MANDT |
| MDDMAP | FILBZ | SYST | MANDT | T463 | Customizing Table Display Filter - Settings - | MANDT |
| MDDMAP | FILBZ | MDDMAP | FILBZ | T463 | Customizing Table Display Filter - Settings - | AFIBZ |
| MDDMAP | LIFNR | SYST | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| MDDMAP | LIFNR | MDDMAP | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| MDDMAP | MAABC | MDDMAP | MAABC | TMABC | Values Table for the ABC Indicator for Materials | MAABC |
| MDDMAP | MAABC | SYST | MANDT | TMABC | Values Table for the ABC Indicator for Materials | MANDT |
| MDDMAP | PLSCN | MDDMAP | MANDT | PLSC | Planning scenarios in long-term planning | MANDT |
| MDDMAP | PLSCN | MDDMAP | PLSCN | PLSC | Planning scenarios in long-term planning | PLSCN |
| MDDMAP | PRGRP | MDDMAP | PRGRP | MARA | General Material Data | MATNR |
| MDDMAP | PRGRP | SYST | MANDT | MARA | General Material Data | MANDT |
| MDDMAP | SOBSL | * | T460A | Special procurement key | WERKS | |
| MDDMAP | SOBSL | MDDMAP | SOBSL | T460A | Special procurement key | SOBSL |
| MDDMAP | SOBSL | SYST | MANDT | T460A | Special procurement key | MANDT |
| MDDMAP | WERKS | MDDMAP | MANDT | T001W | Plants/Branches | MANDT |
| MDDMAP | WERKS | MDDMAP | WERKS | T001W | Plants/Branches | WERKS |
