Existing Sales orders for Materials added to Product Allocation. Experts advice needed

[Former Member]

Running ECC60 and APO 2007 (5.1)

We have the above scenario where Sales orders are already entered in ECC for material number.  At the time of initial order entry and confirmation the material was no 'on allocation'.  Now the Business determines that this material needs to be placed on Allocation.  So in ECC we maintain necessary data (Allocation Groups, CVCs, Allocation Quantites, Product Master data assignments.) We then maintain ECC Material master and maintain Intergration models so that subsequent ATP checks for this material  will now go through APO GATP Allocation check.

Couple of points/observations.

1. Business does not want to have to manually go into each existing open order and re-run ATP in order to update the Sales Order Qty in our related Product Allocation Planning book. One suggested alternative for updating the Allocation Sales Order quantity is to run Backorder processing.  This will effectively re-run ATP on all qualifying orders (defined by BOP Profile) and seemingly will also perform allocation check and pass therefore update the Sales Order Qty.

2.  Observed problems with the above where not all qualifying open order qty appears to be pulled into the Planning book.  Are there any things that we should check for here that others have experienced?

3.  Part of the above issue we have noticed is that even though the Master Data has been updated if we manually go into the Sales order and perform ATP check we do not see the 'Product Allocation' button on the ATP screen.  The only way around this is to either delete the line and enter a new line which appears to force a re-read of the master data.  (deleting the plant code on the existing line and the re-entering seems to do the same thing).  Has anyone seen this before and can anyone offer a better solution to this?

In my ideal situation, we would maintain all of the master data, then run backorder processing one time such that it would pick up all orders now subject to allocation, then update the Allocation Group, and Workbook with the correct ooen order volumes.

Currently we are doing the following.

1. Run an open orders extract to a flat file in ECC.

2. In APO run Backorder processing/

3.  Open up the Planning Book and compare volumes with volumes in ECC extract.

4.  If discrepancies exist, run /SAPAPO/SDRQCR21 to see if this picks up and updates any of the orders in question.

5.  Run /SAPAPO/ATPQ_CHKCUST to identify which order numbers were passed across automatically.

6.  For remaining orders on our open orders extract we then have to open the orders one by one and perform step 3 to get the data to pass across.

On point 6, We do know that any orders with Deliveries already created will not pass across (Which makes sense)

Is there a more efficient method to do this?  Would appraciate greatly any guidance that can be offered.

[sourabh_jain66 · Accepted solution]

Hi Adam,

Few things;

You are doing availability check in APO, but the configuration you have done is in ECC, probably the reason you are not able to see product allocation button on APO ATP overview screen, try to maintain the configuration in APO and see if it resolves your issue.

For BOP related issue you can do following activities;

1) deactivate all sales order, ATP related integration models between ECC and APO.

2) run CCR for sales orders and delete all the data in APO.

3) configure product allocation in APO.

4) transfer product allocation and product allocation customizing in separate integration model.

5) create integration model for sales order and ATP between APO and ECC.

6) to get all the relevant orders in BOP check your filter settings in BOP, also you can use order creation date / order type along with product and location combination.

Try these and let me know if you face any issue with this.

Rgds

Sourabh

[Former Member · Accepted solution]

Thanks for the reply Sourabh.  I mis-typed on my initial email.

On my first point:

So pre-existing sales orders are out there, then the business decides that materials contained in these orders should now be placed on allocation.

In ECC: I add the materials to the necessary Integration models.  (ATP Check and Transaction Data), We also maintain the material master in MRP3 to assign the appropriate Strategy Profile.

In APO, we maintain the Product Master (ATP Group and Allocation Procedure).  We also have created CVCs and maintained allocation values etc.  So all necessary config is in place.

If we then go back into ECC and run ATP check manually the check is run in APO but no allocation button is visible.  However, if we delete the line item on the sales order and then add it back again, then run ATP we see the allocation button.  (Seems like it forces a re-read of the master data).  Looking to find out if there is something that can be done to prevent this manual step since this can be very time consuming if you have a large number of pre-existing open orders)

On the BOP Steps:  Thanks for the tips I will experiment further.

[sourabh_jain66 · Accepted solution]

Hi Adam,

Primarily this is happening because of the orders were already there in APO before you decided and implemented product allocation, what is happening here is when you delete line item and them create another line in order, it goes in APO with allocation related flag, so you can try deleting all the orders from APO and then cifing them again to APO.

how to do that:

1) deactivate all sales order, ATP related integration models between ECC and APO.

2) run CCR for sales orders and delete all the data in APO.

3) Create integration model for sales order and ATP between APO and ECC.

Before you try this just to save on time, try reseting time stamp and generate objects for your allocation group, under Easy access ---> APO --> GATP --> Environment --> Product Allocation --> Generation.

See if this solves your issue, if not then you can try deleting the SOs in APO and resending the same.

Rgds

Sourabh