Stock available qty for customer sales order

[former_member341990]

Dear All SAP SD Experts

Currently i am having a problem in the system about stock availability for a material shown in MMBE

in MMBE the stock is mentioned as "Unrestricted use = 48 Unit" in a storloc

and when we try to input the sales order for that material in the same storloc the system didnt allocate the stock and the status become back order

please help me out

Best regards

Halim

[ajith_kumar10 · Accepted solution]

HI

IN scope of check you might have ticked include sales requirements. If there are any open sales orders system will not confirm the stock even though the stock will show in unrestricted use.

regards

Gopi

[former_member341990 · Accepted solution]

Hai Mr Gopi Krishna Ponnala,

I didnt find that "ticked include sales requirements" in MMBE tcode, could you specify which selection rules i have to add ?

or do you know any helpfull tcode so my sales dept PIC can use to see actual available stock / unallocated from other sales orders ?

Best regards

[former_member223981 · Accepted solution]

Availability check works from CO09, not MMBE. See SAP note 89362.

Consider a simple example:

Stock = 10, so we see 10 in MMBE & 10 in CO09.

Sales Order 1 created with a quantity of 10. Confirmed quantity = 10. CO09 now becomes 0 but you still have 10 in CO09.

Sales Order 2 created with a quantity of 10. Confirmed quantity = 0 as you have 0 available according to CO09. So even though MMBE shows you have 10 in stock, it cannot be allocated to SO 2.

There is loads of information out there regarding MMBE v CO09. CO09 is the only transaction that gives you a true reflection of your available quantity.

[former_member341990 · Accepted solution]

Hi Mr Noel Connolly

Im new on this CO09

I appreciate your information, but could you give me a more detail steps for CO09 about how to know actual available stock in a stor loc ?

or maybe which order is locking my inventory availability ?

Best regards

[former_member223981 · Accepted solution]

It is difficult to just give an overview of CO09 as it is quite a complex transaction. There is a good document created by one of the contributors on here:

http://scn.sap.com/docs/DOC-50497

that explains the difference between MMBE & CO09. This may be a good starting point for you.

The most important thing to remember about CO09 is that the system uses checking rule "A" for sales orders, and checking rule "B" for deliveries.

[Lakshmipathi · Accepted solution]

I didnt find that "ticked include sales requirements" in MMBE tcode

You have to check in OVZ9

G. Lakshmipathi

[phanikumar_v3]

Please go through the link given by Mr Noel-certainly it helps you what is the cause for your issue..

to Mr Noel-Very Good link,Thanks for sharing with team.

to Mr Jurgen: we respect your helping nature-even though you stand tall(in fact very tall)

To the author: please go to MMBE then check all the levels of the stock by scrolling to right--if you find some numbers here-Right click--check the Requirements list/Open POs etc..hope this helps.

Phanikumar

[former_member341990]

Dear Mr Phanikumar V

I already check that article, and it seems like different problem with my case

Here is the summary of material condition :

1. after I check in CO09 the material have enough Qty 24 Unit available

2. Check in MMBE the Qty also enough 24 Unit available

3. at the plant level the ATP Qty only 6 unit, mean while in plant level the unrestricted inventory is 102 Unit

4. Some sales order with confirmed qty to this material with the correct batch also cannot be issued

looks like this materialis stuck somewhere.

I already raise a ticket to SAP Support team to analyze, and if the problem found I will share it to you guys.

Best regards

[former_member223981]

Is it possible for you to post screenshots of your CO09 and MMBE on here?

[former_member341990]

Dear Mr Noel

[former_member223981]

The available quantity isn't specific to a sales order / delivery. The available quantity that you in the "Cumulative ATP Quantity" column reflects the available quantity of that particular segment. A segment can be a plant, storage location, batch or batch / storage location.

In your screenshot, it is clear that you do not have an available quantity at storage location level. Actually, you have a negative availability quantity in this segment which means nothing can be confirmed. At plant level, you have 102 in stock - 48 of sales orders - 48 of deliveries = available quantity of 6. In storage location 1000, you have 64 in stock - 48 of sales orders - 48 of deliveries = -32 available quantity.

The plant stock is made up of an accumulation of all your storage locations. However, on your screenshots, we can see 102 at plant level, 48 in storage location 3000, 1 in storage location 4000, 64 in storage location 1000 = 113. There may be more storage locations that are not in the above screenshots? If the "SLoc MRP Indicator" in the MRP4 tab of the material master = "1" or "2" for the specific storage location, then the stock for this storage location will not be added to the plant stock. This might be happening on your system.

For the system to assign a confirmed available quantity, it must find an available quantity at each segment. This is explained in the KBA 1513607 (cause 4). I would highly recommend that you read that KBA, along with note 153355 which explains how we can come to a scenario where you have a negative available quantity.

Hope this helps.

Noel

[Former Member]

Hi

please check whether there are open sale order exits are not if there are open order for the same material  stock was allocated to that all open sales order and open delivery close that order first and check in mmbe

thanks

[former_member341990]

Dear Syed zabee

Currently the stock on MMBE is 24 Unit, and I already delete all sales order and in the CO09 report , Cum ATP Qty is 24 also, but when I try to input sales order the confirmed qty only 6.

can you help me to determine what is the issue

Best regards

[Former Member]

Hi

please study this link Scope of the Availability Check - Availability Check According to ATP Logic - SAP Library

please per form availability check manually in sales order by selecting line item in the bottom there will be availability check icon or else run the program in se38 that is SDRQCR21

THANKS