I have recently worked on an SAP Integrated Business Planning (IBP) project focusing on implementing an efficient Demand and Supply Planning process (with supporting S&OP layer), where there were many transactional interface requirements between SAP ECC and IBP. In this blog I will explain how powerful the SAP Cloud Platform Integration for Data Services (CPI-DS) tool is in integrating master data and transaction data from SAP ECC to SAP IBP and in passing the planning results back from SAP IBP to SAP ECC.Read Article
In our experience, most customers have planning data held on spreadsheets, with e.g. ProdLoc or ProdCust by row and a time dimension in each column, similar to the view below;
But! In order to send the above forecast data into SAP Integrated Business (IBP) via Cloud Platform Integration – Data Services (CPI-DS), there can only be a single row per time period, similar to the view below (note that the data is loaded in to a staging table prior to committing to the HANA database);
Obviously such manual reformatting of data every time a load is required for SAP IBP is a waste of planner time and effort.