Vendor Master & Material Master List

Updated May 18, 2018

How to get Material master list and Vendor master list?

If anyone can help me with the right solution then it would be helpful for me.

Regards,

Anand.

Comments

30 Jun 2016 11:59 am Jyoti Pandey Best Answer

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"

T-Code	Description
ME2O	Subcontract stock monitoring per vendor
ME2L	Purchase Orders by Vendor
MCVO	Vendor Analysis - Lots Overview
MCVA	Vendor Analysis Lot Overview
MCVA	Vendor Analysis Lot Overview
MCE3	Vendor analysis Selection
MCVB	General Results for Vendor
MCVC	Vendor Analysis - Qty Overview
MCVM	Vendor Analyis - Level & Disp
MCVI	Vendor Analysis - Quantities
MCVE	Vendor Analysis Quality Score
MCVD	Quant. Results for Vendor
MCVG	Vendor Analysis - Lot Numbers
MCVK	Vendor Analysis - Effort

SAP Query can be created using T-Codes SQ02, SQ03 and SQ01

Creating SAP Query using the below mentioned table names:

Table Name	Description
LFBK	Bank Details
LFB1	Vendor per company code
LFA1	Vendor master
LFB5	Vendor dunning data
LFM	Purchasing organization data
LFM2	Purchasing data