Skip to Content
Technical Articles
Author's profile photo Manasi Bhagwat

Integrating Market Research data from SAP DSiM to CBP

If your customer has SAP DSiM and they also have Customer Business Planning, then there will be a requirement to move the actuals data that is present in DSiM to CBP. The actual baseline and uplift volumes from market research can be further used for the forecasting and planning in CBP.

In DSiM 3.0, SAP has provided a standard integration datasource /DDF/DSIM_CBP_INTEGRATION, however this can be used if you want to integrate Point of Sales data with CBP.

If you have market research data then, your transaction data would be present in the DSO /DDF/DS14 which is the market research retail propagation DSO.

Step 1 : Calculation View Creation

SAP provides a standard calculation view for DSiM-CBP Integration below.

However, this calculation is again based on /DDF/DS11, which is POS DSO.

You can create a custom calculation view on the similar lines as standard for market research DSO /DDF/DS14. We need to join the transaction data DSO /DDF/DS14 along with master data for Product /DDF/PRODUCT, master data for location /DDF/LOCATION and Time master data.

See below the custom calculation view that I have created.


Step 2: Create External view based on the Custom Calculation View

Go to ABAP perspective in your HANA Studio, and under Dictionary right click on Views and Select New Dictionary View, and create and external view on the calculation view we have created in Step 1.

Once the view is created save and activate it.

Note that if any of the fields in your calculation view start with and underscore like _S_LOCATION, then the external view creation will throw an error. So correct the field names in your calculation view before creation of external view.

Step 3: Maintain SPRO Settings


Define the calculation view and the External view name here in SPRO and save.

Step 4 : Create Datasource using function module

Create a custom datasource that is copy of the standard datasource /DDF/DSIM_CBP_INTEGRATION

You need to create an extract structure whose fields are exactly the same as the external view.

In the function module the data will be selected from the external view. You can refer to the standard function module code.

You can test the datasource in RSA3 and see it displays data once ready.

This datasource can be used to feed data to CBP DSOs and integrated with rest of the CBP data and used for the forecasting process.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Guilherme Costa
      Guilherme Costa

      Great content. Clear and concise. Thank you!

      Author's profile photo Sergiu Alexei
      Sergiu Alexei

      Well structured, short & clear on each step.
      SAP, setts the global standard on how to manage operations and helping organisations to do more with less.