internal table

[Former Member]

hi to all,

help me in this issue,

i am having internal table eq itab_ins and i want to move

all this data to database table.zins is the new table created.i want place all these internal table values into

this table.

i am using update zins from table itab_ins. but it is giving it is not uniconvertable.

thanks in advance

kiran kumar

[Former Member]

Hi,

Please see that the internal table & the Z-table have the same structure, if you want to use that statement.

[Former Member]

hi

use either INSERT zins from table itab_ins

or MODIFY zins from table itab_ins.

<b>note

itab_ins must be the same strucuture as zins.</b>

[Former Member]

Hi,

UPDATE dbtab FROM TABLE itab .This statement should work fine.

Just check field sequence in internal table & custom table is same.

Thanks.

Mark points if helpful.

[Former Member]

hi

if fields r differnt should i need to move the fields

individually.

thanks

kiran kuamr

[Former Member]

Yes. If the fields are diff, you need to move it individually & use "transporting" statement with Modify table.

[Former Member]

Hi,

yes ,you should move individual field .

e.g. :

SCUSTOM-MANDT = '001'.

SCUSTOM-ID = '112133'.

INSERT INTO SCUSTOM CLIENT SPECIFIED VALUES SCUSTOM

Thanks.

[Former Member]

hi phani can u give example.

[Former Member]

Hi,

I would say, move the values to an internal table with similar structure as Z-table & then use <b>"MODIFY dbtab FROM TABLE itab"</b> .

By this, it will Mass modify: Inserts new lines or updates existing linesof a database table.

[Former Member]

Hi

itab_ins type standard table of zins.

wa_itab type zins.

itab_ins already has data

and if you want to add more data

wa_itab-field = <value>.

MODIFY itab_ins from wa_itab

transporting field.

Then please update your database table for itab_ins.

UPDATE zins from itab_ins