Material forecasts are stored in PROW table. But it is not indexed by material number. It is indexed by pointer. The link to PROW is through PROP through MAPR. MAPR-> Get POinter for forecast Parameters (PNUM1)-> Read PROP ->Get Pointer for forecast results (PNUM2)->Read PROW using PNUM2.
This blog gives some very useful articles on SAP process, mapping business processes to SAP, simple tricks, development using ABAP and BADI, smartforms. Specific topics can be requested by posting a comment.