To perform mass changes to vendor master records, follow the steps below: 

1. Login to MDO with your assigned credentials. 
2. From the left menu select Business Partner > Vendor. 
3. From the Vendor List page select the vendors which need to be changed.  
4. Once the records are selected, click on Download. 
5. Select Excel Connect and then select the template for change. 
6. Click Download and open the downloaded Excel Connect template. 
7. Click on the Login icon at the top left corner and login with your MDO credentials.  
8. The selected records will appear in the Excel Connect template. 
9. Make the necessary changes to the vendor details. 
10. Once completed, click on the Validate icon in the Actions section of the template. 
11. If the status on the left- hand side changes to Success, the data is validated successfully and can be exported to MDO. If the status is Error, there is a problem with the data entered. Correct the data according to the message shown and re-validate. 
12. Click on the Export icon to export the data to MDO. 
13. Once the data is exported, click on the Complete icon. The records are updated in MDO and the change workflow triggered.  
14. On completion of the workflow, the changed records are integrated with SAP.