How do extract metadata of all tables?

[Former Member]

Dear all

I need table structure(table name,field name, data type, length of the field) of all tables from SAP database. Can any one help me to extract metadata of all tables in sap database.

Thanks in advance

Thirumurugan

[former_member188883]

Hi Thiru,

Refer to ABAP code in the link http://learnmysap.com/sap-abab/470-sap-dictionary-table-information-how-to-download.html

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Actually i dont have access for SAP application. But i have access rights for SAP database.

Outr team going to migrate all sap tables from SAP database to mysql database with use of ETL tool. To migrate all SAP tables we need metadata information.

Can you tell me the metadata tables which is used to find mapping between SAP screens to and its tables  as well as to find the table structures?

[former_member188883]

Hi Thiru,

You may use the SQL select statement under the abap code and create a script which will loop and extract the data for you.

Regards,

Deepak Kori

[Former Member]

Currently we are extracting each table data using RFC via ETL tool. Can you provide me a example to implement SQL in the ABAP code.