Application Development 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: 

How to Export structure Table to Microsoft Excel from Tcode SE 11

Former Member
38,531

Hello anyone ,

How to Export ( Copy ) structure Table from Tcode SE11 to Microsoft Excel? Thank You.

Regards

Indra Budiman

1 ACCEPTED SOLUTION

Former Member
4,282

Hi Indra,

One way that I can think of is -

When you display the thable, go to the menu option <i>Utilities>Runtime Obejct>Display</i>. In the next screen that you get, choose to display the ALV Grid as an Excel Sheet and then just save it. If the Excel sheet options doesn't work, then display the ALV Grid as a list, then then choose the standard option <i>System>List>Save</i>.

Please rewards the answers if they have helped you. Also please visit your to acknowledge it.

regards,

anand mandalika.

7 REPLIES 7

Former Member
4,283

Hi Indra,

One way that I can think of is -

When you display the thable, go to the menu option <i>Utilities>Runtime Obejct>Display</i>. In the next screen that you get, choose to display the ALV Grid as an Excel Sheet and then just save it. If the Excel sheet options doesn't work, then display the ALV Grid as a list, then then choose the standard option <i>System>List>Save</i>.

Please rewards the answers if they have helped you. Also please visit your to acknowledge it.

regards,

anand mandalika.

0 Kudos
4,282

Thank you, was searching for the option to extract, it really helped.

Former Member
0 Kudos
4,282

Thx You Mr.Anand.

Regards

Indra

Former Member
4,282

You Don't

Instead go to SE15 > ABAP Dictionary > Fields > Table Fields, double-click

Enter desired table name, execute

You now have the Fields & Descriptions and if you want everything select the "Complete List" button
Then, download the list as usual System > List > Save > Local File, select Spreadsheet

Regards,

Rod

0 Kudos
4,282

Hi Rod,

I tried your approach using SE15. Though I selected few columns from selected table (eg: LFA1), when I download the file, all columns are selected.

Am I missing any step here?

Regards,

Ajay

0 Kudos
4,282

The selection functionality is for use within the SE15 transaction itself which is not the same purpose as finding some kind a workaround to get table structure to excel. The System > list capability is what it is and that is to take all information in an ABAP list and save it to a file in the desired format. We just remove any unnecessary data after the fact. It is better than nothing at all

Former Member
4,282

There is also another way to achieve that simply by exporting content of table DD03VV using SE16N.

Table DD03VV contains definition of each dictionary table and structure so using SE16N we choose table DD03VV and then in selection criteria we put name of table or structure in field TABNAME and press execute. In result we get list of all fields belonging to the provided table/structure and we can easily export it to Excel file.