Advanced SAP IBP Integration with CPI-
DS and Planning Area Configuration
This document outlines a comprehensive and detailed training course for advanced SAP IBP
integration using CPI-DS. It includes deep technical content, functional configuration, hands-on
labs, and step-by-step exercises with solutions.
Module 1: Advanced Job Design in CPI-DS
Learning Objectives:
- Understand delta vs full load strategies using CPI-DS
- Work with ECC extractors using ABAP dataflows
- Handle Planning Area metadata in job configuration
- Use parameters, variables, and conditional logic in CPI-DS jobs
Detailed Content:
1. Delta vs Full Load
- Delta Load: Use timestamp-based filters to extract only changed records.
- Full Load: Replaces all data in target each time.
- Strategy: Schedule full load weekly and delta daily using Job Scheduling options.
2. Handling Planning Area Metadata
- Open CPI-DS > Project > Import Metadata > Choose IBP connection.
- Select the Planning Area, Key Figures, and Attributes.
- Save and activate metadata. Refresh after changes in IBP.
3. Designing ABAP Dataflows
- Create a new Dataflow > Add ABAP Data Source.
- Choose extractor (e.g., 0MATERIAL).
- Define selection filters and RFC connection.
- Map fields and connect to Query transform > Target.
4. Using Parameters and Conditional Logic
- Define global variable: $G_LAST_RUN_DATE.
- Use in query filter: LAST_CHANGED_DATE >= $G_LAST_RUN_DATE.
- Add Conditional Transform to split weekend/week processing.
Exercise: Full vs Delta Load Job Design
Objective: Create two CPI-DS jobs to extract data from ECC Material Master - one full load, one
delta load.
Step-by-Step Solution:
1. Log in to CPI-DS and create a new Project.
2. Import metadata for ECC system and 0MATERIAL extractor.
3. Create a Dataflow named DF_FULL_LOAD_MAT:
- Add ABAP Data Source for 0MATERIAL
- No filters (full load)
- Connect to Query > Target table (IBP_MATERIAL_FULL)
4. Create another Dataflow named DF_DELTA_LOAD_MAT:
- Add ABAP Data Source for 0MATERIAL
- Add filter: LAST_CHANGED_DATE >= $G_LAST_RUN_DATE
- Create Global Variable in job: $G_LAST_RUN_DATE (e.g., 2025-01-01)
- Connect to Query > Target table (IBP_MATERIAL_DELTA)
5. Create Workflows and Jobs for both Dataflows.
- Add Preload script to calculate current date.
- Add Postload script to log record count.
- Schedule: Full Load weekly; Delta Load daily.