How can I do a mass upload of customer forecast data / phase in - phase out in SAP APO DP ?

[Former Member]

Hello Experts,

I'd like to set up a demand forecast for a site in my supply chain . Let's call this Site A. Essentially, we are transferring many customers to another site, Site B , and bringing in many customers to site A. As a result, I will need to create a demand forecast to phase in / phase out demand for Site A and Site B.

Now,the supply chain has approx 7 sites, and approx 2000 items which are a part of this forecast. How can i create the new demand forecast for all sites and upload directly into SAP APO DP ? Is there a standard way to do a mass upload , or would i need to write some custom ABAP code to achieve this mass upload ?

Currently, the only way i am aware of is to manually create the data entries for each item-site combination.

Thanks,

Rishu

[Former Member · Accepted solution]

Hi Rish

You can try to think about realignment functionality if you just want to transfer the FCST from one site to another site. (assuming site is part of CVC combination).

Please find below the document for your reference.

You can also use the excel upload functionality in APO BW and load respective forecast from cubes to planning area. Please find below the document which could explain you the stets.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0cb1b99-45f7-2e10-3ab0-ca680da72...

Please let us know this information helps you.

Thanks

Amol

[Former Member]

Amol, Alok,

Thank you for your help with this. The documents specifically have been very useful. I will look into the excel upload functionality further, since that seems most relevant for our situations and update you accordingly.

One related question : do you know the name of the underlying SAP database table which stores the forecast data ?

Regards,

Rishu

[Former Member]

Hi Rishu

There is not table concept in demand planning. In BW you store he data into infocubes from where you can load the data into planning book which is mainly in LC.

Any specific reason for asking this questions. If we know the background we might provide you better answer.

Thanks

Amol

[alok_jaiswal]

Hi Rishu,

To add to Expert Amol's point, in the Realignment step you have option to create Local File (Excel format) - create entries in the excel for the required combination of source and destinations and upload it back - Once realignment is run new CVCs would be created.

Basically you need to follow below steps -

• Maintain a Realignment Table
• Define Realignment Steps within the table - either manually or for huge entries can use mass upload via excel
• Execute Realignment Run (Ensure noone there in planning book as it could cause locking)
• Validate Logs and Results

Hope it helps you.

Regards,

Alok