How can I download forecast data?

[Former Member]

I am relatively new to SAP and I am trying to figure out an easier way to download the forecast requirements (generated elsewhere by other users) for a few hundred part numbers for the next 18 months.  Currently, I go into MD62 and copy 30 materials at a time into my list and then copy as many columns as possible from SAP and paste into Excel.  This is VERY time consuming and I'm sure there is a better way, I just don't know it.

Ultimately I want a forecast by period something roughly along these lines:

Material	Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15
PW0311NN9910EN	18	21	27	18	19	22	19
PW0312NN9910EN	60	70	88	62	68	72	61
PW0601NN9910EN	41	48	61	41	45	50	42
PW0603NN9910EN	14	16	22	14	15	18	13
PW0610NN9910EN	21	24	30	20	22	25	21
PW0624NN9910EN	12	14	18	12	13	15	12
PW0802NN9910EN	71	84	107	73	80	87	74

Thank you.

[marianoc · Accepted solution]

Hi Chris,

You can download your Planned Independent Requirements using MD79. This transaction can be execued by plant and will export an excel with all the PIRs by material in lines and periods in columns.

Kind Regards,

Mariano

[Former Member · Accepted solution]

Thank You Mariano, that is exactly what I am looking for, but I have hundreds of materials to check (on a monthly update schedule).  Is there a way to load all of them at once?

[Former Member · Accepted solution]

Nevermind, I re-read your answer and ran it by plant!  That worked perfectly.  Thank you very much.