topic Re: create database table/ transparent table dynamically in Application Development and Automation Discussions

create database table/ transparent table dynamically

Former Member — Tue, 03 Jul 2007 08:48:16 GMT

Hi,

Is it possible to create database table/ transparent table dynamically using abap code or any other means using program? if so how?

regards,

Naveenan.

Re: create database table/ transparent table dynamically

Former Member — Tue, 03 Jul 2007 08:53:53 GMT

I think so, try to check the trx V/03, it's the trx to create condition table for pricing dynamically.

Max

Re: create database table/ transparent table dynamically

jayanthi_jayaraman — Tue, 03 Jul 2007 08:55:47 GMT

Hi,

As far I know, we can create table dynamically using native SQL.

exec sql.

create table stu_det ( regno char(10) primary key,

name char(20) not null,

total number(3) )

endexec.

But this table will not be available in ABAP(Data Dictionary).

Re: create database table/ transparent table dynamically

Former Member — Fri, 06 Jul 2007 12:03:39 GMT

Hi max,

Tried debugging the transaction.

Is there any FM or any command that can do the same...

regards,

Naveenan.

Re: create database table/ transparent table dynamically

Former Member — Fri, 06 Jul 2007 12:09:16 GMT

Hi,

Yes you can...But it would a be a long time to work...You need to fill every table with all the fields and technical details...Look for these tables...

DD03P,DD02V,DD02L,DD09L

also, this FM DDIF_TABL_PUT,RPY_DOMAIN_INSERT,

RPY_DATAELEMENT_INSERT

<b>Reward points</b>

Regards

Re: create database table/ transparent table dynamically

Former Member — Fri, 06 Jul 2007 13:02:56 GMT

Try to chekc fm like DD_TABL_CREATE or DD_TABL_*

Max