cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding Stock

Former Member
0 Kudos

Dear SAP Gurus

I want to know the stock of materials in my plant on Feb and March earlier date

Is there any way to get the stock

From which table i can get the stock

Can any body give idea and help me

I know MB5B

other than this any thing

or Table name

Please help very urgent

Rgds

Surya

Accepted Solutions (0)

Answers (5)

Answers (5)

kunal_ingale
Active Contributor
0 Kudos

hi

u can use

mc.9

mc.a

mc.1

mc.2

mc.5

reward if helpful

regards

kunal

former_member192897
Active Contributor
0 Kudos

Hi Suryaprakash,

Apart from MB5B, you can retrieve the same data using the below tables:

BKPF

BSIM

MAKT

MARA

MARD

MCHB

MCHA

MBEW

EBEW

QBEW

MKOL

MKPF

MSEG

MSKA

MSKU

MSLB

MSPR

RPGRI

T001

T001K

T001W

T001L

T134M

T156M

T156S

TCURM

ACCHD.

Reg,

Ashok

Former Member
0 Kudos

Hi Surya,

You could display your stock on Feb and March using MB5B, Fill Posting date between 1st Feb until 29th Feb and you will get beginning stock,stock movement(In/Out), and ending stock in Feb.

Or you can check table MCHBH for stock below from current period.

Regards

Gunawan

BijayBarik
Active Contributor
0 Kudos

Hi,

The tables are used for MB5B following and you can used ur require table and go for query report.

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

Regards,

Biju K

Former Member
0 Kudos

Hi;

Check in transaction MC.9 or table S031

reward if found useful.

Regards

Avinash