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

[Former Member]

Hello anyone ,

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

Regards

Indra Budiman

[Former Member]

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.

[ganeshdnov]

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

[Former Member]

Thx You Mr.Anand.

Regards

Indra

[Former Member]

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

[Former Member]

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

[Former Member]

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]

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.