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

data mapping from SAP to excel

Former Member

‎2007 Oct 16 11:46 AM

0 Likes
439

I have executed one report which is giving one basic list. As per the maximum line size all the data are splitted in separate pages.Whenever we download it separate xcel sheet it is coming in the same manner i.e in splitted manner. I just want to know if it is possible to accumulate the splitted data from SAP into Xcel in a single horizantal style and if possible please explain how can we do that.

I have executed one report which is giving one basic list. As per the maximum line size all the data are splitted in separate pages.Whenever we download it separate xcel sheet it is coming in the same manner i.e in splitted manner. I just want to know if it is possible to accumulate the splitted data from SAP into Xcel in a single horizantal style and if possible please explain how can we do that.

Reply
1 REPLY 1
Read only

Former Member

‎2007 Oct 16 11:51 AM

0 Likes
405

Hi Sam,

Good!

Its possbile. Try to insert a puch button in the basic list. for that particular fucntion code usre the FM

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = FILENAME

WRITE_FIELD_SEPARATOR = 'X'

append = 'X'

TABLES

DATA_TAB = jtab

Thanks,

Sunil