Career Corner Discussions
Join the conversation in the Career Corner group to ask career-related questions, find approaches to building skills, and seek career advancements.
cancel
Showing results for 
Search instead for 
Did you mean: 

downloading report output to excel file

Former Member
0 Kudos

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.

3 REPLIES 3

Former Member
0 Kudos

Hi,

Report is developed with traditional ALV or ALV OOPS?

Could you give some more details. please?

Regards

Ivan

Former Member
0 Kudos

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
Contributor
0 Kudos

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