topic Re: insert statement in Application Development and Automation Discussions

insert statement

Former Member — Fri, 02 May 2008 15:00:56 GMT

loop at it_tel into wa_tel.
insert into adr2 values wa_tel .
clear wa_tel.
 endloop.

for the above code i get the error as

"work area WA_TEL is not long enough. long enough"

Plz suggest what could have gone wrong.

if I use it_tel in the insert stmt.....even then i am getting same error as not long enough.

Thanks

Former Member — Fri, 02 May 2008 15:04:37 GMT

hi in your code

wa_tel should be same type of adr2.

make it_tel and wa_tel of type adr2 and use corresponding fields in select query.

reward if useful.

Former Member — Fri, 02 May 2008 15:06:33 GMT

First things first. Inserting records in to a standard SAP table can be dangerous.

The structure of the work area must be exactly the same as your table being updated.

Regards,

Ravi Kanth talagana

Former Member — Fri, 02 May 2008 15:20:20 GMT

Hi Alchemi,

According to your requirement check for any BAPIs or FMs which suits ur requirement

check the where-used-list of table ADR2 and checkout if any exists

Former Member — Fri, 02 May 2008 15:31:03 GMT

hi,

delcare your workarea as


data : wa_tel like it_tel.

Regards,

Santosh