Forecast Data Transfer to Demand Management

Dear Brian,

1.For creating PIR's or to copy the forecast values ,in

MD61,after entering the material,plant,click on

Reference button (or else Press F9),in the pop up

window,select the radio button for copy from material

forecast,press enter & proceed.

2.You can give the input of PIR's in MD61 on Monthly Basis and further you can

split into weekly buckets or daily buckets.

3.For splitting Monthly values into weekly one's,select the material row and the

column (monthly value) and click on Edit -

Period Splitting -

Weekly Split,then

automatically the values will get splitted into weekly values.

4.The following is the help given by SAP

<b>Copying a Forecast</b>

<u><u><b>Procedure</b></u></u>

Select Material forecast and choose Continue.

Define the reference and choose Continue.

You can change the reference in Change reference values by changing the following parameters and choosing Continue.

– Planned quantity

– Postpone

– Percentage

Display references appears. You can check the reference quantity.

Select a reference, and choose Choose.

The reference is copied to the current material.

Select the item, and select Schedule lines.

Result

On the schedule lines screen, you can check and change the quantities and dates.

Regards

Mangal

Hi,

I think U can create BDC program to trasfer the XL file.

Provide a differt t-code like ZDM

Hi Brian,

Option 1.Create a BDC to populate the XL figures with call transaction MD61

Option 2.Instead of creating a new info-structure goto transaction OLIX and create another version of the same info-structure S076 (that will save a lot of effort on ur part)and then write a bdc to upload the data in the inactive version....go with the revision and use the same transaction to copy the inactive data to the active version.Now u can go to MC76 goto extras and transfer to demand management

Hope this helps!

Hope it helps

Thanks to everybody for their answers, much appreciated - I'll award points without fail. However, I need further clarification on certain points of this issue. (1) Uploading through BDC program to call MD61 is one of the options, but I'm looking for a user exit or a BAPI to carryout this job. I'm a bit apprehensive of BDC programs post go live when the end user has to run the program - can have probelms. (2) The infostructure S076 is one option that could solve this problem, but copying this infostructure is not clear to me because this infostructure does not have the quantity key field - without which, how can I load the quantity values from the XL file? I'm I missing something ?!! Pl give more details or directions.

regards

BE

Hi Brian,

If i understand correctly ur problem now is that u dont have the quantity field in the s076 right.What u can do is go the planning type(MC8B) SOPKAPA and add one row and name it quantity and save the plaanning type.Now go to the planning table u can get the new row....pls let me know if it doesnt work....

ranojoy