downloading Tables from SE11 or SE16

[Former Member]

Hello all,

please can someone advice whether i can easily download table details from SE11 or SE16?

i NEED EACH TABLES FIELDS, RELATIONSHIPS ETC.... is it possible?

if i cannot, can I view the relationship of a TABLE alongside the reference data?

[gilmarluiz_puntel · Accepted solution]

Koserk:

Try the view DD03N in the SE16 transaction, and inform the tables that you need.

Or, try to navigate through the SD11 and SE80 transactions.

I hope this helps you.

Regards.

[gilmarluiz_puntel]

Koserk:

Try the view DD03L

[sarthak_mohantysd]

Hello,

please can someone advice whether i can easily download table details from SE11 or SE16?
i NEED EACH TABLES FIELDS, RELATIONSHIPS ETC.... is it possible?
if i cannot, can I view the relationship of a TABLE alongside the reference data?

Please check out the below option for your question raised.

1. You can use export command to export these data's directly from DB2.

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r000830...

1. You can use SQVI option to export all the field of a table.

Regards,

Sarthak

PS: If you query is resolved then please ensure to close the thread.

[former_member183879]

Hi,

You cannot download the field details of a table directly. Even if you copy and paste, you really cannot make any sense out of 1000s of fields you are going to have in a module.

SO you can use the whereused list to find out the relationships