MRP Table Items — line items of an MRP list (MDKP header), one row per MRP element (planned order, purchase requisition, sales order, stock, etc.) with dates, quantities, and exception-message keys. The demand-side item record of what the system decided to make or buy. Wide table — carries the full field set as published by the source (60 fields), including all date/quantity/source-reference fields; no truncation applied.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | — |
| NUM_MAT_CNS key | numerus materia consilium | Number of material requirements planning table | DTNUM | NUMC 10 | — |
| POS_NUM key | positio numerus | Item number of MRP list | DTPOS | NUMC 6 | — |
| IDX_CNS_SEG | index consilium segmentum | Indicator for planning segment | PLAKZ | CHAR 1 | — |
| CNS_SEG_NUM | consilium segmentum numerus | Planning segment number | PLANR | CHAR 20 | — |
| DIE | dies | Receipt/Requirements date | DAT00 | DATS 8 | — |
| IDX | index | Sort indicator 01 | SORT1 | CHAR 1 | — |
| IDX2 | index | Sort indicator 02 | SORT2 | CHAR 2 | — |
| ELM | elementum | MRP element | DELKZ | CHAR 2 | — |
| STA | status | Processing Status | VSTAT_D | CHAR 1 | — |
| IDX3 | index | Availability indicator | VRFKZ | CHAR 1 | — |
| IDX4 | index | Receipt/issue indicator | PLUMI | CHAR 1 | — |
| QNT | quantitas | Quantity received or quantity required | MNG01 | QUAN 13,3 | — |
| QNT2 | quantitas | Variable scrap quantity | MNG02 | QUAN 13,3 | — |
| QNT3 | quantitas | Shortage Quantity | MNG03 | QUAN 13,3 | — |
| TRD_MND_FIN | traditio mandatum finis | Delivery/order finish date | DAT01 | DATS 8 | — |
| INI_EMS_DIE | initium emissio dies | Start/release date | DAT02 | DATS 8 | — |
| DIE2 | dies | Opening date | DAT03 | DATS 8 | — |
| PER_IDX | periodus index | Period Indicator | PERKZ | CHAR 1 | — |
| PVS_PER | praevisio periodus | Forecast period | PRPER | NUMC 6 | — |
| AMR_TMP | acceptio mercium tempus | Goods Receipt Processing Time in Days | WEBAZ | DEC 3 | — |
| IDX_MGN_MND | index magnitudo mandatum | Indicator: fixeing lot size in planned order | FIX01 | CHAR 1 | — |
| IDX_MND | index mandatum | Indicator: fixing explosion in planned order | FIX02 | CHAR 1 | — |
| GMD | genus mandati | P.O./Order type | BAART | CHAR 4 | — |
| GEN | genus | Procurement Type | BESKZ | CHAR 1 | — |
| GEN2 | genus | Special procurement type | SOBES | CHAR 1 | — |
| IDX5 | index | Special G/L Indicator | UMSKZ | CHAR 1 | T074U |
| CNS_GEN | consilium genus | Planning type | PLART | CHAR 1 | — |
| CLV | clavis | Exception message key | AUSSL | CHAR 2 | T458A |
| CNS_PRD_OFC | consilium productio officina | Planning/production plant | WRK02 | CHAR 4 | T001W |
| LOC | locus repositionis | Storage Location | LGORT_D | CHAR 4 | — |
| ELM_NUM | elementum numerus | MRP element number | DELNR | CHAR 10 | — |
| ELM_POS | elementum positio | MRP element item | DELPS | NUMC 6 | — |
| LOR_NUM_ELM | linea ordinis numerus elementum | Schedule Line Number MRP Element | DELET | NUMC 4 | — |
| FNS_NUM_MND | fons numerus mandatum | Source number for order | AUFVR | CHAR 10 | — |
| FNS_POS_NUM | fons positio numerus | Source item number | POSVR | NUMC 6 | — |
| FNS_LOR_NUM | fons linea ordinis numerus | Source schedule line number | EINVR | NUMC 4 | — |
| IDX_ELM | index elementum | Indicator: MRP element can be brought forward | UKZ01 | CHAR 1 | — |
| DIE3 | dies | Rescheduling date | UMDAT | DATS 8 | — |
| ELM_NUM2 | elementum numerus | MRP element number | DEL12 | CHAR 12 | — |
| MAT_NUM_GRD | materia numerus gradus | Material number of higher-level assembly | BAUGR | CHAR 18 | MARA |
| ELM2 | elementum | MRP element | DELKZ | CHAR 2 | — |
| VRS_NUM | versio numerus | Version number for independent requirements | VERSB | CHAR 2 | — |
| CLV2 | clavis | Key of the second exception message | OLDSL | CHAR 2 | T458A |
| CPA_QNT | copia quantitas | Excess stock quantity | RDMNG | QUAN 13,3 | — |
| MAT_CNS_SEG | materia consilium segmentum | Material requirements planning segment | PLAAB | NUMC 2 | — |
| VIC_IDX | vicis index | Daily shift (sort indicator 0) | TAG00 | NUMC 2 | — |
| IDX6 | index | Exception indicator | ABEKZ | CHAR 1 | — |
| PRD_MND_STA | productio mandatum status | Production order status: internal ind. for MRP | MDFST | CHAR 1 | — |
| QNT_CMP_CPA | quantitas campus copia | MRP: quantity field (stock in transit, receipt qty, ...) | MDMNG | QUAN 13,3 | — |
| PRD_VRS | productio versio | Production Version | VERID | CHAR 4 | — |
| CNS_OFC | consilium officina | Planning Plant | PLWRK | CHAR 4 | — |
| NUM | numerus | BOM explosion number | SERNR | CHAR 8 | — |
| GRD | gradus | Revision Level | REVLV | CHAR 2 | — |
| IDX7 | index | Direct procurement indicator | DBSKZ | CHAR 1 | — |
| IDX8 | index | Indicator for External Procurement | EXTNL | CHAR 1 | — |
| CMP | campus | Field for Additional Information | MD_ADINF | CHAR 4 | — |
| LOC_CPA_MND | locus repositionis copia mandatum | Issuing Storage Location for Stock Transport Order | RESLO | CHAR 4 | — |
| RQS | requisitum | Requirement Urgency | PRIO_URG | NUMC 2 | PURG |
| RQS_PRI | requisitum prioritas | Requirement Priority | PRIO_REQ | NUMC 3 | PREQ |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
AUSSL | T458A | MANDT |
AUSSL | T458A | AUSSL |
BAUGR | MARA | MANDT |
BAUGR | MARA | MATNR |
OLDSL | T458A | MANDT |
OLDSL | T458A | AUSSL |
PRIO_REQ | PREQ | MANDT |
PRIO_REQ | PREQ | PRIO_REQ |
PRIO_URG | PURG | MANDT |
PRIO_URG | PURG | PRIO_URG |
UMSKZ | T074U | MANDT |
UMSKZ | T074U | UMSKZ |
WRK02 | T001W | MANDT |
WRK02 | T001W | WERKS |