topic Pricelist in Application Development and Automation Discussions

Pricelist

former_member293707 — Fri, 15 Nov 2013 10:46:26 GMT

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

Re: Pricelist

ramkumar007 — Fri, 15 Nov 2013 10:57:57 GMT

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

Re: Pricelist

former_member293707 — Fri, 15 Nov 2013 11:21:20 GMT

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