Is there a way to pull supplier #'s for each material given the material #?

[Former Member]

Is there a way to pull supplier #'s for each material given the material #?

I'm doing a Safety Stock Analysis Report and I need to add a column for On Time Delivery Score for each of the parts. In order to do that I need to first add a column with the supplier number's for each of our materials given the material number. I know I can do this manually for each one in LFA1 but is there a way I can pull this information for all of the materials?

[JL23]

can you explain this a bit differently as it is hard to understand what you can do

A programmer who can make this happen is usually not analyzing safety stock, and people analyzing safety stock are usually do not do programming. So what can you really do? Are you doing this in Excel or do you look for transactions from which you can download data which can then be used in Excel via VLOOKUP or similar?

LFA1 has no link to stock, except each and every material is batch managed. But a stock analysis is usually not done on batch level.

So what would be the right choice, purchase orders, here you have countless POs for one material. Info records as alternative, are you using them?

You see, your question needs more input to be answered

[former_member42743]

Are you using source lists? That info would be in table EORD.

Or you could download entries in EKKO and EKPO to Excel. Use VLOOKUP to copy the vendor number from EFFO to a new column on EKPO.

Then in EKPO remove duplicates based on columns material number and vendor number.

That should give you your unique list.

You could probably build a simple query in SQVI that would do this for you and you can link in the material description and vendor name in as well from their respective tables.

[Former Member]

How can I access my settings if it's shown as gray and won't let me click on it? I try to go to Settings > characteristics display > key and description but it will not let me click on key and description I'm not sure why.

[JL23]

If you have access to MC$4 transaction then you can get the purchasing volume per vendor material combination, better than going into purchase order directly and the export to XXL gives you actually a better view than the online transaction.

before exporting do your settings via menu Settings > characteristics > key (or key and description)

in addition you have to change the length of the displayed characteristic via menu Settings > Column width Characteristic and set it e.g. to 50 for number and description

[Former Member]

I am doing this in Excel and I will then use this information to do a VLOOKUP in order to get the on time delivery score (still not sure how I'm going to do this yet but I know that in order to do that I will first need the supplier numbers for each part). I already calculated a new Safety Stock for each material using the monthly average, weekly average, safety stock, weeks of safety stock, max value usage, weeks on hand, cost, and Lead Time for each material. What I am trying to do now is figure out how the On Time Delivery Score for each of our suppliers impacts the Safety Stock level and if we should ultimately raise or decrease safety stock. For example if a supplier has a low on time delivery score I would then increase the safety stock level to maintain a safe level of inventory.

I found an easier way to do it in ME1M but it still involves me having to manually go through each material to get the supplier # and there are more materials listed than I need listed. Is there a way I can use PO's for each material in order to get the supplier # without having to do it individually for each item? I hope this explanation helped, if not let me know what is not clear and I will try to further explain.