bholus7 has just posted in the SAP MM Forum (Material Management Module) forum of Wiki Newforum under the title of How To Get The Vendor Master List.
This thread is located at http://www.wikinewforum.com/showthread.php?t=6127
Here is the message that has just been posted:
***************
How To Get The Vendor Master List
ERP SAP ==> SAP MM
How to make a list of vendor (active and non active) sorted by name?
How do I generate a report showing all active vendors with their corresponing vendor code in SAP?
Report for Vendor List is "S_ALR_87012086"
Info Records Per Vendor is "ME1L"
Use T.code ME2O for Subcontracting stock monitoring per vendor.
MCE3 : Vendor analysis Selection
MCVA : Vendor Analysis Lot Overview
MCVA : Vendor Analysis Lot Overview
MCVB : General Results for Vendor
MCVC : Vendor Analysis - Qty Overvie
MCVD : Quant. Results for Vendor
MCVE : Vendor Analysis Quality Score
MCVG : Vendor Analysis - Lot Numbers
MCVI : Vendor Analysis - Quantities
MCVK : Vendor Analysis - Effort
MCVM : Vendor Analyis - Level & Disp
MCVO : Vendor Analysis - Lots Overview
ME2L:Purchase Orders by Vendor
You can also create SAP Query using the folling table names:
LFA1 - Vendor master
LFB1 - Vendor per company code
LFB5 - Vendor dunning data
LFM - Purchasing organization data
LFM2 - Purchasing data
LFBK - Bank details
SAP Query can be created using T.codes SQ02, SQ03 & SQ01 T.codes.
How to get a report on vendors list by company codes wise with account group?
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) List of vendors company codes wise with account group wise
MKVZ
***************
