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
Showing results for 
Search instead for 
Did you mean: 
Read only

down loading data in to Excel with field description

Former Member
0 Likes
876

hi,

i want to down load the data from data base with field descriptions(total fields are 23) in to Excel sheet,

Regards

Suresh.D

hi,

i want to down load the data from data base with field descriptions(total fields are 23) in to Excel sheet,

Regards

Suresh.D

5 REPLIES 5
Read only

Former Member
0 Likes
814

goto se11, press CTRL-Y and make a border around the field description.

when done Press CTRL-C.

Now goto Excel, and press CTRL-V.

this works for field description, not for DATA.

Message was edited by:

Florian Kemmer

Read only

0 Likes
814

hello,

when i excute the program then data download into Excel sheet with field descriptions(not manually)

Regards

Suresh.D

Read only

Former Member
0 Likes
814

Hi Suresh

With SE16 ... ?

Erwan

Read only

Former Member
0 Likes
814

Hi Suresh,

You can use the function module GET_COMPONENTS_LIST to get the descriptions of the fields in the internal table and then use them to fill the first line of the internal table with the data that is to be downloaded.

Regards,

Ravi

Read only

Former Member
0 Likes
814

Goto TC SE16 enter your table name. press Enter

Check your settings as below:

Settings -> User Parameters -> Keyword (<b>Field Lable</b>)

Execute.

and download the content as :

System -> List -> Save -> Spreadsheet -> Enter your file path and Name