Custom Sort Criteria SD Order tables : Product Allocation with BOP

[Former Member]

Hi All,

We are doing Product allocation check and the product availibility check . We are also running BOP on daily basis.

Current sort citeria is : MAD anmd creation date.

But we want to prioritize on basis of open allocation quantity.

We want to populate the open allocation quantity to Sales order at item level in APO in a custom field.

Then we will put this custom field in our Sort criteria through a USer Exit.

Need some info on SD Order tables in APO.

How is Sales Order stored in APO,in Database or Live cache . Which fields are stored in database and which ones are stored

Livecache?

Please suggest something on the same.

Regards,

Biswajit Sahoo

+91-9920558864

[Former Member · Accepted solution]

Any suggestions ?

[Former Member · Accepted solution]

Hi Biswajeet,

I didn't understand your requirement fully as to how sorting on open allocation helps more than sorting on MAD or anyother criteria. Your idea to populate the Open product Allocation into Sales Order would not perhaps work because the Product Allocation Situation changes every time a new Sales Order is created and you will not have the real time data in your custom field when you run BOP.

However, just to give some pointers.

There is not any direct table where you the system stores the Remaining Product Allocation Quantities(if that is what you mean by Open Allocation Quantities).

The db table contains /SAPAPO/BOPQTVB the Prod Alloc Qtys to your Sales Order items. You have to determine in the runtime the remaining allocation quantities every time you populate them in your Sales Orders by subtracting Incoming Orders from Prod Allocation in the bucket (you can determine the bucket by reading the timestamp in the above mentioned table). The same info can be found in db table /SAPAPO/SDQTVB. This task could be very exhaustive and complex.

Hope this helps.

Regards,

Mohan