List of vendors in SAP

X

This site uses cookies. By continuing, you agree to their use. Learn more, including how to control cookies.

 To display all the vendor list, MM provides a reprt.

So run Tx- MKVZ.

Execute the report.

Here is the list of vendors. To display the details, select one line and choose icon Central.

Here the Vendor details. Choose the right arrow to see other info.

Accounting details of the vendor.

Purchasing Data of the Vendor.

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

Regards,

Anand.

• 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

Hello,

I am trying to figure out an efficient way to retrieve a list of all the vendors we have in our SAP system with their mailing address and email address.

I need to craft an email to send to all of our vendors expressing an address change and other than individually going into the vendors profile and extracting the address manually I know no other way to retrieve the information.

I tried searching for a solution but was unable to find anything.

I appreciate any help.

Thank you,

rj