cancel
Showing results for 
Search instead for 
Did you mean: 

mmbe table and MB5B table

bear_boy
Participant
0 Kudos

is it possible, if i create a query, and tie up the two tables? what are these tables?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Can you tell me you exact requirement ? MMBE n MB5B transaction are linked with many tables.

reg

Durga

bear_boy
Participant
0 Kudos

i want to create a query, where i could view a material, its stock level per batch number, its stock grade, its batch number, and its SLED.

Former Member
0 Kudos

Hi

Did you try using the report MB5M - Expiration Date List , if your requiremnt is not satisfied using the report, you can use the following tables

MARC Plant Data for Material

MARCV Generated Table for View MARCV

MARD Storage Location Data for Material

MCHA Batches

MCHB Batch Stocks

MBEW - Material Valuation.

Thanks & Regards

Kishore

Former Member
0 Kudos

hi

for your kind information both MMBE & MB5B are transaction codes not tables.

Regards,

bear_boy
Participant
0 Kudos

i know that. i just need the tables of the two transactions i previously mentioned

Former Member
0 Kudos

Hi

The list of tables used for MMBe Report are

EKBE History per Purchasing Document

EKPO Purchasing Document Item

KNA1 General Data in Customer Master

LFA1 Vendor Master (General Section)

LFM1 Vendor master record purchasing organization data

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

MDLV Customizing MRP Area

MDMA MRP Area for Material

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

MTCOM Material Master Communication

The list of tables used for MB5B are

BKPF Accounting Document Header

BSIM Secondary Index, Documents for Material

EBEW Sales Order Stock Valuation

MAKT Material Descriptions

MARA General Material Data

MARD Storage Location Data for Material

MBEW Material Valuation

MCHA Batches

MCHB Batch Stocks

MKOL Special Stocks from Vendor

MKPF Header: Material Document

MSEG Document Segment: Material

MSKA Sales Order Stock

MSKU Special Stocks with Customer

MSLB Special Stocks with Vendor

MSPR Project Stock

QBEW Project Stock Valuation

now you can join all these tables & do a query.

You need to clearly specify your requiremnts, the output will be always based on that.

Thanks & regards

Kishore