how to create a database table at runtime

[Former Member]

Hai all,

i have a table control having the field names as rows, when i select the rows (not all) i want to create a database table( not internal table ) in the background and for that table table maintainence generator also (in abap don;t tell in OOPS Concepts ).

please help on the above issue it's very urgent.

Regards

Lucky

[Former Member]

Hai all,

i have a table control having the field names as rows, when i select the rows (not all) i want to create a database table( not internal table ) in the background and for that table table maintainence generator also (in abap don;t tell in OOPS Concepts ).

please help on the above issue it's very urgent.

Regards

Lucky

[Former Member]

You cn use the <b>FM DD_CREATE_TABLE</b> to achieve the same.

Here it is with example code

Or using Native SQL,

Regards

Kathirvel

[Former Member]

in this link they r using the native SQL Statements, but we r using the Open SQL Statements.

Regards

Lucky

[Former Member]

hi,

please check program RSDCDDXT

[Former Member]

while i am running the program RSDCDDXT in 5.0 version it is going to dump.

Regards

Lucky

[Former Member]

hi,

You can refer the logic in the standard program.

like using FM DD_CREATE_TABLE

[Former Member]

check the following link

/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap

[Former Member]

i already mention not for internal tables only database tables

regards

lucky