Capturing Current stock from MB5B

[Former Member]

Dear All,

Greetings.

I am developing a Classical report in which i want to perform some calculation upon the Current stock of material at any Depo.

The same is showing in the standard report through the transaction MB5B by running it for Storage Loc/ batch Stock option..

Eg.:

Plant 101 B DEPOT

Material 1001-00002

Description CEMENT

Stock on 17.01.2010 *1.500 TO

Total Receipts 310.000 TO

Total Issues 310.250- TO

Stock on 23.01.2010 1.250 TO

Can you please tell me how can I get the above highlighted values by direct calling the TCode MB5B & then perform my calculation.

hope for your early response.

Thanks in advance.

Regards

Ankur Gupta

[Former Member]

NEW-PAGE PRINT ON PARAMETERS print_parameters

NO DIALOG.

SELECT *

FROM sflight

INTO sflight_wa

WHERE carrid = spfli_wa-carrid AND

connid = spfli_wa-connid.

WRITE: / sflight_wa-carrid, sflight_wa-connid,

sflight_wa-fldate ...

ENDSELECT.

NEW-PAGE PRINT OFF.

you will get the output in spool

pick the spool number and get those values into internal table

In the internal table read 5 to 9 lines you will get the values

this is a long procedure

[Former Member]

NEW-PAGE PRINT ON PARAMETERS print_parameters

NO DIALOG.

SELECT *

FROM sflight

INTO sflight_wa

WHERE carrid = spfli_wa-carrid AND

connid = spfli_wa-connid.

WRITE: / sflight_wa-carrid, sflight_wa-connid,

sflight_wa-fldate ...

ENDSELECT.

NEW-PAGE PRINT OFF.

you will get the output in spool

pick the spool number and get those values into internal table

In the internal table read 5 to 9 lines you will get the values

this is a long procedure