topic Re: how to create a database table at runtime in Application Development and Automation Discussions

how to create a database table at runtime

Former Member — Tue, 28 Nov 2006 06:41:45 GMT

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

Re: how to create a database table at runtime

Former Member — Tue, 28 Nov 2006 06:44:18 GMT

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

Re: how to create a database table at runtime

Former Member — Tue, 28 Nov 2006 06:48:35 GMT

hi,

please check program RSDCDDXT

Re: how to create a database table at runtime

Former Member — Tue, 28 Nov 2006 06:55:32 GMT

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

Regards

Lucky

Re: how to create a database table at runtime

Former Member — Tue, 28 Nov 2006 07:00:04 GMT

hi,

You can refer the logic in the standard program.

like using FM DD_CREATE_TABLE

Re: how to create a database table at runtime

Former Member — Tue, 28 Nov 2006 07:07:13 GMT

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

Regards

Lucky

Re: how to create a database table at runtime

Former Member — Tue, 28 Nov 2006 08:41:33 GMT

check the following link

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

Re: how to create a database table at runtime

Former Member — Tue, 28 Nov 2006 08:46:07 GMT

i already mention not for internal tables only database tables

regards

lucky