list of active vendors.

[Former Member]

Hi I wanted to provide list of active vendors to the client.

For that I have taken out vendors from EEKO table for last 12 months.

But from client I get below answer.

please confirm this is all active vendors used in the past 12 months, not just those we have raised purchase orders against as we only raise purchase orders for 50% of our vendors.

Please help if I am providing half information.

[kailas_ugale · Accepted solution]

Hi

check following report

Report for Vendor List is S_ALR_87012086

Info Records Per Vendor is ME1L

MCE3 = Vendor analysis Selection

MCVB = General Results for Vendor

MCVE = Vendor Analysis Quality Score

ME2L=Purchase Orders by Vendor

Regards

Kailas Ugale

[Former Member]

Hi,

Please check vendors os ageing report.

Please check debit and credit balances in report-s_alr_87012079. You can find this data based on period-wise.

This will help you to identify the list of those vendors whose debit and credit balances are ZERO.

Thaning you,

Sandesh Sawant

[former_member226365]

This message was moderated.

[Former Member]

Hi,

We too did this for our client.

First as you are doing, we need to refer the EKKO for the active vendors from MM side. and then you need to refer FBL1N for the said period. Here you may receive few more vendors for which there is no PO, but invoice is posted thro FI using FB60.

Regds,

CB

[sb_er]

Find the list of vendors

MKVZ

[JL23]

in MM you only get vendors activities in statistics if you create POs.

but if you have vendors for which you do not use the MM process, then you just post the invoice in FI module.

Hence you have to run FI reports to get all vendors with activities.

like S_ALR_87012093

[Former Member]

Try executing MC$4. That will give a selection date range.

Thanks...

[Former Member]

Hi,

There is another report for S_AL0_96000385 - Top Vendors Report. An alternative transaction is MKVZ. Thanking you.

[Former Member]

Hi, You can run S_ALR_87012086 for a vendor list . If you select delete flag in furher selection segment in selection parameters of this report, you will get the list of deleted vendors. After that you get the whole list of vendors. Compare these two lists and exclude deleted vendors. Thanking you.