Need help on developing a report

[Former Member]

Hey Experts,

Any one has done report on opening stock.

The report should display opening stock, issues, receipts and closing stock for a material.

Any inputs ASAP would be highly appreciated.

Please help.

Regards

Shankar

[Former Member]

Take a look at t-code MD04. Sounds very similar to your needs...

[Former Member]

Hey,

Thanks for your input. But i want to develop a custom development. Please help.

regards,

Shankar

[Former Member]

Not sure why you would want to re-code what SAP already provides...

But then I would suggest that you use MD04 as a model/example of tables, business logic, etc.

[Former Member]

I don't think this forum will be able to give you the whole program based on your broad description of the requirement. You should take a look at what John suggested and see how it is coded and what tables it is accessing etc and then customize it to your requirement. The tables you typically deal with when it comes to inventory are MARD, MARDH, MKPF, MSEG.

[Former Member]

Hi Shankaran,

Please find the FM below that drives MD04 as well as MS05. For MD04 you need not pass any 'plscn', planning scenario. Please let me know if you need any further help. The table 'e_mt61d'is a little tricky, go through all the fileds and their respective contents before you make your first conclusion.

call function 'MD_STOCK_REQUIREMENTS_LIST_API'

EXPORTING

plscn = p_plscn

matnr = p_matnr

werks = p_werks

IMPORTING

e_mt61d = l_mt61d

TABLES

mdpsx = w_mdps

EXCEPTIONS

material_plant_not_found = 1

plant_not_found = 2

others = 3.

Thanks,

John