Once confirmed should not be re-assigned to other orders

[Former Member]

Hi Gurus,

We have a requirement from our users that if a particular Sales Order type (ZEX) gets confirmed once, then it should not loose its confirmation during a BOP run for any other (even Higher Delivery Priority Orders)

So we tried to tweak with our FILTER/SORT in our APO BOP JOB.

Current Scenario

Scenario 1-A

Total Stock = 10 EA

SO1 = ZEX = 10 EA – Confirmed – Delivery Priority = 7

SO2 = ZOR = 10  EA– Unconfirmed – Delivery Priority= 3

BOP runs with Current FILTER

BOP Outcome:

SO1 = ZEX = 10 EA– Unconfirmed

SO2 = ZOR = 10 EA– Confirmed

Working Successfully : an open sales order (any order type) with a higher DP gets the stock & confirmed at the cost of another open sales order (any order type) with lower DP.

Desired Scenario

Scenario 1-B

Total Stock =  10

SO1 = ZEX = 10 – Confirmed

SO2 = ZOR = 10 – Unconfirmed

BOP runs (with NEW FILTER)

BOP Outcome:

SO1 = ZEX = 10 – Confirmed (ZEX order types should not loose it's confirmation)

SO2 = ZOR = 10 – Unconfirmed

SUCCESS

So we changed the BOP FILTER to make this happen. But the problem is now the next few scenarios are not working at all.

That is any new open Sales Order of ZOR type is not getting confirmed even if there is ample stock.

Scenario 2

Total Stock =  5 EA

SO1 = ZEX = 5 – Confirmed 5 - Unconfirmed

SO2 = ZOR = 10 – Unconfirmed

Stock = +10 arrives

BOP runs (with NEW FILTER)

Desired BOP Outcome:

SO1 = ZEX = 5 – Confirmed

SO2 = ZOR = 10 – Confirmed

FAILED!

Actual Output

SO1 = ZEX = 10 confirmed

SO2= ZOR = 10 (all still in unconfirmed status, even though we have 5 available stocks)

Please Gurus have a look & advise if you could understand the problem.

We need to understand if the NEW REQUIREMENTS could be achieved by configuration alone?

Current FILTER

NEW FILTER (In addition to above these also added)

Thanks & Regards

Sooraj

[RahulHanda · Accepted solution]

Hi Sooraj,

Before we get into this, did you already tried "Fixed date and quantity" indicator on schedule line tab on sales order?

If you put this then you are confirming both and system will not overwrite anything.

Regards

Rahul

[Former Member · Accepted solution]

Hi Rahul/Babu,

Thanks for suggesting to tick 'Fixed Date & Qty' in sales order & also to tick 'Consider Fixed Confirmation'

So now once this SO has this FDQ flag set, the confirmed quantity is not being taken by any other SO in the BOP run.

But we have the following GAP now:

1) How do we get this FDQ flag set to all SO based on order type filter enmasse?

2) It's observed that once FDQ flag is set on a SO it no more shows up in CO09 neither in BOP run, then how do we the first-initial-confirmation done for these SO?

Appreciate your help

Thanks

Sooraj

[babu_kilari4 · Accepted solution]

Hello Sooraj,

To the extent of my knowledge, I am not sure if there is any tool in ECC to apply Fix Date and Quantity flag in mass.

But, if you're already on SCM 7.0 EHP3 - you can use the standard gATP tool eBOPI to apply mass "Fixing" for the orders at one ago. Other option is to build a custom tool in ECC to apply this flag. But, please note that your custom tool should use standard BAPIs to change this field to be in line with SAPs way of processing.

To answer your second question - the moment an order is placed the initial confirmation is done from normal Availability check. Also, this field is meant to be used on need basis. So, for instance if you're using some orders ( Sales document type say ZXXX ), during the order creation once it gets the confirmation you may also use standard SD user exits in R/3 to set this flag so that BOP doesn't de-confirm it.

Hope this helps.

Babu Kilari

P.S:- Close the thread if you're satisfied with the answers

[RahulHanda · Accepted solution]

Hi Sooraj,

Though expert Babu Kilari has provided you answer but you can check MASS transaction in ECC. Select "Sales orders" in object type followed by sales order item data. Thereafter you can put document numbers example in selection and put in mass. But you need to be cautious while doing this as sales order should already have schedule line else you will fix this without SL.

Regards

Rahul

[Former Member]

Thanks for your replies Rahul & Babu.

Our requirement it seems can't be achieved without a user-exit maybe.

[babu_kilari4]

Hello Sooraj,

Can you explain what is the roadblock that you're facing with "Fix Date & Quantity" flag ?  If you need to assign this flag during order creation itself, then you may need to use the USEREXIT_SAVE_DOCUMENT_PREPARE userexit in MV45AFZZ. If this works, I don't see a need to implement any userexit in BOP processing.

Requesting you to close the thread if your queries were answered.

Thanks & Best Regards,

Babu Kilari

[babu_kilari4]

Full support what Former Member had proposed. It is a straight forward requirement that can be easily achieved with Fix Date & Quantity flag. You can exclude the orders that has the FDQ flag set by using the check box "Use Fixed Confirmations" in the 3rd tab of the BOP filter.

Thanks & Best Regards,

Babu Kilari

[Former Member]

Thank you Babu Kilari & Rahul

Let me test this & I would share my outcome.