topic Re: Moving average price date in Application Development and Automation Discussions

Moving average price date

Former Member — Wed, 20 Jun 2012 09:16:52 GMT

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

Re: Moving average price date

RaymondGiuseppi — Wed, 20 Jun 2012 10:06:02 GMT

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

Re: Moving average price date

Former Member — Wed, 20 Jun 2012 10:16:20 GMT

Hi,

solved using field MBEW-TIMESTAMP and function IB_CONVERT_FROM_TIMESTAMP