Funktion for "Create Table" Statement

[Former Member]

Dear all,

I am looking for a function to create a "create table"-SQL statement from an existing SAP Dictionary table. Does anybod y know a abap function to do this. With the SQL Statement I want to create the table in an external Database.

Kind Regards

Roman Becker

[Former Member]

Hi Roman,

Try the Function MOdules,

DB_CREATE_TABLE and DB_CREATE_TABLE_S.

Regards,

Ravi

[Former Member]

Hi please enter db_create* in se37 and pick the desired function needed.

here are few Function modules for u.

DB_CREATE_TABLE

DB_CREATE_TABLE_AS_SELECT

DB_CREATE_TABLE_AS_SELECT_S

DB_CREATE_TABLE_S As DB_CREATE_TABLE, also returns the generated statements

Satish