Moving average price based on date range, site and article.

[Former Member]

Hi ABAPers,

I am working on SKU wise sales report. Based on user input of date range ,site and article I fetch data from VBRP table i.e., (billing data from stores) . I have searched a lot to find MAP but dint get convincing solution.

I tried to get data from MBEW-VERPR but that doesnot give MAP for a given date. I also tried with condition record table and KONP table but not helpful.

I also got to know about s031 and LIS configuration I am not sure whether functional consultant should do the changes.

Kindly help me in obtaining the MAP for particular bill date, article and site(store).

Regards,

Dep

[raymond_giuseppi]

You can found the moving average price in MBEW (current) and MBEWH (history table)

The first goods movement after the period closing program updates the period in MBEW and writes the data of the previous period to table MBEWH

- If you actually need map on a daily (or less) basis, you will have to calculate it from MBEW, MBEWH, MSEG and BSIM (...)

- You could also look for the actual cost in MSEG related to records of VBRP.

Regards,

Raymond

[Former Member]

Thank You Raymond,

I have tried to link VBRP records with MSEG but I could not find the proper join condition , I am working on that and also looking for alternatives.

Regards,

Dep