Optimizing Demand Planning for a CP&G Client

  • Home
  • Optimizing Demand Planning for a CP&G Client

Retrofitting Teradata for SAP ECC to SAP S4 Hana Migration


About the Client:

Client is a leading global manufacturer of confectionery and snack products since 1880s. With a rich heritage and a portfolio of well-known brands, the company has established itself as a household name in the food and beverage industry. Client operates in over 80 countries and generates billions of dollars in annual revenue.


The client, a prominent multinational company operating in the food and beverage industry, had been using an aging SAP legacy system that was built back in 1998. Over time, they had made some upgrades by implementing SAP BW Hana for their business warehouses. However, their ERP system had not been updated, causing inefficiencies and limitations in their operations. To address these issues, the client decided to leverage SAP Hana technology and embarked on a phased implementation starting with their Mexico, US, and Canada business units.

Challenge with Legacy system:

  1. Inadequate Support for New Business Demands
  2. Connectivity Issues with New Systems
  3. Managing Large Data Volumes

Type of Approach

Green Field

Reporting tools

Power BI / Tableau

Relational Database

Teradata, Datalake


  • Green field approach was applied for the project with agile development strategy
  • Parallel system was created so that current operations are not affected
  • Development and test environment were created


  1. Created inventory of existing objects
  2. Checked with the different application teams on the availability of source files in S4
  3. Have a design ready to Implement an existing Teradata object in S4
  4. Develop necessary scripts and objects as per the design specified (from business owners)
  5. Test the developed code for any for issues or bugs
  1. Source system JDA during testing we found that a lot of records were moving to exception table due to discrepancy in data from dependent tables.
  2. We analyzed this issue and found the root cause to be unavailability of “000 materials” in mvke file, we got back to business with our observation and as a result, we went ahead a design change of mvke transform script to fix this issue. 
Optimizing Demand Planning For A CP&G


  • Ordering system overhaul
  • Better insights on stocks
  • Demand planning