How to get the stock

[Former Member]

hi,

How to get the stock corresponding to particular material, if movement type is 101 and 102 .

plz reply........

[Former Member]

Hi

Run trx MMBE, but if you want to see the stock generated by 101 and 102 only, I believe you need to do a select on MSEG table.

Max

[Former Member]

but here 101 corresponds to sales receive and 102 corrsponds to sales return.

[Former Member]

Hi

Yes, but the system creates a material document for both sales recieve and return.

So u need to check MSEG table.

Max

[Former Member]

But here im using EKBE table.. whether hve to use menge of the same table for this. plz tell how to calculate stock using ekbe.

[Former Member]

Hi

EKBE is linked to purchase order only, so here you can find all 101 and 102 generated for a PO, but the stock can be filled by several way, if you check only EKBE you'll have a partial count.

I think it's better to read MSEG table, here u'll be sure to read all 101 amd 102.

Max

[mohammed_moqeeth]

Hi,

You can get the stock based on material & movement type from MSEG table joining MARD table.

Reward points if you feel useful.

Cheers !

moqeeth.

[Former Member]

But i hve to calculate stock using EKBE table.