To perform mass changes to vendor master records, follow the steps below:
- Login to MDO with your assigned credentials.
- From the left menu select Business Partner > Vendor.
- From the Vendor List page select the vendors which need to be changed.
- Once the records are selected, click on Download.
- Select Excel Connect and then select the template for change.
- Click Download and open the downloaded Excel Connect template.
- Click on the Login icon at the top left corner and login with your MDO credentials.
- The selected records will appear in the Excel Connect template.
- Make the necessary changes to the vendor details.
- Once completed, click on the Validate icon in the Actions section of the template.
- 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.
- Click on the Export icon to export the data to MDO.
- Once the data is exported, click on the Complete icon. The records are updated in MDO and the change workflow triggered.
- On completion of the workflow, the changed records are integrated with SAP.