# SAP ECC MRP Tables and MRP Element (DELKZ) Codes > Source: https://netray.co/tools/sap-ecc-mrp-tables-and-mrp-element-codes-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer The SAP ECC tables behind MRP (planning file, MRP areas, controllers, groups, planned orders) and the DELKZ codes for each MRP element with its source table. ## Category sap ## Erp SAP ECC 6.0 ## Audience - SAP PP consultant - ABAP developer - MRP controller - SAP support analyst ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Section **Key:** sec **Type:** select **Options:** - A: Table - B: DELKZ code #### Table / DELKZ **Key:** obj **Type:** text #### Description / meaning **Key:** desc **Type:** text #### Key or main fields / source table **Key:** keys **Type:** text #### Use **Key:** use **Type:** text **Rows:** **Sec:** A: Table **Obj:** MDKP **Desc:** Header of the stored MRP list per material, plant and MRP area **Keys:** DTNUM; MATNR, PLWRK, BERID, DISPO **Use:** Find the MRP list number for a material, then read MDTB **Sec:** A: Table **Obj:** MDTB **Desc:** MRP list items with MRP element (DELKZ), dates and quantities **Keys:** DTNUM, DTPOS; DELKZ, DELNR, DAT00, MNG01, PLUMI, AUSSL **Use:** Stored result of the last MRP run as shown in MD05 **Sec:** A: Table **Obj:** MDVM **Desc:** Planning file entries at plant level **Keys:** MAFID, MDKEY (material and plant); GSAEN, AKKEN, RESAL **Use:** Which materials will the next net change run plan (plant level planning) **Sec:** A: Table **Obj:** DBVM **Desc:** Planning file entries including MRP area **Keys:** MAFID, DISST, MATNR, BERID; GSAEN, AKKEN, RESAL **Use:** Planning file when MRP areas are active; check with MD21 **Sec:** A: Table **Obj:** MDLV **Desc:** MRP area definitions **Keys:** BERID; BERTY, WERKS **Use:** List MRP areas and their type (plant, storage location, subcontractor) **Sec:** A: Table **Obj:** MDLG **Desc:** Storage locations assigned to an MRP area **Keys:** BERID, WERKS, LGORT **Use:** Which storage locations belong to a storage location MRP area **Sec:** A: Table **Obj:** MDMA **Desc:** MRP area data for a material **Keys:** MATNR, BERID; WERKS, DISMM, DISPO, DISLS, MINBE **Use:** MRP parameters that override MARC for one MRP area **Sec:** A: Table **Obj:** T024D **Desc:** MRP controllers **Keys:** WERKS, DISPO; DSNAM **Use:** Name of MRP controller and mail settings **Sec:** A: Table **Obj:** T438A **Desc:** MRP types **Keys:** DISMM; DISVF procedure **Use:** Meaning of PD, VB, V1, ND and custom MRP types **Sec:** A: Table **Obj:** T438M **Desc:** MRP groups (group stored in field MTART) **Keys:** WERKS, MTART **Use:** Planning horizon, strategy group and other MRP group settings **Sec:** A: Table **Obj:** T439A **Desc:** Lot-sizing procedures **Keys:** DISLS **Use:** Meaning of EX, FX, WB, HB and custom lot sizes **Sec:** A: Table **Obj:** T399D **Desc:** MRP control parameters per plant **Keys:** WERKS; PLAHZ, UMTHZ, NKPAF, NKBAN **Use:** Plant parameters: planning horizon, number ranges, firming **Sec:** A: Table **Obj:** PLAF **Desc:** Planned orders **Keys:** PLNUM; MATNR, PLWRK, GSMNG, PSTTR, PEDTR **Use:** Open planned orders from MRP **Sec:** A: Table **Obj:** EBAN **Desc:** Purchase requisitions **Keys:** BANFN, BNFPO; MATNR, WERKS, MENGE, LFDAT **Use:** Requisitions created by MRP (ESTKZ shows the creation indicator) **Sec:** A: Table **Obj:** RESB **Desc:** Reservations and dependent requirements **Keys:** RSNUM, RSPOS, RSART; MATNR, BDMNG, BDTER **Use:** Dependent requirements of planned and production orders **Sec:** A: Table **Obj:** PBIM **Desc:** Planned independent requirements, header per material **Keys:** MATNR, WERKS, BEDAE, VERSB, PBDNR; BDZEI **Use:** PIR versions and requirement types **Sec:** A: Table **Obj:** PBED **Desc:** Planned independent requirements, schedule lines **Keys:** BDZEI, PDATU; PLNMG **Use:** PIR quantities per period (join to PBIM on BDZEI) **Sec:** A: Table **Obj:** MARC (MRP fields) **Desc:** Plant data for material, MRP views **Keys:** MATNR, WERKS; DISMM, DISPO, DISLS, BESKZ, SOBSL, DISGR, EISBE, PLIFZ **Use:** Main MRP settings per plant **Sec:** B: DELKZ code **Obj:** AR **Desc:** Dependent reservation **Keys:** RESB **Use:** Requirement **Sec:** B: DELKZ code **Obj:** BA **Desc:** Purchase requisition **Keys:** EBAN **Use:** Receipt **Sec:** B: DELKZ code **Obj:** BB **Desc:** Subcontractor requirements of material provided **Keys:** RESB (subcontract PO components) **Use:** Requirement **Sec:** B: DELKZ code **Obj:** BE **Desc:** Purchase order item schedule line **Keys:** EKET **Use:** Receipt **Sec:** B: DELKZ code **Obj:** BR **Desc:** Process order **Keys:** AFKO / AFPO **Use:** Receipt **Sec:** B: DELKZ code **Obj:** FE **Desc:** Production order **Keys:** AFKO / AFPO **Use:** Receipt **Sec:** B: DELKZ code **Obj:** IH **Desc:** Maintenance order **Keys:** AUFK / AFIH **Use:** Order element **Sec:** B: DELKZ code **Obj:** KB **Desc:** Individual customer stock **Keys:** MSKA **Use:** Stock **Sec:** B: DELKZ code **Obj:** LA **Desc:** Shipping notification **Keys:** EKES **Use:** Receipt **Sec:** B: DELKZ code **Obj:** LE **Desc:** Scheduling agreement schedule line **Keys:** EKET **Use:** Receipt **Sec:** B: DELKZ code **Obj:** LK **Desc:** Stock with subcontractor **Keys:** MSLB **Use:** Stock **Sec:** B: DELKZ code **Obj:** MR **Desc:** Reservation **Keys:** RESB **Use:** Requirement **Sec:** B: DELKZ code **Obj:** NE **Desc:** Network order **Keys:** AUFK / AFKO **Use:** Order element **Sec:** B: DELKZ code **Obj:** PA **Desc:** Planned order **Keys:** PLAF **Use:** Receipt **Sec:** B: DELKZ code **Obj:** PB **Desc:** Project stock **Keys:** MSPR **Use:** Stock **Sec:** B: DELKZ code **Obj:** PP **Desc:** Planned independent requirement **Keys:** PBIM / PBED **Use:** Requirement **Sec:** B: DELKZ code **Obj:** QM **Desc:** Inspection lot for quality management **Keys:** QALS **Use:** Receipt **Sec:** B: DELKZ code **Obj:** SB **Desc:** Dependent requirement **Keys:** RESB **Use:** Requirement **Sec:** B: DELKZ code **Obj:** SH **Desc:** Safety stock **Keys:** MARC-EISBE / MDMA **Use:** Requirement **Sec:** B: DELKZ code **Obj:** U1 **Desc:** Release order for a stock transfer order **Keys:** EKET / EKPO in issuing plant **Use:** Requirement **Sec:** B: DELKZ code **Obj:** U2 **Desc:** Release order for a stock transfer requisition **Keys:** EBAN in issuing plant **Use:** Requirement **Sec:** B: DELKZ code **Obj:** U4 **Desc:** Release order for stock transport scheduling agreement **Keys:** EKET in issuing plant **Use:** Requirement **Sec:** B: DELKZ code **Obj:** UR **Desc:** Stock transfer reservation **Keys:** RESB **Use:** Requirement or receipt **Sec:** B: DELKZ code **Obj:** VC **Desc:** Sales order **Keys:** VBAP / VBEP **Use:** Requirement **Sec:** B: DELKZ code **Obj:** VE **Desc:** SD scheduling agreement **Keys:** VBEP **Use:** Requirement **Sec:** B: DELKZ code **Obj:** VJ **Desc:** Delivery **Keys:** LIPS **Use:** Requirement **Sec:** B: DELKZ code **Obj:** WB **Desc:** Plant stock **Keys:** MARD **Use:** Stock **Sec:** B: DELKZ code **Obj:** CH **Desc:** Batch stock **Keys:** MCHB **Use:** Stock **Sec:** B: DELKZ code **Obj:** JI **Desc:** JIT call **Keys:** JIT call tables **Use:** Requirement **Notes:** DELKZ meanings are the fixed values of the MRP element domain in SAP ECC 6.0 (field MDTB-DELKZ). Source tables show where the underlying document lives; MD04 reads them live rather than from MDTB. Check SE11 in your release for industry-specific values. ## Content **Intro:** This reference lists the SAP ECC 6.0 tables behind MRP and the most used MRP element codes (DELKZ) with the table each element comes from. It is for PP consultants and developers who need to report on MRP results or trace what MD04 is showing. **Sections:** #### Where MRP data lives in SAP ECC **Body:** The planning file (MDVM, or DBVM when MRP areas are active) tells the next run which materials changed; MD20 and MD21 maintain and display it, and MDAB or MDRE rebuild it. MRP itself runs with MD01 (total planning online), MDBT (total planning in background), MD02 (single item, multi-level) and MD03 (single item, single level). The run creates planned orders (PLAF), purchase requisitions (EBAN) and schedule lines, and dependent requirements in RESB. If you save MRP lists, MDKP and MDTB store the result per material as shown in MD05. MD04, the stock/requirements list, is built live from the source documents every time you open it, so it is always current while MD05 reflects the last run. MRP Live (MD01N) is S/4HANA only. **Bullets:** - MD04: live stock/requirements list - MD05: stored MRP list (MDKP / MDTB) - MD21: display planning file entries - MD06: collective MRP list display #### Worked example: exceptions for one MRP controller **Body:** To list exception messages for MRP controller 001 in plant 1000, read MDKP where PLWRK = 1000 and DISPO = 001 to get the DTNUM values, then read MDTB for those DTNUM where AUSSL is not blank. AUSSL holds the exception key (for example 10 reschedule in, 15 reschedule out, 20 cancel). DELKZ on each row tells you whether the line is a planned order (PA), purchase requisition (BA), PO schedule line (BE) or sales order (VC), and DELNR gives the document number. MD06 shows the same collective list on screen; MDKP and MDTB are only filled when the MRP run creates MRP lists (creation indicator in MD01 or the MRP group). #### Gotchas **Body:** MDTB is empty if MRP lists are not created, which is common after switching to MD04-only work. The MRP group is in T438M under field MTART, not DISGR, which confuses many SE16 queries. MRP areas move material parameters from MARC to MDMA; if a material has an MRP area, check MDMA before trusting MARC-DISPO. DBVM replaces MDVM as the planning file once MRP areas are activated in Customizing. Safety stock (SH) and plant stock (WB) are not documents, so they have no DELNR. #### How to check the result in the system **Body:** Open MD04 for the same material and plant and compare each line's element label with the DELKZ codes in this table. For a stored list, MD05 shows exactly what MDTB holds. If counts differ, the MRP list is older than the documents; rerun MD03 for that material and compare again. **Cta:** If your planners want to ask SAP ECC in plain English which orders are late against MRP and why, we can add a private AI layer over your MRP tables on your own servers. **Faq:** #### Which table stores the MRP controller in SAP? **Answer:** MRP controllers are defined in T024D (key plant and DISPO, with the name in DSNAM). The controller assigned to a material is MARC-DISPO, or MDMA-DISPO when the material is planned in an MRP area. Maintain them in Customizing under MRP controllers. #### Which table stores MRP areas? **Answer:** MDLV holds the MRP area definitions with type and plant, MDLG the storage locations assigned to a storage location MRP area, and MDMA the material data per MRP area. With MRP areas active, the planning file moves to DBVM, which includes the MRP area field BERID. #### What is the MRP element table in SAP? **Answer:** MDTB stores MRP list items with the MRP element code in DELKZ, such as PA planned order, BA purchase requisition, BE PO schedule line, VC sales order and SB dependent requirement. MDKP is its header. The documents themselves stay in PLAF, EBAN, EKET, VBEP and RESB. #### Where is the MRP group stored? **Answer:** The MRP group assigned to a material is MARC-DISGR. The MRP group definitions are in T438M, keyed by plant and the MRP group, which is stored in a field named MTART in that table. Maintain them in OPPR. ## Search terms sap mrp table, sap table for mrp controller, sap table for mrp area, sap table for mrp group, sap mrp element table, mrp table in sap pp, sap delkz values, mdtb delkz --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json