Skip to Content

BOM selection logic in MRP

June 3, 2015 | 5,411 Views |
Follow

The BOM selection logic is quite complex as several customizations and fields of the material master are involved, so I am summarizing it here.

First of all, the BOMs of a material may exist in the architecture below.

1. Usage: e.g. production BOM, costing BOM, engineering BOM etc.
2. Multiple BOM: Multiple alternative BOMs under one usage.
3. BOM change status: Different BOM items/quantities etc in different periods which can be made by change numbers.

Please see the picture below.

BOM structure.JPG
The BOM determination in MRP is done level by level through the structure above and by the procedure below.

BOM determination.JPG

Here is the detail of the steps.

Step 1: Determine the BOM usage.

The usage is determined by the selection ID which can be configured in customizations below. In the MRP customization, the selection ID to be used is defined on plant level and the BOM customization OS31 defines the priorities of each BOM usage. If there is no BOM exists under the usage of the first priority, the usage of the next priority is checked.
Selection ID.JPG

Step 2: Determine a BOM in the multiple alternative BOMs.

This is decided by the field ‘Selection method’ of the material master in the picture below.

Selection method of material master.JPG

2.1 Selection method is blank (Selection by order quantity):

The quantity range of each BOM header is checked to see which BOM can be applied according to the order quantity, here is a picture for an example.Selection by order quantity.JPG

Here is the screen shot of the quantity range of multiple BOMs.

Selection by order quantity and screen shot.JPG

2.2 Selection method is 1 (Selection by the explosion date):

To use this method, the customization of the picture below should be maintained.

Customization of BOM explosion date.JPG
In the example above, the alternative BOM 1 is valid from May 1 to May 31 and the BOM 2 is valid since June 1. They are selected by the explosion date, either the order start date or the end date or the date of the explosion number according to the customization transaction OMIW in the picture below.
The one of the MRP group has higher priority.

Customization of explosion date OMIW.JPG

2.3 Selection method is 2 or 3 (Selection by production version):

The production version can be maintained in the material master and it defines both the BOM usage and alternative BOM as the picture below.Production version screen shot.JPG

Step 3: Determine the valid BOM according to the BOM change status.

A valid BOM is determined by the explosion date in multiple periods of an alternative BOM as shows in the picture below, the periods can be made by change numbers.
BOM Change status.JPG

The explosion date is the one explained in the step 2.2 and here is more information of the date of explosion number. Using the explosion number all levels of BOM are exploded by the same date of the explosion number as showed in the picture below instead of the start or the end date of planned orders in each level.

Date of exploson number.JPG

Here is the explosion number maintenance transactin MDSP and the fields where the explosion number can be entered in the PIR (Planned Independent Requirements) and sales order.

Explosion number.JPG

Additional checking points:

1. BOM header

BOM header.JPG
2. BOM Item:

BOM Item.JPG

The BOM item should be relevant to production.

3. Customization of specific BOM explosion:

Sales Orer WBS BOM.JPG
The field ‘Excl.Bulk Mat.’ controls if the bulk materials can be exploded.
The field ‘Sales Order/WBS’ can check whether the sales order BOMs or WBS BOMs can be exploded if they have.

4. BOM buffering:

BOM Buffering.JPG

To improve the performance of MRP, the exploded BOM can be buffered and MRP reads that onward instead of reading from tables unless the BOM is changed. Please pay attention to the statements below in the F1 help of the field above.

********************************************************************

Note that you should not switch off this indicator and then switch it on again a short time later, because then the BOM time stamps are no longer current. In this case, the wrong BOMs could be used. However, you can delete the buffered BOMs in the shared buffer using the report RMMDBOM1.
********************************************************************

For more information, please refer to blog Problems with BOM explosion on MRP (exception message 52, exception message 53, performance…).

To report this post you need to login first.

20 Comments

You must be Logged on to comment or reply to a post.

      1. Caetano Almeida

        Hi Leon

        Exellent document. I would also add that on the customizing transaction OPPQ there is a setting to define if the sales/WBS BOM will be exploded or not, when they exist.

        BR
        Caetano

        (0) 
  15. Former Member

    Hello Leon ,
    Very good document.
    I understood all points, but have confusion over BOM explosion number.
    We define key date for bom explosion number , then system check in Alternative determination of Multiple BOM for in which periods the key date falls and determine alternative BOM. (  is this right understanding ?? )
    Then After MRP run, Is  system choose key date as order start or finish date depending on setting in transaction OMIW ???

    Thanks and Regards,
    Rahul

    (0) 
  16. Chin Joo Neo

    Hi

    I;ve done my settings for Alternative BOM

    I’ve done the seettings for VOV7

    My Sales Order is showing me the ALT BOM to select but my MRP (MD04) isnt exploding my ALT BOM 2

    Can you advise?

    (0) 

Leave a Reply