topic Re: inserting into a database table using field symbols? in Application Development and Automation Discussions

inserting into a database table using field symbols?

Former Member — Fri, 19 Oct 2007 10:40:37 GMT

Hi.

If I have a database table that I do not know the name at design-time, how do i insert records into that database table at run-time?

****************************************************************************************

Do i use field-symbols, as follow:

FIELD-SYMBOLS <TABLE_NAME> TYPE TABLE.

INSERT <TABLE_NAME> FROM ITAB.

Re: inserting into a database table using field symbols?

h_senden2 — Fri, 19 Oct 2007 10:45:53 GMT

I dont think this will work.

You have to put the DB table's name into the fieldsymbol. Maybe you have to try the next code.

data: l_dbname(30) type c value 'VBAK'.

field-symbols: <fs>.

assign (l_dbname) to <fs>.

check sy-subrc eq 0.

insert <fs> from itab.

regards,

hans

Re: inserting into a database table using field symbols?

Former Member — Fri, 19 Oct 2007 10:56:02 GMT

Message was edited by:

Kian Keong

Re: inserting into a database table using field symbols?

Former Member — Fri, 19 Oct 2007 10:56:40 GMT

Hi, thanks for the prompt reply.

I did something similar to your codes, but it got a syntax error:

************************************************************************

FIELD-SYMBOLS: <DTAB>.

DATA: DTABNAME(20) TYPE C VALUE 'ZTABLE'.

"ZTABLE = SAP Database Table Name

ASSIGN (DTABNAME) TO <DTAB>.

INSERT <TRYOUT1> FROM TABLE UPITAB.

"ITAB = Internal Table with same type as ZTABLE

************************************************************************

I got the error message: Field "FROM" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement.

Re: inserting into a database table using field symbols?

h_senden2 — Fri, 19 Oct 2007 11:00:59 GMT

strange !

according to the F1 for the INSERT statement you can use

INSERT dbtab FROM TABLE itab. or

INSERT (dbtabname) FROM TABLE itab.

So the 2nd solution can also be used in stead of field-symbol.

regards

Hans

Re: inserting into a database table using field symbols?

Former Member — Fri, 19 Oct 2007 11:09:35 GMT

while declaring field symbol try :

FIELD-SYMBOLS <TABLE_NAME> TYPE ANY.

Re: inserting into a database table using field symbols?

Former Member — Fri, 19 Oct 2007 11:09:37 GMT

Hi Hans, thanks a million for the last post.

It solved my problem! All I need to do is to change <DTAB> to (DTABNAME) in the INSERT statement.

i.e. INSERT <DTAB> FROM TABLE UPITAB. ==> WRONG

INSERT (DTABNAME) FROM TABLE UPITAB. ==> CORRECT.

Thanks for your help, points given

######################################################

I did something similar to your codes, but it got a syntax error:

************************************************************************

FIELD-SYMBOLS: <DTAB>.

DATA: DTABNAME(20) TYPE C VALUE 'ZTABLE'.

"ZTABLE = SAP Database Table Name

ASSIGN (DTABNAME) TO <DTAB>.

INSERT <DTAB> FROM TABLE UPITAB.

"ITAB = Internal Table with same type as ZTABLE

************************************************************************

I got the error message: Field "FROM" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement.

Re: inserting into a database table using field symbols?

h_senden2 — Fri, 19 Oct 2007 11:13:00 GMT

you're welcome