SAP MDG Consolidation data import: The ETL way
The objective of this blog is to explain how the SAP MDG Consolidation source tables can be populated using SAP Data Services.
SAP MDG, consolidation and mass processing enable you to consolidate your master data and it helps you to run mass processes to update more than one master data records at a time. The order of the process steps, as well as the behavior of each individual process step type, can be adapted for your necessities.
Data load is the first step in master data consolidation of the source records. The process flow diagram above shows the data import from the file. You can fill the data in a .csv file or .xlsx file in a predefined format that the consolidation system accepts. SAP note: 2233142 – Example: How to fill Source Tables uses ABAP code to fill the consolidation tables.
The data to be consolidated can be loaded from SAP and non-SAP-systems using ETL tools. In Create Data Import Fiori app, there’s no option to select the ETL method. Now you might wonder how to load the data in the MDC system using an ETL tool. The answer is to load the data directly in the MDC tables. At the time of this writing, MDG consolidation is available for business partners, Material master, and custom objects.
Master data consolidation source tables follow the naming convention <table_name>_SRC. For example, BUT000_SRC, LFA1_SRC, etc.,
Refer to this page for more information on BP/Customer/Vendor tables.
Now let’s see how the MDC tables can be populated using SAP Data Services.
The SAP MDG system in this example uses the HANA database to store the consolidation source tables. So as a first step create a data store connection pointing to the HANA database in Data Services Designer. Make sure that the DB user has read and write access to the _SRC tables.