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.