SAP Table MDRI
Generated Table for View MDRI
MDRI (Generated Table for View MDRI) 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 MDRI to other SAP tables.
MDRI table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| RQNUM | Requirements record number | RQNUM | NUMC | 10 | 0 | |||||||
| BAUGR | Planning material | PLMAT | MARA | CHAR | 18 | 0 | ||||||
| PLWRK | Planning Plant | PLWRK | T001W | CHAR | 4 | 0 | ||||||
| VERID | Production Version | VERID | MKAL | CHAR | 4 | 0 | ||||||
| RSART | Record type | RSART | CHAR | 1 | 0 | |||||||
| RQITM | Requirements totals record item | RQITM | NUMC | 5 | 0 | |||||||
| MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||||||
| PRVBE | Production Supply Area | PRVBE | PVBE | CHAR | 10 | 0 | ||||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | 0 |
Possible values
|
||||||
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 | 0 | ||||||
| BDTER | Requirement Date for the Component | BDTER | DATS | 8 | 0 | |||||||
| BDMNG | Requirement Quantity | BDMNG | QUAN | 13 | 3 | |||||||
| ENMNG | Quantity Withdrawn | ENMNG | QUAN | 13 | 3 | |||||||
MDRI foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MDRI | BAUGR | MDRI | MANDT | MARA | General Material Data | MANDT |
| MDRI | BAUGR | MDRI | BAUGR | MARA | General Material Data | MATNR |
| MDRI | LGORT | MDRI | WERKS | T001L | Storage Locations | WERKS |
| MDRI | LGORT | MDRI | LGORT | T001L | Storage Locations | LGORT |
| MDRI | LGORT | SYST | MANDT | T001L | Storage Locations | MANDT |
| MDRI | MANDT | MDRI | MANDT | T000 | Clients | MANDT |
| MDRI | PLWRK | SYST | MANDT | T001W | Plants/Branches | MANDT |
| MDRI | PLWRK | MDRI | PLWRK | T001W | Plants/Branches | WERKS |
| MDRI | PRVBE | SYST | MANDT | PVBE | Production Supply Area | MANDT |
| MDRI | PRVBE | MDRI | WERKS | PVBE | Production Supply Area | WERKS |
| MDRI | PRVBE | MDRI | PRVBE | PVBE | Production Supply Area | PRVBE |
| MDRI | SOBKZ | SYST | MANDT | T148 | Special Stock Indicator | MANDT |
| MDRI | SOBKZ | MDRI | SOBKZ | T148 | Special Stock Indicator | SOBKZ |
| MDRI | VERID | SYST | MANDT | MKAL | Production Versions of Material | MANDT |
| MDRI | VERID | MDRI | BAUGR | MKAL | Production Versions of Material | MATNR |
| MDRI | VERID | MDRI | PLWRK | MKAL | Production Versions of Material | WERKS |
| MDRI | VERID | MDRI | VERID | MKAL | Production Versions of Material | VERID |
| MDRI | WERKS | MDRI | WERKS | T001W | Plants/Branches | WERKS |
| MDRI | WERKS | SYST | MANDT | T001W | Plants/Branches | MANDT |
