Vendor Detail

[Former Member]

Hi,

I had downloaded Vendor details from LFM1 table with respect to purchase organisation.I need to know the active vendors and inactive vendors.So I checked the tcode MKVZ with respect to the same purchase organisation name.But I found some additional vendor numbers in MKVZ for that Pur. Org. which were not in the list from LFM1 table .

Which data should I accept ?? I need the active vendor list with respect to a particular Pur. Org. . Iam confused which data I should take and how can we determine whether the Vendor is active or inactive ????

[former_member233510 · Accepted solution]

Please check report MKVZ for finding the inactive vendors.

You've to filter using the fields block function and purchasing block for purchase organisation as shown in the screenshot below.

Please note that the report MKVZ brings the data for display only if the vendor is maintained at purchase org level so it is not possible to have different data in that report and the table LFM1. Ensure did you use any filter.

[Former Member · Accepted solution]

The no. of hits in LFM1 table was set 500 and in MKVZ there were about 1000 items.I guess that is why it did not showed the rest of the data.

And I agree with Pur. Block POrg field,but is it the other field Block function or Delete flag for vendor at purchasing level that is the criteria for checking active or inactive vendors?????

[former_member233510 · Accepted solution]

You've to consider the field Block function.

[Former Member · Accepted solution]

Thank you