Material requirement report

The Material requirement report shows the requirement of selected work orders, BOM items or assemblies.

In this manner, the order-related requirement can be checked, and purchase orders can be created.

PATH: Production > Work orders > right-click an entry > select "

Material Requirements".

The list can be called up from work order structure, work order list, work order, work order item and others.

Up to 6 additional fields can be defined for this list. This works only for work orders. Material requirement calculation for sales orders does not consider templates.

Sorting and filtering is not possible on SQL-level.

The content of this window is loaded after opening and using an object. It behaves differently than most other windows and has various limitations: sorting and filtering by these fields on SQL level is not possible.

linked tables:

BEAS_FTHAUPT, BEAS_FTPOS, BEAS_FTSTL, OITM (Assembly), OITM2 (Material), OITW (Warehouse Material)

Function

Description

Reload

Build up the list new (for example after goods have been issues).

Invent.History

Open Inventory history.

Issue

Open manual issue window. Fields are pre-allocated for the selected item.

Purchase request

A Purchase request is created for all rows for which a quantity and a supplier were stored. After this, quantity fields are cleared and the value in "purchases" rises.

It is only visible if you activate this functionality. See function Order.

Note:

Current SAP Purchase request not supported

Order

Create a purchase order

It is possible to create an order only for the selected line after you have inserted an order quantity.

After this, the quantity field is cleared and the value in "purchases" rises.

Function is available only if the field "purchase quantity", "delivery date", "Supplier" and "Price" is displayed.

Activation steps:

1. Open Window settings

2. Activate the fields

3. Close Window settings and material requirements

4. Reopen this window. The functionality is now available.

WO_Mat_req_WindSet

List Purchase requests

List of purchase requests is opened.

Only available if you activate this function. See function Order.

See Purchase request

External operation

This switch is visible only if, at least, one external operation was stored in the selected work order or WO position.

The window External operation – collective purchase is opened. This provided central access on material and services.

Filter: Requirement

Requirement for Filter means: Planned Quantity - Booked Quantiity > 0

For negative BoM Positions: (-1) * Planned Quantity - Receipt Quantity > 0

If Required Quantity 0 displayed is activated in Configuration wizard > Production > Material Posting > Backflushing, the formula is the following:

Requirement for Filter: Planned Quantity - Booked Quantiity >= 0

For negative BoM Positions: (-1) * Planned Quantity - Receipt Quantity >= 0

Note:

This Requirement is not the Quantity which you see in column "Requirement", because in the column "Requirement" the system is checking the reserved Quantity (Planned Quantity - Booked Quantity - Reserved Quantity)