Problem solve Get help with specific problems with your technologies, process and projects.

Downloading a table structure into .txt or .xls file

Sometimes we may need to download the structure of a SAP database table in .txt or .xls format with all details.

Sometimes we may need to download the structure of a SAP database table in .txt or .xls format with all the details...

including data element and domain details. Here's an easy way to make it happen.


For example, let's say we want to download the structure of BSEG table into .xls file so follow these steps.
Step 1 - Goto SE11 Screen.
Step 2 - Write the table name 'DD03L' into database table field and press display button.
Step 3 - Select Display Table contents from Utilities menu.
Step 4 - In selection screen you can give the table name you want to download in Tabname field.
Step 5 - If you want the details of all the fields then execute this transaction otherwise select the Settings->List Format->Choose fields to select the fields you want in display.
Step 6 - Execute this Transaction. It will give you all the details of all the fields in that table.
Step 7 - For Downloading these details, goto Edit->Download and follow the usual procedure for download.

This was last published in September 2002

Dig Deeper on SAP ABAP

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close