topic Re: hi. inserting data into a table from internal table in Application Development and Automation Discussions

hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:10:36 GMT

Hi,

i am trying to mass update to the database table

from the internal table.

it is giving an error that the internal table is not long enough..

can anyone help.

ADVance Thanks & Regards

Guhapriyan Subrahmanyam

Re: hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:18:34 GMT

Hi,

Check whether the internal table is been declared as that of the database table,

Hope this helps,

Rgds,

Re: hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:25:28 GMT

Hi Subrahmanyam ,

Assign the field symbol to internal table and then update the table .

Ex:

ASSIGN itab TO <F>. 
UPDATE dbtab FROM TABLE <F>.

<i>Reward Points If It Helps YOU.</i>

Regards,

Raghav

Re: hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:26:01 GMT

hi.

thank you very much

it is declared same as the database table

but the table has an appended structure

i dont know how to insert data in this table.

thanks & regards

Guhapriyan subrahmannyam

Re: hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:28:45 GMT

Hi,

Probably you have missed out some fields while declaring your itab.

Check it.

<b>

but the table has an appended structure

i dont know how to insert data in this table</b>.

For this you just insert those fields which are in appending structure to your itab then it should work.

Hope this helps

Reagrds

Amit

Message was edited by: Amit Kumar

Re: hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:29:11 GMT

hi can you give the code

how you are doing..insert

regards

vijay..

Re: hi. inserting data into a table from internal table

athavanraja — Mon, 05 Dec 2005 11:32:01 GMT

if your itab is same structure as the dbtable, youcan simply use

modify <db table> from table <itab> .

Regards

Raja

Re: hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:38:59 GMT

modify ZGLSTPM_DEPLSCHD FROM TABLE i_in_data.

if sy-subrc <> 0.

Error in inserting data to table ZGLSTPM_DEPLSCHD

Message i137.

endif.

Re: hi. inserting data into a table from internal table

abdul_hakim — Mon, 05 Dec 2005 11:43:24 GMT

Hi,

Define the line type of the internal table similar to your database table.

For eg.

DATA itab LIKE TABLE OF mara.

REgards,

Abdul

Re: hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:45:15 GMT

are you using all the fields..

regards

vijay

Re: hi. inserting data into a table from internal table

athavanraja — Mon, 05 Dec 2005 11:46:16 GMT

can you give us your declaration for

i_in_data

Regards

Raja

Re: hi. inserting data into a table from internal table

Former Member — Mon, 05 Dec 2005 11:47:15 GMT

hi..

i have used all the fields

and i cannnot use the like statement according to standards

i have declared manually.

Thanks & Regards

Guhapriyan

Re: hi. inserting data into a table from internal table

athavanraja — Mon, 05 Dec 2005 12:03:42 GMT

why dont you simply declare as below.

data: itab type standard table of <your dbtable> .

Regards

Raja

Re: hi. inserting data into a table from internal table

abdul_hakim — Mon, 05 Dec 2005 12:21:35 GMT

Can you paste ur piece of code for itab declaration here?

REgards,

Abdul

Re: hi. inserting data into a table from internal table

Former Member — Tue, 06 Dec 2005 03:00:28 GMT

If inserting new entries is what you are trying, try this:

insert <dbtable> from itab.

Also if you want to remove the previous entries do this first:

delete from <dbtable>

Message was edited by: Feroz Buksh

Re: hi. inserting data into a table from internal table

Former Member — Tue, 06 Dec 2005 04:04:54 GMT

Hi Subrahmanyam,

First Declare the internal Table like below:

Data: <Internal-table> type standard table of <database-table> with header line.

Then use the below code to modify the Database table based on your conditions.

modify <database-table> from table <internal-table>.

I hope this help's you.

Regards,

Raja

Re: hi. inserting data into a table from internal table

Former Member — Tue, 06 Dec 2005 04:38:06 GMT

Hi,

Check with this code......

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

data ITAB like standard table of TABLE with header line.

After getting all you data into ITAB....

loop at ITAB.

update TABLE from ITAB.

if sy-subrc eq 0.

commit work.

else.

rollback work.

endif.

_THANKS

If this helps you reward with points and close the thread.

Re: hi. inserting data into a table from internal table

Former Member — Thu, 08 Dec 2005 07:07:47 GMT

thank you all for the valuable suggestions..