multiple reports

hi ,

can anybody tell me,

I am looking for a report or multiple reports (if I need to

link them that is fine) which show the following in bom

1) part number

2) Movement (Z_MAT_MOVE - should give me this)

3) If the part is on an active BOM (YES/NO column)

4) Forecast of next three months