I want a report to find the available stock on a particular day .

[Former Member]

Hi Gurus,

Please help me in writing a program to know the stocks on a

particular day.

Thanks ,

Tausif

[former_member181962]

Why do you want to write your own report?

There is a standard Transaction already there for the same.

MMBE is the TCODE.

The important tables involved are:

MARD. (Stock n each storage location)

MKOP. (Stock at consignment)

MKOL. (Special Stock at Vendor)

Regards,

Ravi

[Former Member]

Hello,

Use the Tcode MMBE to know the Stock.

Vasanth

[Former Member]

Hi,

There's a standard report - transaction MB5B - run it with debugger.

Check : MMBE,MD04 and MB5B Transactions.

Reward Points if found helpfull..

Cheers,

Chandra Sekhar.

[Former Member]

I want to pull out the stocks on a particular for a whole year.

ist Jan

2nd Jan

etc..

None of the transaction code gives that kind of report

[former_member181962]

At any given point in time, all these tables and transaction codes will have only the CURRENT Stock(On the day you run those transactions). You cannot get what was the stock a couple of days back or for that matter, any date in the past.

Regards,

Ravi kanth Talagana

[Former Member]

also Tcode mb5b

[krishnendu_laha]

Hi Friend,

For getting stock of material, take from MARD table and use LABSTK field.

And for getting stock of batches, take from MCHB table and use CLABS field.

Remember stock always lies physically in storage location.

Hope it will solve the problem.

Regards

Krishnendu