topic Re: EXEC SQL - GET DATABASE STRUCTURE - RECREATE IN SAP in Application Development and Automation Discussions

EXEC SQL - GET DATABASE STRUCTURE - RECREATE IN SAP

Former Member — Fri, 24 Nov 2006 10:58:29 GMT

Our system is connected to PS.

II'd like to write a program that does the following

get the structure of the database
create the structure in SAP
SELECT THE DATA OF THE TABLE

This would be done in order to maintain the structure manually

The problem is to get the structure from external database (exec sql)

Thanks for your help!

Regards,

Re: EXEC SQL - GET DATABASE STRUCTURE - RECREATE IN SAP

Former Member — Fri, 24 Nov 2006 12:02:53 GMT

You will have to write a stored procedure in Oracle or SQL-Server in which you will fetch the structure .Now using native SQL commands (EXEC SQL) you can call the stored procedure in ABAP by passing the parameters if only.Refer the help on EXEC SQL for calling stored procedures.

Re: EXEC SQL - GET DATABASE STRUCTURE - RECREATE IN SAP

Former Member — Fri, 24 Nov 2006 12:34:19 GMT

Hi stephan,

1. In oracle , there is one standard view

eg. V_ALL_TAB_FIELDS

in which we pass the table name,

and it returns, the records,

for the fieldnames, field type, its length, its sequence number etc.

2. Similarly u may discover for PS also.

regards,

amit m.