Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

intercompany report

Former Member

‎2008 Jun 23 10:03 AM

0 Likes
776

Hi everyone

i have an intercompany report. according to my requirement i have a selection screen for selecting the period.

but there are some 145 different records.my consult. asked me to hard code the code.

i felt i can upload the report and use it to disply rather than doing hard coding.

so can anyone tel me if there is a sample code to upload a excel file and display the same as a report.

please reply at the earliest.

will reward with full points.

Hi everyone

i have an intercompany report. according to my requirement i have a selection screen for selecting the period.

but there are some 145 different records.my consult. asked me to hard code the code.

i felt i can upload the report and use it to disply rather than doing hard coding.

so can anyone tel me if there is a sample code to upload a excel file and display the same as a report.

please reply at the earliest.

will reward with full points.

Reply
5 REPLIES 5
Read only

GauthamV
Active Contributor

‎2008 Jun 23 10:06 AM

0 Likes
747

hi,

u can upload a file to application server using CG3Z transaction.

later u can check it in AL11 transaction.

Read only

Former Member

‎2008 Jun 23 10:07 AM

0 Likes
747

Hi,

Use the function module ALSM_EXCEL_TO_INTERNAL_TABLE to get the data from the Presentataion Server Excel file data to the internal table. Then use this internal table to display the data in the report using List or ALV display.

Edited by: Ravi Kumar on Jun 23, 2008 11:08 AM

Read only

Former Member
In response to Former Member

‎2008 Jun 23 10:14 AM

0 Likes
747

hi

i have field in excel sheet which dont have corresponding fields in R/3. now how should i upload this data..

Read only

Former Member

‎2008 Jun 23 10:08 AM

0 Likes
747

Hi,

Use GUI_UPLOAD to upload the data. then loop the internal table for furtehr processing.

regards,

madhu

Read only

Former Member

‎2008 Jun 23 10:12 AM

0 Likes
747

Hi,

Go through this links:

http://www.sapdev.co.uk/file/file_upexcel.htm

http://www.saptechnical.com/Tips/ABAP/UploadExcel/Prg.htm

Regards

Adil