Dear Team,

Please find below the Excel upload format I am using to update item texts for multiple purchase requisitions (PRs) in SAP. The file contains PR numbers, corresponding line item numbers, and the desired item text to be uploaded.

PR Number PR Item Number PR Item Text
3400001460 10 8 HOLES
3400001460 20 PMI TESTING
3400001460 30 HARDNESS TESTING
3400000875 10 MECHANICAL TESTING
3400000875 20 LADDLE ANALYSIS
3400000875 30 HARDNESS TEMPERATURE

I kindly request your support in providing a VBA macro that can:

• Open ME52N in SAP.

• Process each PR and line item from the Excel sheet.

• Update the item long text accordingly.

• Loop through all entries and save changes.

This automation will help reduce manual efforts and ensure consistency in text updates.

Please let me know if you need any additional details or adjustments to the format.

Thank you for your support!