SD- Average moving price

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