Find Bottlenek material ( latest date) for materials in delivery group or complete delivery

[Andrea66]

Hello, 

we have a huge number of sales orders with 100-200 lines in each order. All lines depend to 2-3 delivery groups.

No we were asked to tell Sales which material is the bottlenek and what would be the dates when we exlucde this bottlenk material from the group.  Deleting the group, run ATP and set group again is nto a good work around due to so many differnt order lines and groups. Any idea how to get this solved ? Getting the info about all ATP dates for each line when not having the groups ?

thanks Andrea 

[Lakshmipathi · Accepted solution]

If you want to identify customer specific stock, then, one option is to have the item category configuration with "E" which is treated as special stock.  If the current process is such that goods issue happens from unrestricted, then, it is not possible to meet your expectation because, even the unrestricted stock is dynamic and keep changing depending upon the number of sales order being generated.  Of course, I am not sure on your current ATP configuration, but there is an option to reserve the stock against sale orders but this has many disadvantages from Management point of view.  The sales team creates sale orders on their regular customers just to block the stock.

[Lakshmipathi]

You can table join VBAK, VBEP with MARD.  Table MARD will have fields like MATNR, WERKS, LGORT & LABST.  Field LABST will show the unrestricted stock available for a given plant.  So, you can consolidate this data and accordingly, identify those bottleneck materials for which, the stock (field LABST) would be zero.

[Andrea66]

thank you, this will probably not help, I need to know also he ones with different supply dates. And also only stock will not help as probably this stock is reserved for any other customer, so I would need a kind of ATP qty not only the stock info . Our IT said this would be huge developement ( having different ATP rules in different plants and products) so I thaought I can ask here if someone has an idea

[Lakshmipathi]

Out of 100 line items in sales order, how do you identify a material is bottleneck ?  Is there any unique field maintained for that in material master or sales order ?

[Andrea66]

I want to see the bottlenek material in the sales order: Example 30 order lines in delivery group 1, all dates are confirmed on date in December because ONE material has supply in december ( ATP), all other lines would have stock or a supply next month. So how can I easily! find this one material with the latest date in december ?

[Lakshmipathi]

You can pull out a report from table VBEP where you get the following values

• EDATU - Confirmed Quantity Date (date on which PGI will happen)
• BMENG - Confirmed quantity

[Andrea66]

Hi, thank you ! But ATP run based on the delivery group and all lines are confirmed on last date of bottlenek material. But I want to see the "possible " ATP dates from each line even I have a delivery group