Creating database tables dynamically

[Former Member]

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?

[Former Member]

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

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

Search in SCN forums you will get it

[ThomasZloch]

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

[Former Member]

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?