topic Re: Need help on developing a report in Application Development and Automation Discussions

Need help on developing a report

Former Member — Wed, 28 Jun 2006 14:09:07 GMT

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

Re: Need help on developing a report

Former Member — Wed, 28 Jun 2006 14:19:06 GMT

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

Re: Need help on developing a report

Former Member — Wed, 28 Jun 2006 14:36:15 GMT

Hey,

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

regards,

Shankar

Re: Need help on developing a report

Former Member — Wed, 28 Jun 2006 14:44:50 GMT

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.

Re: Need help on developing a report

Former Member — Wed, 28 Jun 2006 15:30:19 GMT

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.

Re: Need help on developing a report

Former Member — Wed, 28 Jun 2006 15:52:46 GMT

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