# SAP MRP Material Parameters Worksheet

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

## Short answer

An editable worksheet for reviewing MRP view settings per material, with total replenishment lead time and a safety stock coverage check.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- SAP PP consultant
- Production planner
- MRP controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Material

**Key:** material

**Type:** text

#### MRP type

**Key:** mrp_type

**Type:** select

**Options:**

- PD
- VB
- VM
- ND
- VV

#### MRP controller

**Key:** ctrl

**Type:** text

#### Procurement type

**Key:** proc

**Type:** select

**Options:**

- E In-house
- F External
- X Both

#### Lot size key

**Key:** lot

**Type:** select

**Options:**

- EX
- FX
- HB
- WB
- MB

#### Safety stock

**Key:** ss

**Type:** number

#### Avg daily usage

**Key:** daily

**Type:** number

#### Replenishment lead time (days)

**Key:** lead

**Type:** number

#### Safety stock days

**Key:** ss_days

**Type:** number

**Expr:** ss / daily

**Format:** decimal

#### Lead time demand

**Key:** rop

**Type:** number

**Expr:** daily * lead

**Format:** number

**Rows:**

**Material:** FG-2210

**Mrp type:** PD

**Ctrl:** P01

**Proc:** E In-house

**Lot:** EX

**Ss:** 40

**Daily:** 20

**Lead:** 8

**Material:** RM-100-455

**Mrp type:** PD

**Ctrl:** P02

**Proc:** F External

**Lot:** FX

**Ss:** 600

**Daily:** 120

**Lead:** 21

**Material:** SF-3301

**Mrp type:** PD

**Ctrl:** P01

**Proc:** E In-house

**Lot:** EX

**Ss:** 0

**Daily:** 35

**Lead:** 5

**Material:** CON-0087

**Mrp type:** VB

**Ctrl:** P03

**Proc:** F External

**Lot:** HB

**Ss:** 0

**Daily:** 4

**Lead:** 10

**Material:** RM-200-120

**Mrp type:** PD

**Ctrl:** P02

**Proc:** F External

**Lot:** WB

**Ss:** 200

**Daily:** 50

**Lead:** 14

**Totals:**

#### Total safety stock units

**Key:** ss

**Agg:** sum

**Format:** number

**Summary:**

#### Average safety stock days

**Key:** avg_ss_days

**Expr:** sum_ss_days / count

**Format:** decimal

**Primary:** true

#### Materials listed

**Key:** mats

**Expr:** count

**Format:** integer

**Notes:** MRP type codes shown are standard examples: PD is MRP, VB is manual reorder point, VM is automatic reorder point, ND is no planning, VV is forecast-based. Lot size keys: EX lot for lot, FX fixed, HB replenish to maximum stock, WB weekly, MB monthly. Your customizing may add more.

## Content

**Intro:** Material master MRP views hold dozens of settings and most plants never review them as a set. This worksheet lets a planner list the key parameters and see lead time demand and safety stock days at a glance.

**Sections:**

#### How to use the worksheet

**Body:** Export or type the materials you want to review, then fill MRP type, controller, procurement type, lot size key, safety stock, average daily usage and total replenishment lead time. The sheet calculates safety stock days and demand over lead time. Sort outliers, correct them in the material master, and keep the exported file as the baseline.

#### What the numbers mean

**Body:** Safety stock days is the safety stock divided by daily usage. Very low values on long lead time parts suggest stockout risk, very high values suggest excess working capital. Lead time demand shows how much will be consumed while you wait for replenishment. Total replenishment lead time in SAP is the planned delivery time plus goods receipt processing time for external parts, or in-house production time for made parts.

**Bullets:**

- Under 1 day of safety stock on a long lead time part is a flag
- Check MRP type matches planning intent
- Lot for lot suits high-value items
- Check controller assignment

#### Common mistakes

**Body:** Leaving obsolete planned delivery times that no longer reflect supplier reality is a top issue. Using fixed lot size where lot for lot is intended inflates stock. Setting safety stock by habit instead of variability wastes cash.

**Cta:** Netray can compare these parameters to real consumption and supplier performance in your SAP data and suggest corrections.

**Faq:**

#### What is the difference between MRP type PD and VB?

**Answer:** PD is deterministic MRP driven by requirements and receipts. VB is manual reorder point planning, where an order proposal is created when stock falls to the reorder point you maintain.

#### Where is total replenishment lead time in SAP?

**Answer:** It is calculated from planned delivery time, goods receipt processing time or in-house production time depending on procurement type. Scheduling in the routing can also determine in-house lead time.

#### How is safety stock set?

**Answer:** It can be entered manually or derived from a range of coverage profile. Neither is automatic statistics, so many plants calculate it outside and load it in.

#### Can I load changes in bulk?

**Answer:** Yes. Mass change tools or the migration cockpit can update many materials. Always test in a quality system first.

## Search terms

sap mrp parameters excel, sap mrp view worksheet, sap material master mrp settings template, sap safety stock review excel, sap planned delivery time worksheet, sap mrp 1 mrp 2 fields, sap mrp parameter review

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