SAP Table MDML
Structure with Material/Production Version/Line
MDML (Structure with Material/Production Version/Line) 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 MDML to other SAP tables.
MDML table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| VERID | Production Version | VERID | MKAL | CHAR | 4 | 0 | ||
| LINIE | Production line for repetitive manufacturing | SA_LINE1 | CHAR | 8 | 0 | |||
| LINHI | Line hierarchy | LD_LINE | CHAR | 8 | 0 | |||
| MDV02 | Planning identification 2 | MDV02 | T437P | CHAR | 8 | 0 | ||
| BDATU | Run-time end: production version | BDATM | DATS | 8 | 0 | |||
| ADATU | Valid-from date of production version | ADATM | DATS | 8 | 0 | |||
| VERTO | Distribution key for quantity produced | SA_VERTO | CHAR | 4 | 0 | |||
| ALORT | Receiving storage location for repetitive manufacturing | ALORT | CHAR | 4 | 0 | |||
MDML foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MDML | MATNR | SYST | MANDT | MARA | General Material Data | MANDT |
| MDML | MATNR | MDML | MATNR | MARA | General Material Data | MATNR |
| MDML | MDV02 | MDML | MDV02 | T437P | Planning IDs for Repetitive Manufacturing | PLAN_ID |
| MDML | MDV02 | SYST | MANDT | T437P | Planning IDs for Repetitive Manufacturing | MANDT |
| MDML | MDV02 | MDML | WERKS | T437P | Planning IDs for Repetitive Manufacturing | WERKS |
| MDML | VERID | MDML | WERKS | MKAL | Production Versions of Material | WERKS |
| MDML | VERID | MDML | VERID | MKAL | Production Versions of Material | VERID |
| MDML | VERID | SYST | MANDT | MKAL | Production Versions of Material | MANDT |
| MDML | VERID | MDML | MATNR | MKAL | Production Versions of Material | MATNR |
| MDML | WERKS | SYST | MANDT | T001W | Plants/Branches | MANDT |
| MDML | WERKS | MDML | WERKS | T001W | Plants/Branches | WERKS |
