Moving average price date

[Former Member]

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

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

Hi,

solved using field MBEW-TIMESTAMP and function IB_CONVERT_FROM_TIMESTAMP