SD- Average moving price

[Former Member]

Dear Gurus,

My ABAP guy wants to know which tables and fields from a Sales order he needs to use to design a program regarding the 'Average Moving price'.

The question is also the following one:

From which tables and fields can we see the average moving price in SD for a given material in a given period?

1- How to see or take the sales orders for a given period

2- How to see or take in the sales order which materials have sold for a given period

3- How to see or take the average price for given material

Thank you for your help

Chris

[Former Member · Accepted solution]

Hi

1- How to see or take the sales orders for a given period

A: Use Table VBAK with date range for sales order for a given period

2- How to see or take in the sales order which materials have sold for a given period

A: Use table VBAP for materials for sales orders.

3- How to see or take the average price for given material

Pass Material number to MBEW table to get average price