Custom key figure integration between IBP and PP/DS fails with mapping errors

SCM SAP IBP
, , , , , , , ,
1

We’re experiencing critical failures when transferring custom key figures from IBP to PP/DS through CPI-DS. Our manufacturing planning team defined three custom key figures in IBP (ZCUST_YIELD, ZCUST_SCRAP, ZCUST_SETUP_TIME) for production optimization, but the integration consistently fails with mapping errors.

The custom key figure definitions in IBP planning area appear correct, and we’ve verified the technical names match our specification document. However, when CPI-DS attempts the transfer, we get “Key figure not found in target system” errors. We’ve checked the integration mapping configuration in CPI-DS multiple times, but the mappings seem incomplete.

Our PP/DS system shows the planning area is activated, but we’re unsure if there’s a specific activation step required for custom key figures. The standard key figures transfer without issues, so the basic integration pipeline works. This is blocking our production planning rollout scheduled for next month. Has anyone successfully integrated custom key figures between IBP SI-2211 and PP/DS?

2

Thanks Sara! I checked /SAPAPO/MSDP_ADMIN and you’re right - our custom key figures aren’t in the PP/DS catalog. How do we get them replicated there? Is there a specific CPI-DS job or do we need to manually create them in PP/DS first?

3

Let me provide a comprehensive solution based on all the points raised. The custom key figure integration failure has three root causes that need to be addressed systematically:

1. Custom Key Figure Definition Alignment

First, ensure your custom key figures are properly defined in both systems:

In IBP Planning Area:

  • Navigate to Planning Area configuration
  • Verify ZCUST_YIELD, ZCUST_SCRAP, ZCUST_SETUP_TIME exist with correct data types
  • CRITICAL: Enable “Active for Integration” flag for each key figure (as Chen identified)
  • Document the exact technical specifications: data type, unit of measure, aggregation behavior

In PP/DS (/SAPAPO/MSDP_ADMIN):

  • Create matching key figures with identical technical names
  • Use compatible data types (IBP FLOAT maps to PP/DS QUAN, for example)
  • Assign to appropriate key figure groups
  • Set the same unit of measure definitions

2. Integration Mapping Configuration

Update your CPI-DS integration model:

  • Edit the integration model in CPI-DS configuration
  • Add explicit field mappings for each custom key figure: Source: IBP.PlanningArea.ZCUST_YIELD → Target: PPDS.KeyFigure.ZCUST_YIELD
  • Configure data transformation rules if data types differ slightly
  • Set error handling to “Log and Continue” during initial testing
  • Save and activate the updated integration model

If using SDI (as Laura mentioned):

  • Open SDI Data Provisioning task for IBP→PP/DS replication
  • Modify source selection to include custom key figures
  • Update the replication definition filter: Remove any exclusions that might filter out Z* fields
  • Test the SDI replication independently before running full CPI-DS integration

3. Planning Area Activation

This is the step most commonly missed:

  • In PP/DS, go to planning area maintenance (transaction /SAPAPO/CDPSB1)
  • Select your target planning area
  • Choose “Deactivate” (yes, deactivate first)
  • Wait for deactivation to complete
  • Then choose “Activate” - this rebuilds the planning area structure with new key figures
  • Verify in /SAPAPO/MSDP_ADMIN that custom key figures now appear in the active planning area

Testing Approach:

  1. Create a test planning scenario in IBP with sample data for custom key figures
  2. Run CPI-DS integration job in test mode
  3. Check CPI-DS logs for mapping confirmation (should show successful mapping for ZCUST_* fields)
  4. Verify data arrived in PP/DS using /SAPAPO/RRP3 or planning table display
  5. Compare values to ensure data integrity maintained during transfer

Common Pitfall: Even after all configuration is correct, the first integration run might fail due to cached metadata. Clear the CPI-DS metadata cache (transaction CPI_DS_CACHE_REFRESH) and retry.

This systematic approach has resolved similar issues in multiple IBP-PP/DS integration projects. The key is addressing all three areas - definition alignment, mapping configuration, and proper activation sequence.

4

I’ve seen this exact issue before. The problem is usually that custom key figures need to be replicated to PP/DS master data first, not just defined in IBP. Check if your ZCUST_* key figures exist in PP/DS transaction /SAPAPO/MSDP_ADMIN under the key figure catalog. They won’t appear automatically just because they’re defined in IBP planning areas.

Also verify that your CPI-DS integration model includes the custom key figure mappings in the field mapping configuration. The standard integration templates often only include SAP-delivered key figures.

5

Great catch Chen! The “Active for Integration” flag was unchecked for two of our three custom key figures. That would definitely explain the partial failures we’ve been seeing. I’ll enable those flags and coordinate with our PP/DS team to create the key figures in /SAPAPO/MSDP_ADMIN as Raj suggested.