RE:[sap-log-mm] T code for Vendor wise inventory report

Posted by Sap Land Friday, 10 June 2011 08:52

Posted by emmanuel_leclainche
on Jun 10 at 11:57 AM

Hello

You can also build an easy custom query with SQVI.

In SQVI, pick tables MARD, MAKT and EINA.

Link MARD-MATNR to MAKT-MATNR
Link MARD-MATNR to EINA-MATNR

Pick as data:
MARD-MATNR (select and display)
MAKT-SPRAS (to choose the Language, select)
MAKT-MAKTX (Display)
MARD-WERKS (select and display)
MARD-LGORT (select and display)
MARD-LABST (Display, I'm taking only this stock, hope it's ok, but I think it is what you seek)
EINA-LIFNR (select and display)

You can add the name of vendor adding LFA1 in the query (Link to EINA-LIFNR to LFA1-LIFNR and add LFA1-NAME1 as a display field)

Emmanuel

---------------Original Message---------------
From: siegsand
Sent: Wednesday, June 08, 2011 10:40 AM
Subject: T code for Vendor wise inventory report

Hardip, besides the codes already returned, you might try the following,
but these will give you material ordered from the vendor:

ME2L - PO - List Display - By Vendor
ME80FN - General Analysis
ME81N - Analysis of Order Values
MCE3 - PurchIS - Standard Analysis - Vendor
ME6H - PurchIS - Standard Analysis - Vendor Evaluation

If you want to know how much inventory you have from a particular vendor,
the first assumption is either that each material is single sourced or
that you are using batch management to determine the source of the
material in inventory.

Then either selecting by material or batch, besides MMBE, you could also
use:

MB52 - Warehouse Stock
MB5B - Stock For Posting Date
MBCE - Inv Cont - Standard Analysis - Material

Siegfried (Sieg) F. Sanders
Managing Consultant
IBM Global Business Services

: www.ibm.com/gbs/assetmanagement

__.____._