Skip to Content
Technical Articles
Author's profile photo Former Member

Stock/Requirements List

The Stock requirement list is used to display the real time stock situation and all the demand and supply elements. This is (arguably) the most important report for the logistics function in SAP as it displays anything and everything happening in the logistics area. This is a dynamic list which displays real time situation every time the report is executed using the Transaction Code: MD04.

Demand Elements: MRP elements which generates the requirement for the material stock and thus credit (or reduce) the stock in the Plant or warehouse is called as Demand elements. Demand Elements are, thus, represented as ‘-ve’ stock in Stock Requirement list (Transaction Code: MD04).

Some of the most common Demand elements which are displayed in MD04 are as follows:

  • Concrete demands for Finished Goods from customer in terms of Sales order or schedule lines
  • Planned Independent Requirements for Finished Goods coming up from S&OP – Sales forecast.
  • Material Reservations
  • Dependent Requirements for a Semi finished or Raw material.

Supply elements: MRP elements which fulfills the requirements and thus debit (or add) the stock in the Plant or warehouse is called a supply element. Supply elements are represented with ‘+ve’ stock in Stock Requirement list (Transaction Code: MD04).

Some of the most common Supply elements which are displayed in MD04 are as follows:

  • Purchase Requisition for externally procured materials which are then converted to Purchase order
  • Planned order for inhouse produced materials which are subsequently converted to Production order.

 

Figure 1: Stock Requirement List

The first row always displays the ‘Stock’ which is the current stock in the plant.

The stock requirement list displays various fields like Date, MRP Element, MRP Element data, Rescheduling date, exception message, Receipt/Requirement Quantity, Available quantity, storage location and production version.  You can also display Vendor and customer.

Date displays the of the demand/supply element.

MRP Element displays the demand/supply element like independent requirement, planned order, sales order, delivery, production order etc.

MRP Element data displays a lot of information for the MRP element like:

  • The customer order number, delivery number, planned order number, production order number etc.
  • The requirement type for the Independent requirement like VSF, LSF etc. which displays if the requirement is for make-to order or make-to stock scenario.
  • If the planned order is firmed.
  • Displays the production order number and order type. It also displays if the order has been released.

Receipt/Requirement Quantity displays the quantity of the demand/supply element. Demand elements quantities are displayed as negative while supply element quantities are displayed as positive.

Available Quantity displays the net stock that would be available on a date based on demand & supply elements.

The system generates the exception messages to attract Planner’s attention. The planner can double click on the exception message and view the details of the exception message at the bottom of the screen. In the Figure 1, we can see the exception message ‘10’ which means ‘Reschedule In’ which is one of the most common exception messages a planner would observe. Another common exception message is ‘15’ which means ‘Reschedule Out’. For rescheduling exception messages, system proposes a date in the Rescheduling Date’ column.

Table below shows a list of exception messages available in Stock Requirement list together with the selection groups:

Table: Exception messages

Selection Group Exception No. Exception Message
1 69 Recursive BOM components possible
2 New, and opening date in the past
5 Opening date in the past
2 3 New, and start date in the past
6 Start date in the past
63 Production start before order start
3 4 New, and finish date in the past
7 Finish date in the past
64 Production finish after order finish
4 1 Newly created order proposal
42 Order proposal has been changed
44 Order proposal re-exploded
46 Order proposal has been manually changed
61 Scheduling: Customizing inconsistent
62 Scheduling: Master data inconsistent
80 Reference to retail promotion
82 Item is blocked
5 50 No BOM exists
52 No BOM selected
53 No BOM explosion due to missing config.
55 Phantom assembly not exploded
6 25 Excess stock
26 Excess in individual segment
27 Excess Stock Applied to Superceding Mat.
27 Underdelivery tolerance
40 Coverage not provided by master plan
56 Shortage in the planning time fence
57 Disc. matl partly replaced by follow-up
58 Uncovered reqmt after effective-out date
59 Receipt after effective-out date
60 Disc., Rec. Applied to Superceding Mat.
70 Max. release qty – quota exceeded
96 Stock fallen below safety stock level
7 10 Reschedule in
15 Reschedule out
20 Cancel process
30 Plan process according to schedule
8 98 Abnormal end of materials planning

Figure 2: Order Report

You can click on the button ‘Show Overview Tree’ to display ‘Order Report as shown in Figure 2. You can display all the components which are required for the order. This is a multilevel report which displays the components and their receipt elements. The order report can help you determine any potential issues in production of the assemblies or procurement of the components. The order report can also be executed using the Transaction Code: MD4C.

 

There is a common misconception that Stock Requirement list is relevant for production planners or production supervisor only. However, the fact is that MD04 is the most important report as it gives a quick snapshot of everything happing within the supply chain. It displays information not only for production but also from other business functions like sales and distribution, materials management, inventory management, quality management etc.

 

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Dominik Tylczynski
      Dominik Tylczynski

      That is a nice intro to MD04. One point to note is that stock/requirements list should be used to balance supply and demand. It should never ever be used to check stock availability. Use CO09 instead - see https://answers.sap.com/questions/13603964/component-unrestricted-stock-is-available-but-duri.html?childToView=13601019