Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Moving average price date

Former Member
0 Kudos

Hi,

I would create a report with the following columns:

MARA-MATNR;

MBEW-VERPR;

date of the moving average price.

I cannot find in what table is stored the date of last moving average price.

I tried in S031 but the column date is always empty is there another table which stores this information ?

Thanks

Best regards

1 ACCEPTED SOLUTION

raymond_giuseppi
Active Contributor
0 Kudos

Well I would say MBEW-LAEPR, Also I would filter actual (and not sum) MBEW records with bwtty = space or ( bwtty <> space and bwtar <> space (adjust to your Customizing) and for moving average price with vprsv = 'V'.

Regards,

Raymond

2 REPLIES 2

raymond_giuseppi
Active Contributor
0 Kudos

Well I would say MBEW-LAEPR, Also I would filter actual (and not sum) MBEW records with bwtty = space or ( bwtty <> space and bwtar <> space (adjust to your Customizing) and for moving average price with vprsv = 'V'.

Regards,

Raymond

0 Kudos

Hi,

solved using field MBEW-TIMESTAMP and function IB_CONVERT_FROM_TIMESTAMP