topic Re: Exec SQL for database table creation in Application Development and Automation Discussions

Exec SQL for database table creation

Former Member — Mon, 09 Feb 2009 17:33:56 GMT

Hi guys,

I need to develop a script to create database tables automatically.

Is that possible? And how to?

I thought in:

EXEC SQL.

CREATE database table XPTO ("MANDT" "FIELD1");

ENDEXEC.

The table was created, but when i enter in tcode SE11 i am not able to see it...

Can you help me?

Best regards,

Luí

christian_wohlfahrt — Mon, 09 Feb 2009 17:53:45 GMT

Hi Luís,

with native SQL you handle the DB directly - so naturally the SAP-part will be missing (no SE11 entry).

If you like to have SE11-tables, then you should go for SE11-call-transaction-coding.

BR,

Christian

Former Member — Mon, 09 Feb 2009 17:58:05 GMT

Hi,

With native sql, there is no command to create a db table... or there is?

Anyway, i need to see the tables in SE11...

You write "SE11-call-transaction-coding".

Could you explain with more detail what do you mean with that?

Former Member — Mon, 09 Feb 2009 18:02:10 GMT

Have a look at FM DD_CREATE_TABLE to see if does what you want.

Former Member — Fri, 13 Feb 2009 10:16:48 GMT

Hi,

With that functions, the database table is created in the database but i'm not able to see it in SE11...

I don't like batchinput, but i think that is the better way...

Other ideas?