topic Re: internal table in Application Development and Automation Discussions

internal table

Former Member — Thu, 12 Oct 2006 15:49:15 GMT

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

Re: internal table

Former Member — Thu, 12 Oct 2006 15:51:22 GMT

Hi,

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

Re: internal table

Former Member — Thu, 12 Oct 2006 15:51:42 GMT

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>

Re: internal table

Former Member — Thu, 12 Oct 2006 15:53:23 GMT

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.

Re: internal table

Former Member — Thu, 12 Oct 2006 15:54:50 GMT

if fields r differnt should i need to move the fields

individually.

thanks

kiran kuamr

Re: internal table

Former Member — Thu, 12 Oct 2006 15:56:23 GMT

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

Re: internal table

Former Member — Thu, 12 Oct 2006 15:56:53 GMT

Hi,

yes ,you should move individual field .

e.g. :

SCUSTOM-MANDT = '001'.

SCUSTOM-ID = '112133'.

INSERT INTO SCUSTOM CLIENT SPECIFIED VALUES SCUSTOM

Thanks.

Re: internal table

Former Member — Thu, 12 Oct 2006 15:57:17 GMT

hi phani can u give example.

Re: internal table

Former Member — Thu, 12 Oct 2006 16:01:08 GMT

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

Re: internal table

Former Member — Thu, 12 Oct 2006 16:04:35 GMT

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.