topic Creating database tables dynamically in Application Development and Automation Discussions

Creating database tables dynamically

Former Member — Tue, 12 Jun 2012 09:03:17 GMT

Hi All,

I was wondering if there is a way to create database tables through BAPI or FM's. More on the similar ground on proxy generated structures,they are created dynamically. Can we in the similar way create database tables dynamically through code?

Re: Creating database tables dynamically

Former Member — Tue, 12 Jun 2012 09:10:19 GMT

Hi Amit

I must admit I've never tried anything like this before, but I guess you could create an RFC enabled FM and do a BDC recording to achieve this...I take it you have taken all the risks involved into account.

As far as I know I don't think there is a standard FM to create DB tables.

Hope this Helps

Regards

Vic

Re: Creating database tables dynamically

Former Member — Tue, 12 Jun 2012 09:13:04 GMT

You could take a look at FM DD_CREATE_TABLE.

Please check on the same here.

http://scn.sap.com/thread/261676

Also you can use Native SQL to create table, but this will not be available in Data dictionary.

Thanks,

Shambu

Re: Creating database tables dynamically

RaymondGiuseppi — Tue, 12 Jun 2012 09:14:06 GMT

Perform some search at scn on DD_CREATE_TABLE or DDIF_TABL_PUT / DDIF_TABL_ACTIVATE.

(But first ask the question to the managers of the database.)

Also those are internal not released FM, the "official" way to table creation is transaction SE11 (Note 618242 - Creating / changing database table in ABAP Dictionary)

Regards,

Raymond

Re: Creating database tables dynamically

Former Member — Tue, 12 Jun 2012 09:15:36 GMT

Search in SCN forums you will get it

Re: Creating database tables dynamically

ThomasZloch — Tue, 12 Jun 2012 09:17:07 GMT

SAPLink uses DDIF_TABL_PUT (internal use only, no surprise) to create DB Tables. However the new table would still need to be assigned to a package other than $TMP, possibly via TR_TADIR_INTERFACE, activated and inserted into a transport request..

Thomas

Re: Creating database tables dynamically

Former Member — Tue, 12 Jun 2012 09:23:40 GMT

We are just trying to automate a process of creating tables,rather automating of all the data dictionary objects. We started with tables,seems lot of trouble involved(though will give it a try),what else of the data dictionary part can be controlled via code?