Question Re: Vendor Material No based on Vendor Name in Spend Management Q&A

Vendor Material No based on Vendor Name

former_member1071387 — Tue, 28 Sep 2021 13:16:48 GMT

Hi, I was wondering if you guys might be able to give me some help.

I emailed a list of hundreds of parts to suppliers to ask for the latest prices. But then I got response from my suppliers asking me to include the Vendor Material Number in the list. I tried using ME12 to find the Vendor Material Number, but it was a bit inconvenient because I had to find it one by one.

So I would like to ask, is there any way to pull all vendor material numbers based on vendor name, so that I can't match it with Material Number (our internal control number) using vlookup etc.

Thanks so much.

Re: Vendor Material No based on Vendor Name

former_member751591 — Tue, 28 Sep 2021 13:17:07 GMT

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

Re: Vendor Material No based on Vendor Name

BijayKumarBarik — Tue, 28 Sep 2021 14:25:19 GMT

Check ME1L may helpful as vendor material number field available but it is text field!

Else you can go for development having material number, old material number and vendor material in an output screen at least two fields

Cross check you have MPN process already . Refer MPN