SUMMARY

📌 What is APO Demand Planning – Excel 2-Way Integration? In SAP APO Demand Planning (DP), planners use an Excel Add-In to maintain forecast data with two-way (bi-directional) integration between Excel and APO system.

This allows real-time download & upload of planning data.

📂 Use Case

✅ Maintain forecast in Excel (user-friendly interface).

✅ Download historical & key figure data.

✅ Upload updated forecast back to APO cube.

✅ Perform mass planning & simulations.

🔄 How 2-Way Integration Works

1️⃣ Download (APO → Excel)

• Open Excel with APO Add-in
• Select Planning Area & Data View
• System pulls key figures (Forecast, Sales, etc.)
• Data is fetched from LiveCache / InfoCube

2️⃣ Maintain Forecast in Excel

• Planner adjusts quantities
• Apply macros or statistical models

3️⃣ Upload (Excel → APO)

• Save / Transfer data
• System updates planning area
• Changes visible in APO interactive planning

🛠️ Example

Product: FG-1000

Month Jan Forecast = 1,000

Planner updates in Excel → 1,200

Uploads → APO DP cube updated instantly.

📊 Key Tcodes

/SAPAPO/SDP94 – Interactive Demand Planning

/SAPAPO/MSDP_ADMIN – Planning Area

/SAPAPO/TS_PSTRU – Planning Structure

Excel Add-In – APO DP Planning Book

📂 Key Tables / Objects

Planning Area (InfoCube-based)

LiveCache

Key Figures (Forecast, Sales, etc.)

✅ Conclusion

APO DP Excel 2-way integration allows planners to work comfortably in Excel while keeping real-time synchronization with APO.

It improves flexibility, mass planning efficiency, and forecast accuracy.