Register Login

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

×