Pricelist

[former_member293707]

In the company where I'm working for, there is a need for creating pricelists on a daily basis for about 50000 articles and 2000 customers. A prices list is nothing more than a file for each customer containing 50000 articles each with a customer dependent price. This prices are calculated with a normal calculation scheme and conditions.

It's fairly easy to create these files using the standard function PRICING. But the problem is performance. Calculating the prices for 50000 articles for one customer takes about 2 hours to generate in our system. Creating 2000 of these files is just therefore not possible.

Does anyone have suggestions to tackle this problem?

I was thinking of:

- using a simplified calculation scheme, because not all the conditions defined in the calculation scheme are necessary for a pricelist.

- creating initial pricelists in a self-defined Z-table, and update these tables using changepointers during the day when conditions change.

- using an external solution like the former IPC (now called Pricing Engine) or create my own

- ....

Any suggestions are welcome!

Regards,

Edwin

[ramkumar007]

hi,

i hope this is helpful,

http://www.erpgreat.com/abap/performance-tuning-for-data-selection-statement.htm

http://www.saptechies.org/sap-pdf-books-download/ABAP_Performance_Tuning343411326097630.pdf

http://wiki.scn.sap.com/wiki/display/ABAP/ABAP+Performance+and+Tuning  

Thanks & Regards

Ram

[former_member293707]

Hi Ram,

These kinds of information is always helpful of course. But the problem is that I use standard functionality of SAP (function PRICING) that takes care of all the selects on the conditions tables to get the right prices. I assume that SAP has taken all these performance measures to make the price calculation as fast as possible.

Regards,

Edwin