topic Re: How to Export structure Table to Microsoft Excel from Tcode SE 11 in Application Development and Automation Discussions

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

Former Member — Mon, 16 May 2005 03:55:42 GMT

Hello anyone ,

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

Regards

Indra Budiman

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

Former Member — Mon, 16 May 2005 04:11:38 GMT

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.

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

Former Member — Mon, 16 May 2005 05:02:26 GMT

Thx You Mr.Anand.

Regards

Indra

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

Former Member — Thu, 02 Oct 2014 22:03:49 GMT

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

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

Former Member — Fri, 03 Oct 2014 13:21:01 GMT

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

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

Former Member — Fri, 03 Oct 2014 15:49:05 GMT

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

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

Former Member — Wed, 10 Feb 2016 07:45:17 GMT

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.

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

ganeshdnov — Mon, 05 Jul 2021 16:59:02 GMT

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