Exec SQL for database table creation

[Former Member]

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]

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]

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]

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

[Former Member]

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?