First you need to download the list of all vendors created from the table LFA1..Copy the vendor by exporting it to excel from this table data..Having done with this please go to FBL1N...Select all item with normal and special GL indicator and give date range for the whole year..Paste the vendor number in vendor and execute the report. After when it is executed you may filter payment document types, do not forget to fetch Account field from layout into in your layout. You will now have all the list of vendors that were active during the date range given.. I hope this help .
you can use the table LFA1 or LFB1 to view all the vendor in the system.
you can filter these vendor on based the payment block, get all the list of blocked vendor then you can easily find the all the active vendors in the system.
you can choose the filed based on your requirement from this table.
Hope this will help you.
Thanks and Regards,