If anyone can help me with the right solution then it would be helpful for me.
1) List of vendors company codes wise:
SAP Easy access -> SAP Menu -> Accounting -> Financial Accounting -> Vendors -> Information System -> Reports for Account Payable Accounting -> Master Data -> S_ALR_87012086 - VENDOR LIST
2) For Material list Use T-code = MM60
3) List of vendors company codes wise with account group wise:T-Code = MKVZ (sort by Name of Vendor) for Vendor List
Report for Vendor List is "S_ALR_87012086"
Info Records Per Vendor is "ME1L"
SAP Query can be created using T-Codes SQ02, SQ03 and SQ01
Creating SAP Query using the below mentioned table names: