topic Re: Internal table error in Application Development and Automation Discussions

Internal table error

Former Member — Fri, 20 Jul 2007 16:08:40 GMT

Hi Friends...

I am updating the database from Internal table with this syntax.

data: itab type standard table of ztab with header line.

loop at itab.

update ztab from itab.

endloop.

it gives me the error "the work area Itab is not long enough. "

i have used explicit work area as well here then i found the same erro as well. please tell me what is the problem here... any help appreciated.

Regards.

Re: Internal table error

Former Member — Fri, 20 Jul 2007 16:20:39 GMT

Amee,

Use:

UPDATE ZTAB FROM TABLE itab.

No loop is required then as well.

Re: Internal table error

Former Member — Fri, 20 Jul 2007 16:27:54 GMT

HI,

this works fine.. check with ur ztab is it exist or not and also ensure that you declare this

tables : ztab.

data: itab type standard table of ztab with header line.

loop at itab.

update ztab from itab.

endloop.

update ztab from table itab[].

thanks

Mahesh

Re: Internal table error

Former Member — Sat, 21 Jul 2007 02:52:45 GMT

Hello Amee,

Your error message is due to that:

Your internal table structure is not same as the database table.

The syntaxt you are using, the internal table should have exact structure as the database table.

TABLES: ztab

DATA: itab type table of ztab initial size 0.

1. update ztab from table itab.

This will update whole line of your ZTAB by comparing the key fields from itab.

If you want to update only one or two fields, you can use SET along with UPDATE,

please refer to the doc.

Regards,

A.Singh

Re: Internal table error

Former Member — Sat, 21 Jul 2007 04:21:14 GMT

Hi,

First make sure that sturcutre of internal table and ztab is same.

Instead of modifying table in loop.

Modify internal table itself and then make mass update to customized table.

Check below,

LOOP AT itab.

MODIFY itab INDEX sy-index.

ENDLOOP.

MODIFY ztab FROM TABLE itab.

Regards,

Amit R.

Re: Internal table error

Manoj_Mahajan78 — Sun, 19 Aug 2007 10:41:44 GMT

I hope error would have solved...

Regds