topic How to programmatically create DB table (or alternatives)? in Application Development and Automation Discussions

How to programmatically create DB table (or alternatives)?

Former Member — Wed, 03 Oct 2012 14:43:38 GMT

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

Re: How to programmatically create DB table (or alternatives)?

pushkar_dhale — Wed, 03 Oct 2012 17:40:28 GMT

Hi,

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

Regards,

Pushkar Dhale.

Re: How to programmatically create DB table (or alternatives)?

Former Member — Fri, 05 Oct 2012 07:24:16 GMT

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!

Re: How to programmatically create DB table (or alternatives)?

Former Member — Fri, 05 Oct 2012 07:47:31 GMT

Hi,

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

Cheers,

Manu.

Re: How to programmatically create DB table (or alternatives)?

Former Member — Fri, 05 Oct 2012 09:56:38 GMT

thanks Manu, exactly what I was searching for