Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table for opening and closing stock

Former Member
0 Kudos

Dear gurus

Can you tell me which table is used to get the opening stock of a material.

regards

Saad

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hello

To get the opening stock of material you have calculated receipt and issue have look at MB5B report

you get idea the table are Mara, Mard, bsim, mbew, mkol, mcha, mkpk,mseg,mska, mksu,ebew you have work out to get the opening by debit and credit Indicator 'H' , 'S' . try it . you get .

Regards

Nilesh Gaikwad

9 REPLIES 9

Former Member
0 Kudos

Hello

To get the opening stock of material you have calculated receipt and issue have look at MB5B report

you get idea the table are Mara, Mard, bsim, mbew, mkol, mcha, mkpk,mseg,mska, mksu,ebew you have work out to get the opening by debit and credit Indicator 'H' , 'S' . try it . you get .

Regards

Nilesh Gaikwad

0 Kudos

Done everything

But not getting the correct value..

please guide me

0 Kudos

Hi

so where is the problem have you able to figure it out.

Regards

Nilesh

Edited by: Nilesh Gaikwad on Nov 1, 2009 4:21 PM

0 Kudos

the problem is that

im getting the value of Valuated stock

i want the opening stock of storage loc/batch stock.

0 Kudos

Hi

So you will get the stock storage location wise from mard and Mchb you will get the batch wise data.

regards

Nilesh

0 Kudos

then i have to link with the table MSEG rite?

0 Kudos

Hi

you have to consider this table mseg also table for opening and closing stock

reagrds

nilesh

0 Kudos

Thank you Nilesh Gaikwad for being so supportive..

Former Member
0 Kudos

posted twice

Edited by: Nilesh Gaikwad on Nov 1, 2009 4:25 PM