# SAP MRP Controller Daily Worklist Template

> Source: https://netray.co/tools/sap-mrp-controller-worklist-template
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

A fill-in daily worklist for MRP controllers to record exception reviews, actions taken and open items from MD04, MD06 and MD07.

## Category

sap

## Erp

SAP S/4HANA

## Industry

Discrete Manufacturing

## Audience

- MRP controller
- Production planner
- Supply chain manager

## Tool

**Kind:** template

**Output:** document

**Fields:**

#### Company

**Key:** company

**Type:** text

**Default:** Acme Precision Ltd

#### Plant

**Key:** plant

**Type:** text

**Default:** 1010

#### MRP controller code

**Key:** mrp_controller

**Type:** text

**Default:** P01

#### Planner name

**Key:** planner

**Type:** text

**Default:** A. Planner

#### Date

**Key:** date

**Type:** date

**Default:** 2026-10-20

#### Last MRP run completed

**Key:** mrp_run

**Type:** text

**Default:** 2026-10-20 02:30

#### Reschedule in messages (10)

**Key:** reschedule_in

**Type:** number

**Default:** 18

#### Reschedule out messages (15)

**Key:** reschedule_out

**Type:** number

**Default:** 12

#### Cancel process messages (20)

**Key:** cancel

**Type:** number

**Default:** 5

#### Below safety stock messages (96)

**Key:** safety

**Type:** number

**Default:** 3

#### Top priorities today

**Key:** priorities

**Type:** textarea

**Default:** 1. Expedite PO for bearing housing, shortage on order 1000214
2. Convert planned orders for family 4400 inside the firming horizon
3. Review cancel messages on obsolete revision parts

#### Blockers and escalations

**Key:** blockers

**Type:** textarea

**Default:** Supplier confirmation pending on two POs. Engineering to confirm BOM change on assembly A-2200.

**Blocks:**

#### Daily MRP Controller Worklist

**Body:** Company: {{company}}
Plant: {{plant}}
MRP controller: {{mrp_controller}}
Planner: {{planner}}
Date: {{date}}
Last MRP run: {{mrp_run}}

#### Exception summary (MD06 or MD07)

**Table:**

**Columns:**

- Exception
- Meaning
- Count
- Cleared today

**Rows:**

**0:** 10

**1:** Reschedule in

**2:** {{reschedule_in}}

**0:** 15

**1:** Reschedule out

**2:** {{reschedule_out}}

**0:** 20

**1:** Cancel process

**2:** {{cancel}}

**0:** 96

**1:** Below safety stock

**2:** {{safety}}

#### Priorities

**Body:** {{priorities}}

#### Action log

**Table:**

**Columns:**

- Material
- MD04 element
- Action
- Owner
- Due
- Status

**Rows:**

#### Blockers and escalations

**Body:** {{blockers}}

#### Sign off

**Signatures:**

- MRP controller
- Supply chain manager

**Notes:** Exception numbers 10, 15, 20 and 96 are standard SAP MRP exception messages. If your exception groups are customized, adapt the summary table to your own list.

## Content

**Intro:** MRP does not finish when the run completes. The controller still has to work the exceptions, convert or firm orders and chase purchasing. This template turns that daily routine into a one page record you can hand to a manager or a colleague on shift change.

**Sections:**

#### How to use the worklist

**Body:** Start the day after the planning run. Open MD07 or MD06 for your MRP controller, count the exception messages by type and enter them in the summary. Then list the top priorities and log each action against a material and MD04 element. Print or export it to PDF at the end of the shift so the next planner sees what is open and who owns it.

**Bullets:**

- Fill the counts from MD06 before you start acting
- Log one line per material, not per message
- Record the owner so purchasing and production see their items

#### Which exceptions to work first

**Body:** Work shortages and late supply before cosmetic messages. A reschedule in (10) on a purchase order for a material that is short today usually matters more than ten reschedule out (15) messages on safe stock. Cancel process (20) messages free money and capacity but need a check that no demand was hidden by a planning time fence. Messages below safety stock (96) point to demand surprises or stale safety stock values.

#### Using it as a handover and KPI source

**Body:** Keep the daily sheets in a shared folder. After a month you can see which materials generate repeat exceptions, which suppliers need follow up and how long messages stay open. That feeds MRP parameter reviews, for example lot size, planned delivery time and safety stock. If you track exception counts per controller you can balance workload across planners.

#### Common mistakes

**Body:** Clearing messages in bulk without checking the underlying supply hides real problems. Firming planned orders that MRP will otherwise move creates nervous schedules. Not recording the MRP run time means nobody knows if the numbers are from today or yesterday.

**Bullets:**

- Check the run timestamp before acting
- Do not reschedule firmed orders silently
- Review the top repeat offenders weekly

**Cta:** If your controllers spend an hour a day pulling MD04 data into spreadsheets, we can build an assistant on your SAP data that prepares this worklist automatically, with human approval for any change.

**Faq:**

#### Is this an official SAP form?

**Answer:** No. It is a practical working document. The exception numbers follow SAP MRP exception messages, but the layout is ours so you can adapt it to your plant and your customized exception groups.

#### Should I use MD04 or MD07 for the daily review?

**Answer:** Use MD07 or MD06 to see which materials have exceptions across your controller, then open MD04 for each material to read the detailed elements and act. MD04 is the single material view and MD06 is the collective list.

#### How many exception messages is normal?

**Answer:** It depends on master data quality, planning time fences and how often supply changes. A rising count with no change in volume often points to bad lead times or lot sizes. Track your own trend instead of a generic target.

#### Can I change the exception list in the template?

**Answer:** The summary rows are fixed to common exceptions, but you can edit the exported document or Excel file to add rows for the messages your plant uses. Your configuration decides which exceptions are active.

## Search terms

sap mrp controller worklist, mrp controller daily checklist template, sap md04 daily review template, mrp planner daily report format, sap md06 exception review, sap mrp controller handover, mrp exception action log template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json