How to use SAP Cloud Integration for Data Services (CI-DS) to load data from S/4HANA with Generic Extractor – Part 1
In time-series based integration of SAP Integrated Business Planning for Supply Chain (SAP IBP), SAP CI-DS is used as the integration tool to deal with the data integration between IBP and S/4HANA, ECC or other systems. CPI-DS can call SAP standard Extractors or custom Generic Extractors to extract data from S/4HANA.
The blog series will give examples to explain how to define custom Generic Extractor and how to configure CI-DS to call the Exactor to load the full data or delta data from S/4HANA.
- Part 1. Use CI-DS to load full data from S/4HANA with Generic Extractor
- Part 2. Use CI-DS to load delta data from S/4HANA with Generic Extractor
This blog post is Part 1 to explain how to use CI-DS to load full data from S/4HANA with Generic Extractor.
We would like to use CI-DS to load full Product master data from S/4HANA to IBP with custom Generic Extractor.
To make it simple, we focus on the bellowing.
- S/4HANA side: Define a simple Generic Extractor based on DB view to extract full Product master data.
- CI-DS side: Configure the data flow and mapping to call the Extractor.
1. S/4HANA side: Define a simple Generic Extractor based on DB view to extract full Product master data
Generic Extractor can be defined based on DB View, SAP Query or Function module. Here we gave a simple example to define Generic Exactor based on DB View.
1.1. Define DB View (Tcd: SE11)
Select MARA and MAKT table for the table join.
Configure the fields of the DB View.Set the selection condition.
1.2. Define Generic Exactor (Tcd: RSO2)
Create new Data source(Extractor) based on the above DB View.
Define Selection and Hide fields and save.
1.3. Test Extractor with ABAP Report program RODPS_REPL_TEST
Run and display the data extracted.
2. CI-DS side: Configure the data flow and mapping to call the Extractor
2.1. Import the definition of the Extractor into the Data Store of S/4HANA.
- Query: Full data load
- Change Data Capture: Delta data load
2.2. Configure Extractor Option in the mapping of the data flow.
Indicates the maximum number of rows the extractor reads from the source and loads into memory at one time. Once the system processes and loads these rows to the target, it reads the next set of rows. By limiting the number of rows, less memory is used. Default is 1,000.
For changed-data capture (delta loads), indicates whether to reload all the data on a subsequent run.
- Yes: Returns a full extraction
- No: Returns only data that has changed since the last run
Extract from datetime
Indicates a specific date and time for when to extract changed data. Select a predefined global variable of type datetime. If the datetime value is the same as the value from the last execution, or falls before the value from the last execution, the system repeats the last changed-data extraction. If the datetime value is later than the value from the last execution, the system returns the new data.
Parallel process threads
Specifies the number of threads used to read the data.
We recommend that you don’t use this option. Setting a value can cause the software to go into recovery mode after the first iteration, resulting in sending the same rows repeatedly.
I hope this blog post was helpful to understand how to use CPI-DS to extract full data from S/4HANA with Generic Extractor. In Part 2 of the blog series, I will give an example to explain how to extract delta data from S/4HANA with Generic Extractor.