Over commit issue in Sales

[Former Member]

Hi gurus,

Due to sales org change in production some of the orders got over commit by ATP check.

By doing re atp check manually order quantity is getting corrected.

How to find list of affected orders.

Inputs are highly appriciated.

Thanks,

Bala B.

[Former Member · Accepted solution]

Hi Bala,

By 'over commit' if you stock gets blocked wrongly then you may run program SDRQCR21 for Recovery sales and delivery requirements to free the wrongly blocked stock.

Take care of the check box 'Data Transfer'.

Best regards,

Suman K Bhowmik.

[Former Member · Accepted solution]

Hi Suman,

SDRQCR21 is running in simulation. system is not identifying any order though i gave the corruped order, report is not identifying the faulty order.

Thanks,

Bala.

[phanikumar_v3]

Why over-commit?

Normally system confirms the quantity based on the scheduling(either backward/forward)

If the order quantity is 10 and there is only 5 qty available then system confirms the remaining qty by doing forward scheduling.

from your screen shot it is clear that (take example-24 line item the order quantity is 2 and initially there is no available Qty so schedule line number 1 shows ZERO and has been confirmed in the subsequent schedule line numbers..

Can you please confirm what was the issue make you think like above??

Phanikumar

[Former Member]

Hi Lakshmipathi,

Thanks for the reply. But it is not giving me problem identification.

Can you pl help me in identifying or compare requested qty in main item  and total sub line item quantity generated is more than requested qty.

Then it can be more helpful.

Thanks,

Bala.

[Former Member]

Bala,

Relationship between main Item and subitem can be found in VBAP-UEPOS.  In general, if this field is empty, then it is a main item (or there are no subitems).  If there is an item number in this field, it indicates that this item is a subitem, and the item number contained here is the related main item.

Best Regards,

DB49

[Former Member]

Hi,

It is quite an unusual behavior of the system. However if you say that running ATP again corrects the order then you may consider running ATP on all open orders or orders which the business needs to execute in near future in the background.

The below link should help you do this.

Availability check and update in sales order. | SCN

Best regards,

Suman K Bhowmik.

[Former Member]

Hi DB49,

For line 20 subline items were created upto 32. Due to batch job line 34 got created and committed.

Now job is not able to correct it. Only manul ATP is successful.

It is removing the line item 32 and 34 and giving commit for 5 qty in line 30 itself by changing requirement qty to 5 from earlir req. qty 4 for the sub line item.

We want to identify these orders or requirement qty deviations from order qty. So that we can manulaay update these orders.

Thanks,

Bala.

[Former Member]

Hi,

To eloborate the issue more in parent line requirement given as 12 qty. Child lines created for requirement qty 17. commit is given for 12 qty only. How to identify all the wrong orders.

Thanks,

Bala.

[Lakshmipathi]

Yes you can achieve the desired result in SQVI.  What you can do is let the input parameters be

• Sale Order number
• Created On (ERDAT)

and the output be

• Sale Order number
• Line Item reference (POSNR)
• Material Code
• Quantity
• Confirmed quantity

You can get all the above fields from VBAP but for the last one which is available in VBEP.  If you dont have the sale order references, then consider adding VBAK also where you input Sales Document Type, if need be.

G. Lakshmipathi

[Former Member]

Bala,

To elaborate the issue more in parent line requirement given as 12 qty. Child lines created for requirement qty 17. commit is given for 12 qty only. How to identify all the wrong orders.

I am not seeing this.  Parent line quantity for item 20 is 12.  The confirmations you have highlighted are for other items.  Items in the same order are normally unrelated.  Are these to be considered subitems under Rules-based-ATP, or a similar ATP check that creates subitems?

Best Regards,

DB49

[Former Member]

Hi Lakshmipathi,

VBEP table is not completely helpful.

It is showing Parent line and child line requirement and fulfillment.

Not showing Parent line requirement qty and committed qty correctly.

Thanks,

Bala..

[Lakshmipathi]

In that case, you can try SQVI where you table join VBAP with VBEP.  From VBAP, you can get the order quantity (KWMENG) and from VBEP, you can get the confirmed quantity.

G. Lakshmipathi

[Lakshmipathi]

Due to sales org change in production some of the orders got over commit by ATP check

Sorry not able to get you.  Do you mean, sales area has changed?  If so, how the existing orders got over confirmed?  Ideally, you must be aware, for any configurational change, you must foreclose all open sale orders and create a new one.  Let me know if system is not performing ATP for the newly created orders.

G. Lakshmipathi

[Former Member]

Hi Lakshmipathi,

Sales Ordg change in the sence some of the values of sales org are changed.Not complete sales area change. There are thousands of sales orders open and it is necessary for reorg. ATP check is happening now also.

But we need to drag all the orders where over confirmation happend.

So, that atleast we can update orders manually or with a program.

Thanks,

Bala.

[Lakshmipathi]

In VBEP table, you can see both these fields, viz.Order quantity and Confirmed quantity.  So once you execute this table, wherever system shows the confirmed quantity in excess of order quantity, you can correct it.  But still, I am unable to understand as to why system is behaving the way you had indicated.

G. Lakshmipathi