cancel
Showing results for 
Search instead for 
Did you mean: 

Tables for MMBE

Former Member
0 Kudos

Dear all,

Could you please let me know when ever u r executing MMBE t.code u can see UR,Quality,Bolocked stock ,stock provided to vendor , in which table this data will get stored, i need to prepare report which my client want to see the qty that is provided to vendor in his report

Regards

venu gopal

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

List of tables used by MMBE report

EKBE History per Purchasing Document

EKPO Purchasing Document Item

MAKT Material Descriptions

MARA General Material Data

MARAV Generated Table for View MARAV

MARC Plant Data for Material

MARCV Generated Table for View MARCV

MARD Storage Location Data for Material

MARM Units of Measure for Material

MCH1 Batches (if Batch Management Cross-Plant)

MCHA Batches

MCHB Batch Stocks

MKOL Special Stocks from Vendor

MSCA Sales Orders on Hand with Vendor

MSKA Sales Order Stock

MSKU Special Stocks with Customer

MSLB Special Stocks with Vendor

MSPR Project Stock

Thanks & Regards

Kishore

Edited by: Kishore Kumar Chiluka on Jul 15, 2008 8:03 AM

Answers (3)

Answers (3)

deiva
Active Contributor
0 Kudos

hai,

Check the following tables MCHBH - batch stocks history, MSLB - Special Stocks with Vendor, MSEG  Material document / transaction details &

MBEW   Material stock with valuation  

Former Member
0 Kudos

Following are the Table which is being used.

MCH1

MCHA

MCHB

MBEW

MSKA

MSPR

MARD

MSLB

MKOL

MSKU

MDUR

MDUB

VBBS

MDFA

And Use MBLB for the Stock with the Subcontractor.

Former Member
0 Kudos

the best way to do it by Movement types. make your query using MSEG table where all movements you will get.

Regrds

S