topic Re: Create a Database Table through ABAP Code in Application Development and Automation Discussions

Create a Database Table through ABAP Code

Former Member — Thu, 05 Mar 2009 13:09:18 GMT

Hello!

Is there any way to create a Database table or a database structure through ABAP code?

Thanks in advance, mastuerzos!

Re: Create a Database Table through ABAP Code

Former Member — Thu, 05 Mar 2009 13:12:35 GMT

HI Yashir,

Check this

hope it helps you

Thanks!

Re: Create a Database Table through ABAP Code

naveen_inuganti2 — Thu, 05 Mar 2009 13:12:49 GMT

Hi,

Good Question...,

No . As of my knowledge its not possible. But we can create internal table from transaction code SE11.

Thanks,

Naveen Inuganti.

Re: Create a Database Table through ABAP Code

Former Member — Thu, 05 Mar 2009 13:27:19 GMT

Hi,

Hope this can be done to simulate Table creation using BDC methods.

Create recording for Table creation in Se11,then program this in SE38.

Re: Create a Database Table through ABAP Code

Former Member — Mon, 23 Apr 2012 11:08:35 GMT

Hi,

Its is not possible from se38.

In order to create Table from se38 you have to use BDC concept, even I have done this....

Regards,

Rajesh Sadula.

Re: Create a Database Table through ABAP Code

Former Member — Mon, 23 Apr 2012 17:33:32 GMT

Hi,

What about FM DDIF_TABL_PUT?

by the way, all DDIC objects can be created with DDIF* fms...

Cheers,

Manu.

Re: Create a Database Table through ABAP Code

Former Member — Mon, 23 Apr 2012 17:43:40 GMT

Let's note:

1) the date of the OP

2) the OP.

Rob

Re: Create a Database Table through ABAP Code

Former Member — Mon, 23 Apr 2012 18:19:10 GMT

arff...sorry for that...haven't noticed, was just focused on the last reply...

Kr,

Manu.

Re: Create a Database Table through ABAP Code

Former Member — Mon, 23 Apr 2012 18:22:05 GMT

It happens

I was able to change a table using this FM, but not actually able to create one.

Rob

Re: Create a Database Table through ABAP Code

Former Member — Mon, 23 Apr 2012 19:27:02 GMT

ah? I thought I used it in the past... or perhaps it was DD_CREATE_TABLE... For sure one of them can be used to do this.

Manu

Re: Create a Database Table through ABAP Code

Former Member — Tue, 24 Apr 2012 05:46:38 GMT

Hi,

I have gone through some SDN links, and I found we can create table using FM

1) DDIF_TABL_PUT - Create New Transparent Table.

2) DDIF_TABL_ACTIVATE - To active the table.

While using DDIF_TABL_PUT

DATA:

lt_fields TYPE TABLE OF dd03p,

wa_field TYPE dd03p,

table_header TYPE dd02v,

techn_set TYPE dd09v.

table_header-tabname = p_tabnam.

table_header-ddtext = p_tabtxt.

table_header-ddlanguage = sy-langu.

table_header-tabclass = 'TRANSP'.

table_header-as4user = sy-uname.

table_header-contflag = 'A'.

table_header-mainflag = 'X'.

techn_set-tabname = p_tabnam.

techn_set-tabkat = 0.

techn_set-tabart = 'APPL1'.

techn_set-bufallow = 'X'.

techn_set-pufferung = 'X'.

wa_field-tabname = p_tabnam.

wa_field-ddlanguage = sy-langu.

wa_field-notnull = 'X'.

wa_field-keyflag = 'X'.

wa_field-fieldname = 'ID'.

wa_field-position = position.

wa_field-rollname = 'CHAR10'.

APPEND wa_field TO lt_fields.

CALL FUNCTION 'DDIF_TABL_PUT'

EXPORTING

name = 'Table Name'

dd02v_wa = table_header

dd09l_wa = techn_set

TABLES

dd03p_tab = lt_fields " Table fields

EXCEPTIONS

tabl_not_found = 1

name_inconsistent = 2

tabl_inconsistent = 3

put_failure = 4

put_refused = 5

OTHERS = 6.

IF sy-subrc = 0.

WRITE: /, 'Table Created'.

ELSE.

WRITE: /, 'Error occurred'.

ENDIF.

*Activating the Table

CALL FUNCTION 'DDIF_TABL_ACTIVATE'

EXPORTING

name = 'Table Name'

* IMPORTING

* RC =

EXCEPTIONS

not_found = 1

put_failure = 2

OTHERS = 3.

IF sy-subrc <> 0.

WRITE: /, 'Table could not be activated.'.

RETURN.

ELSE.

WRITE: /, 'Table has been activated.'.

ENDIF.

I believe this will solve your problem...

Regads,

Rajesh Sadula.

Re: Create a Database Table through ABAP Code

Sergiu — Mon, 12 Apr 2021 16:33:13 GMT

I imagine batch input or LSWM also could be a solution.