topic Re: insert into dbtab in Application Development and Automation Discussions

insert into dbtab

Former Member — Mon, 13 Mar 2006 09:29:01 GMT

Hi to all.

i wanna insert records from itab into dbtab/

when i use this command:

INSERT dbtab FROM TABLE itab.

the program is fall on this line and i get this msg:

"It is too big".

what i wanna do is just transfer from itab the corresponding fields to the dbtab.

plz help me.

thanks.

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:33:38 GMT

Hi gil,

1. Simple.

2. declare your itab EXACTLY like dbtab.

3. then use this logic.

LOOP AT ITAB.

MODIFY DBTAB FROM ITAB.

ENDLOOP.

(THIS WILL TAKE CARE OF ADD/EDIT

BASED UPON THE PRIMARY KEY,

AUTOMATICALLY)

regards,

amit m.

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:34:07 GMT

use workarea instead oof whole internal table data.

INSERT INTO dbtab VALUES wa.

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:34:08 GMT

use Modify statement of Inserting or Updating records.

The MODIFY statement changes existing lines and inserts lines which do not exist.

Syntax is :

Modify dbtablename from itab(internal table name).

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:34:17 GMT

Hi Gil,

You can insert record in DB table using.

Insert statement

INSERT dbtab FROM TABLE itab

Modify Statement.

MODIFY dbtab FROM wa

If record doesn't exsist it will insert a new record in that.

Cheers

Sunny

Re: insert into dbtab

vinod_gunaware2 — Mon, 13 Mar 2006 09:34:21 GMT

Use

MODIFY dbtab FROM TABLE itab. or

MODIFY (dbtabname) FROM TABLE itab.

befor modify populate all data into itab.

Regards

vinod

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:35:46 GMT

Hi,

Your itab must match with the dbtab.

Have you declared the internal table as dbtable.

If yes, then your command is perfect.

Just check the structures are matching or not.

Regards,

Shashank

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:38:12 GMT

Hi,

INSERT dbtab FROM TABLE itab.

The structure of itab must be at least as wide as the table work area dbtab and its alignment must correspond to that of the table work area, otherwise a runtime error will occur.

Riyaz

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:39:58 GMT

Hi,

Such type of errors pops up when you are trying to upload entire data of Internal table in to database table... So as to overcome such situation use work area

i.e,

INSERT INTO dbtab VALUES wa.

Re: insert into dbtab

hymavathi_oruganti — Mon, 13 Mar 2006 09:41:13 GMT

PROBABLY THE INTERNAL TABLE STRUCTURE AND DBTAB ARE NOT SIMILAR

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:44:36 GMT

i know that t itab have more fields the the dbtab ,

i just wanna insert the corresponding fields to the dbtab.

thanks.

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:49:22 GMT

Hi,

If the itab has more fields, then check the sequence of fields. It should match with that in the actual dbtab.

Regards,

Shashank

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:52:29 GMT

if ur itab is not matching the dbtab then u go for modify statement.

i thought it was

itab like DBTAB occurs 0 with header line.

but as per ur reply it is not.

so now ur option has to be this one.

see that u r itab is containg all the primary keys as that of the DBtab.

if this is not so then there may be a CONFLICT OF INSERTING DUPLICATE ENTIRES.

say ur DBTAB has primary keys P1, P2, P3.

so ur ITAB has to contain the three keys .

then get the content into itab.

loop at itab.

modify table DBTAB from ITAB.

endloop.

hope this helps ,

vijay.

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 09:53:58 GMT

declare an internal table (say itab1) like dbtab.

then use move-corresponding to copy lines of itab into this internal table.

now use the insert statement using itab1.

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 10:28:15 GMT

Hi Gil

U have to declear the same structure as dtab and then try to insert.

u can use move corresponding itab to dbtab.

it will move all the fields that are matching in itab or else i wont move.

i think this will solve u r prob

Thanks

Vikranth Khimavath

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 12:37:28 GMT

ok...

the problem is that the itab that i read from is declare like this:

DATA: BEGIN OF invctab OCCURS 0,

k LIKE vbrk,

p LIKE vbrp,

x LIKE extras.

DATA: END OF invctab.

and i need to move-corresponding fields to dbtab.

i try to move-corresponding to my dbtab.

and the msg its to big return.

any idea?

Re: insert into dbtab

Former Member — Mon, 13 Mar 2006 12:41:14 GMT

loop at invctab.
  move-coresponding invctab to dbtab.
  append dbtab.
  clear dbtab.
endloop.

Message was edited by: Sekhar