Material Forecasting Tables

[Former Member]

Hi There,

I'm have a requirement where I need to show the material forecast value for each period, as we can be seen in the transaction MM03 forecasting view. My problem is that I cannot found a FM or the correct tables sequence to get this data into an Abap Report.

I'm using this Select:

SELECT mapr_{matnr mapr}werks mapr~pnum1

prop_{hsnum prop}pnum2 prop~prdat

prow_{ertag prow}prwrt prow~koprw

INTO CORRESPONDING FIELDS OF TABLE p_t_forec

FROM mapr

INNER JOIN prop

ON mapr_{pnum1 = prop}pnum1

INNER JOIN prow

ON prop_{prdat = prow}ertag

AND prop_{pnum2 = prow}pnum2

FOR ALL entries IN t_mara

WHERE mapr~matnr EQ t_mara-matnr

AND mapr~werks IN s_werks

AND prop~hsnum = '00'

AND prow~ertag = v_first_date.

But I have noticed that I cannot get the data as I can see through MM03 - forecasting view.

I appreciated if someone can help me in this matter

Regards

Alexis

[amit_khare]

did you check FM - MATERIAL_FORECAST_DISPLAY