Technical Articles
Mass processing of Business Partners using MDC in FIORI(Part-1)
Hi All,
During all SAP Implementation and roll-out projects we will have a requirement of updating different kinds of master data in the system.
The most common way is to use the ‘MASS’ transaction or develop custom programs using BAPI, BDC or LSMW to update master data.
For customers on S/4 Hana with MDG component , we can use Mass processing and consolidation option to upload different kind of master data’s (Business Partner, Business partner Relationship, Product master ).
In this blog i will share how to configure MDC for Business partner Mass change and use standard SAP FIORI app to perform in the front end.
INTRODUCTION
Master data consolidation and mass processing (MDC) is a module which helps in data cleansing.
A standard MDC process has many process steps , and in this blog i am going to share only about
creating the process templates , defining the scope and Activation .
It requires some basic knowledge of MDG , Odata services , BGRFC and authorization objects.
MAIN CONTENT.
-
The first step is to configure the process templates.
- Go to MDCIMG ->Configure process Models-> Import predefined process templates for business partners
- Go to MDCIMG ->Configure process Models-> Import predefined process templates for business partners
-
- Once the BC set is activated the process template will be available for use.
- Once the BC set is activated the process template will be available for use.
2 Configure process model
-
- 147 BO for Business partner , 1405 for Business partner relationship , 194 for product and MDC_147 for consolidation of Business partner
- We have configured for 147.
3 Configure Scope
-
- In this step we can define the fields which are going to be changed during a mass processing process.
- We have defined a (LFB1-BUSAB) as a field just for testing purpose but we are going to use custom scope and define our fields during mass processing.
- In this step we can define the fields which are going to be changed during a mass processing process.
4. Configure Activation
-
- The activation step can be configured with a change request or can be direct activation.in this article we have done direct activation
- There are 3 types of records -> New , Update and match groups.
- The activation step can be configured with a change request or can be direct activation.in this article we have done direct activation
5. Configure BGRFC destination
-
- BGRFC is required to trigger the workflow process for the MDC consolidation
- Go to SBGRFCCONF -> Define Inbound Destinations
- Go to SBGRFCCONF -> Scheduler destinations
6. Configure Fiori app
-
- There are 3 Fiori apps configured
- Start mass processing for Business partners -> https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F1686A’)/S18OP
- Export Master data for business partners-> https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F3251’)/S18OP
- Manage mass processes for business partners -> Copy this app from Business catalog SAP_CMD_BC_BP_MONPROCS.
- There are 3 Fiori apps configured
P:S: In the next blog i show how the Fiori apps are used to update, extend and delete the Master data.
https://blogs.sap.com/2021/02/01/mass-processing-of-business-partners-using-mdc-in-fiori-part-2/?update=publish
CONCLUSION
This article will help consultants in setting up MDC in their system and use it for master data updates.
Please feel free to share your comments and suggestions
Regards
Anirban
Hi Anirban,
thanks for the excellent blog. I followed configuration as per the guidelines. Exported 2 Business partners from the system and tried performing "Mass processing" But I get the following error "Changing Worklist Content failed". When I try to check log in MDCLOG transaction, I see the following error No Source System Maintained for Source record of process 45. Why is the source
system asked when I am trying to perform mass processing in the same system. can you please throw some light.
thanks
Geetha
Hi Geetha
could you please share some screenshot of the error for better understanding
Regards
Anirban
Hi Anirban,
Thanks for your quick response. I followed the config what you have suggested and made the config suitable for payment terms update. Made a data extract of BP through export master data from the same system and updated the payment terms for the 2 BP. now initiated Start Mass processing - Business partners select the exported and modified file and inserted in import file field. next step I get an error "malfunction URI literal syntax".
thanks
Geetha.
Hi Geetha,
Can you let me know what is your S4CORE and MDG version?
I have used 1909 FPS01 for this function.
Also, SLG1 screenshot is just a warning and as per me it should not impact the import process.
As far as the error message is concerned there is a note with similar symptoms
3006346 - Malformed URI literal syntax error in attachment facet from application.
Please check if it helps you.
Regards
Anirban
Hi Anirban,
Thanks for responding. Even if in SLG1 it is a warning, I am unable to proceed and see the next dialog "Scope" which should display. I am stuck with the first screen "Start mass processing".
I have let the Basis team to apply the OSS note which you have suggested.
Third item software release in S4 HANA 1909. Here are the details. Do you see since we are in MDG 80 release as below is it causing issues.
s4core is release 104 and SP level = 0002
S4 Hana on Premise 1909 SP stack 02(05/2020)
MDG_FND release 804 SP-Level 0002
MDG_APPL release 804 SP-Level 0002
MDG_UX release 804 SP-Level 0002
UIMDG001 release 200 SP-Level 0008
Please guide. Once again thanks for your help.
thanks.
Geetha
Hi Geetha,
Once your BASIS applies the note let me know if it resolves the issue.
For MDG version you should check in SFW5 if MDG 9.0 business functions are activated or not.
APPL and FND versions are fine.
Regards
Anirban
Hi Anirbhan,
Applied the oss note 3006346 - Malformed URI literal syntax error in attachment facet from application and it did not solve the issue.
You have mentioned if oss notes does not solve then check in SFW5 if MDG 9.0 business functions are activated or not. APPL and FND versions are fine.
To my understanding MDG need not be activated and mass processing and consolidation can still be used as part of S/4 HANA core.
Also in our system as MDG relevant components are not activated if I go to tcode /nMDGIMG dont see the spro node(I get error) but If I type in tcode /nMDCIMG I can see all the spro nodes for master data governance,Consolidation and Mass processing.
Please correct if my understanding is incorrect.
Attached the snapshot from SFW5 where mass processing and consolidation is part of S4 Core component.
Please guide can the mass processing functionality works with MDG activation.
best regards
Geetha.
Hi Geetha,
Your business functions are fine.
Can you try to clear the cache for the gateway using /IWFND/CACHE_CLEANUP
Put model identifier as *MDC* and clear cache for the IMPORT service.
Remove all models and all proxy models checkbox.
Please try and let me know.
Regards
Anirban
Hi Anirban,
I tried clearing the cache for the gateway using /1WFND/CACHE_CLEANUP as you suggested and tried still the same error "Changing worklist Content failed" and in the backend SLG1 transaction I get this error message
No Source System maintained for source record of process 56
Message no. MDC_PROCESS_MSG027
What I understand It is not able to interpret the source file. I tried creating the source file by using the
"Export Master data: Business Partners" App and created the file by providing a BP and selecting the option "Select all Fields from all Tables" did not check Include long text fields and save it as *.xlsx field.
Open the file in desktop and changed the field KNB1-ZTERM value from 0001 to 0002 and tried to load. Note in SPRO I have configured in scope - scope field as KNB1-ZTERM.
is there a way you can show how the sample file. I am unable to load a sample file.
I want to rule out the file is an issue or any other guidance. Thanks for all the help.
best regards
Geetha
Hi Geetha,
I guess it is better you raise a OSS message , since i cannot access your system i am analyzing only with limited steps.
As far as the file structure is concerned you can refer to the below blog.
https://blogs.sap.com/2021/02/01/mass-processing-of-business-partners-using-mdc-in-fiori-part-2/
Regards
Anirban
Hi Anirban Roy
Thanks for the valuable information.
Mass processing is working fine and data is replicating in SAP MDG system but not replicating to target S4 HANA system.
Could you please let me know where i was missing.
Thanks in advance.
Hi Mallika,
Could you share details on whether your landscape is a hub or co-deployment.
Regards
Anirban
Hi Anirban Roy,
Thanks for the reply.
It is co-deployment.
Thanks in advance.
Hi Mallika,
If its co-deployment then if data is there in MDG , it should be available in S4 ERP tables also assuming you are using re-use model as standard MDG BP data model.
Please help to share some details about your setup so that i can suggest further.
Regards
Anirban
Hi Anirban Roy
I guess it should mark call DRF after activation, As per below screenshot.
Is this were iam missing.
Let me know your inputs on this.
Thanks in advance.
Hi Mallick,
Please try and see if it works.
For me i have a co-deployed MDG box but i didnt use this checkbox.
Regards
Anirban
Hi Anirban Roy
Thanks for the reply.
No luck. call DRF after activation field, is read only not able to edit.
do we need to maintain Target system RFC destination in SBGRFCCONF transaction code?
Hi Malika,
Even I am facing the same issue, were you able to resolve your issue?
Thanks,
Preetesh
Hi Anirban,
Thank you for sharing this blog. I would like to understand the licensing impact of this MDG component. We are on S4 HANA 1909 and we would like to use this functionality for our mass processing requirements for Product master and Business partner master data. Do we need separate license or we can straightaway activate the BC sets for the process templates and activate this functionality.
Hi Mihir,
For licensing , please check with SAP sales team by raising a OSS as i am not aware of the licensing intricacies.
From a product perspective Product master is supported out of the box. You can use it for Business partners , Business partner relationships and Material master.
Regards
Anirban
Hi Anirban,
Thanks for the informative post.
I have one query related to MDG Mass processing via consolidation. I am implementing this without change request type. Is there any way to set the validation on the records which are locked under a change request. For example if there is a record which is locked under a CR, and if user tries to create a process via MDC, the user should get validation error stating that the record is locked into a change request. I have checked the change request check indicator but this validation is not working.
Regards
Rohit