source list and vendor

[John_G]

Dears

I would like to make a massive extraction such as using tables in order to link vendor coming from source list and material .

I tried to use EORD but it does not contains the exact proper information because on my understanding it records every vendor added to a material but in the case the vendor is deleted (using ME01) , I see in the EORD the list of the old vendors (instead of nothing)

Do you have any suggestion about it

Thanks, John (Giovanni)

[Vaibhav-Mishra]

Hello giovannigiardina,

In such a situation you can join table EORD and MARC and filter out the results based on field MMSTA = '05'. This will give you only those records in output where materials are not obsolete.

Vaibhav

[John_G]

Hi vaibhaverp

Thanks for the suggestion , anyway let me say that for instance a material could be marked as obsolete for a certain period of time and then be again available to be ordered after a while

Of course it means to check if those are still valid suppliers for that material , looking at 'Valid to' and if the price is updated

I remain at disposal

John

[Vaibhav-Mishra]

Hello giovannigiardina,

When a material is marked as obsolete then delete all the entries from source list (ME01). It will not appear in the EORD table entries.

Please refer below screenshot.

Vaibhav

[John_G]

Dear Vaibhav

ok thank you , if I got your point , it means that to exclude those vendors that are blocked I need to filter the field NOTKZ = "blank" ( because those blocked should have a 'x' in the cell)

Let me ask another quick question , I noticed that if the material is marked as 'obsolete' , when I try to enter the ME01 with that material , it is not possible . However this material and its vendors appear in the EORD

If you have any suggestion on this second thing , it is very appreciated

Thanks

John

[Vaibhav-Mishra]

Hello giovannigiardina,

If a vendor is removed (or deleted) from source list then it will not appear in EORD table. However, if you block a vendor then it will appear in the EORD table. You need to filter out the table output on the basis of field => NOTKZ in EORD table.

NOTKZ indicates vendor block.

Vaibhav