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.
Thank you for the post, but i have a question related to some other tile in Consolidation and Mass Processing of business partner. Hope it is okay to ask about that.
Could you please let me know how we can achieve the Create Consolidation Business Partner.
I am actually following the below thread from SAP
But it would be really helpful if you write a blog for the same. 🙂
I have a question regarding the access to SAPABAP1 ~ SAPHANDB Schema is that fine to give write access to this most important schema where it has all the tables of SAP S4
You raise a valid point here. Typically we would not recommend providing DB access to the transactional schema within S/4HANA. Even though Data Services would be using what we consider a "technical user" to connect to the HANA DB it still would allow all DS developers who have access to that datastore to potentially be able to read/write to tables in the SAPABAP1. This potentially validates certain license requirements as well.
We would recommend only populating the MDG Consolidation Source tables through the Application layer in SAP. This could be done via the Web Service SOAP call or by creating a custom ABAP function which would populate those tables.
Either way ---- not going against the DB layer directly.