downloading report output to excel file

[Former Member]

hi gurus,
               i am developing a stock report  and problem is when the output of the report should be downloaded to the excel sheet i.e, when we press back  at the output screen of the report.  help me pls..

and how to caluclate current stock....   fileds used are  safety stock and units of measurement.

regards,
ajit.

[Former Member]

Hi,

Report is developed with traditional ALV or ALV OOPS?

Could you give some more details. please?

Regards

Ivan

[Former Member]

Dear Ajit ,

As Ivan told you need to give some more details regarding your requirement ,

Any how you can can download the data into Excel by using GUI_DOWNLOAD in Presentation server and OPEN DATASET , TRANSFER and CLOSE DATASET in Application Server .

You can calculate the Current stock by using table MCHB with field CLABS .

Thanks

Mallikarjun

[bastinvinoth]

Hi Ajit,

As per my understanding, when you press on the back button excel file has to trigger right

in output list alv. check with below method

END-OF-SELECTION.
PERFORM EXCEL. " call your custom code here after displaying ALV report.

for stock tables check the below link.
http://wiki.sdn.sap.com/wiki/display/ERPSCM/Stock+Tables+and+Stock+Types

Regards,

Bastin.G