cancel
Showing results for 
Search instead for 
Did you mean: 

source list and vendor

John_G
Explorer
0 Kudos

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)

Accepted Solutions (0)

Answers (5)

Answers (5)

Vaibhav-Mishra
Active Participant
0 Kudos

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
Explorer
0 Kudos

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
Active Participant
0 Kudos

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
Explorer
0 Kudos

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
Active Participant
0 Kudos

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