How to programmatically create DB table (or alternatives)?

[Former Member]

Hi all,

I want/need to programmatically create a Z-table on the SAP database from within a report. The fields to be defined for this new table are unknown in advance, they can dynamically be set on a web dynpro user interface, therefore we need to create such a new table from within ABAP code. Is that possible at all, including activating it as well?

If there is absolutely no way of accomplishing that task do you see any suitable alternative? I assume it is possible somehow though, as SAP standard is doing that via SE11 as well...

Thanks in advance for your help!

Kind regards, Matthias

[pushkar_dhale]

Hi,

You may use BDC for SE11 (Table creation) Or native SQL to create table programmatically

Regards,

Pushkar Dhale.

[Former Member]

Hello Pushkar,

thanks for your reply.. I wasn't aware of the fact that SAP allows for such native SQL commands. When I create a table that way, do I need to activate it then via a SAP tool? If so, can I do so again from within my ABAP code?

Thanks!

[Former Member]

Hi,

Please have a look to FMs DDIF_*, such like DDIF_TABL_PUT  and DDIF_TABL_ACTIVATE...

Cheers,

Manu.

[Former Member]

thanks Manu, exactly what I was searching for