vendors list

[Former Member]

Dear Sap gurus

I have 8000 list of vendors now I want to segregate vendors who are not in use from two years. How do I do?

Regards

Srinivas.

[Former Member]

Dear,

Check the similar solved issue:

Regards,

Syed Hussain.

[Former Member]

Vendor is not only used for creating PR & PO, Direct Postings also made against Vendor in FI..

You need to check the Accounting Documents to Know how many vendors active..

for that you can check MR51 trxn code..

[Former Member]

Test run the archiving through SARA (object FI_ACCPAYB), the inactive vendors would be extracted as archivable.

[Former Member]

Dear

we havent block the vedors , but now i want list of vendors who are not in use since two years.

Regardds

[Former Member]

You need not block the vendors, when you test run the archiving through SARA ... system will show you the list of vendors who can be archived, which is nothing but the list of your inactive vendors. Hope this explains, if not ... try it once in your development server.

[Former Member]

Dear

Thanks a lot for quick support

I dont want to block the venodrs , just i want to Know only.

Regards

srinivas

[Former Member]

Dear Srinivas ... i said TEST run ... that mean you need not accept and execute the archiving, just pull out the list for your use and exit without executing. As far as Why is concerned .. you have answer in your question itself ... they are inactive !!! and hats why SAP suggest then as archivable

[Former Member]

Dear Freind,

check table LFA1 with field ERDAT thru se11/se16 in this u get vendor creation date,and list of vendors

Use the table EKKO and download the documents for your requirement dates and sort by vendor number and get the vendor info from LFA1 or LFM1 or LFB1 .This is one way.

regards

Pramod

[Former Member]

Dear Friends

Thanks alot for your contineous and valuable support.

Regards

srinivas