Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

create database table/ transparent table dynamically

Former Member
0 Likes
960

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.

1 ACCEPTED SOLUTION
Read only

jayanthi_jayaraman
Active Contributor
0 Likes
757

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).

5 REPLIES 5
Read only

Former Member
0 Likes
757

Hi

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

Max

Read only

0 Likes
757

Hi max,

Tried debugging the transaction.

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

regards,

Naveenan.

Read only

0 Likes
757

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

Read only

0 Likes
757

Hi

Try to chekc fm like DD_TABL_CREATE or DD_TABL_*

Max

Read only

jayanthi_jayaraman
Active Contributor
0 Likes
758

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).