Register Login

Vendor Master & Material Master List

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.




  • 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