topic Re: INSERT Statement not working in Application Development and Automation Discussions

INSERT Statement not working

Former Member — Wed, 31 Jan 2007 08:05:52 GMT

Hi ABAP Gurus,

In ECC5.0, I am populating my data in a workarea named ZDCOM and I want to update the data from the workarea in the same name database table ZDCOM. For this I am using the command INSERT ZDCOM. But it is not working as the table ZDCOM doesn't gets updated.

Please help me out.

Thanks in advance.

Regards,

Himanshu Aggarwal

Re: INSERT Statement not working

Former Member — Wed, 31 Jan 2007 08:09:43 GMT

Check out this example

TABLES SCUSTOM. 
SCUSTOM-MANDT     = '002'. 
SCUSTOM-ID        = '12400177'. 
SCUSTOM-NAME      = 'Robinson'. 
SCUSTOM-POSTCODE  = '69542'. 
SCUSTOM-CITY      = 'Heidelberg'. 
SCUSTOM-CUSTTYPE  = 'P'. 
SCUSTOM-DISCOUNT  = '003'. 
SCUSTOM-TELEPHONE = '01234/56789'. 

INSERT INTO SCUSTOM CLIENT SPECIFIED VALUES SCUSTOM.

So your insert statement has to be


INSERT INTO ZDCOM CLIENT SPECIFIED VALUES ZDCOM.
COMMIT WORK.

Regards,

Santosh

Regards,

Santosh

Re: INSERT Statement not working

Former Member — Wed, 31 Jan 2007 08:10:12 GMT

use commit work after insert statement.

Re: INSERT Statement not working

Former Member — Wed, 31 Jan 2007 08:11:31 GMT

Hi,

While you are inserting, just check whether the INSER is failin gor not? just insert all the char types only and check the statemtns

Regards

Sudheer

Re: INSERT Statement not working

Former Member — Wed, 31 Jan 2007 08:15:30 GMT

the thing you are using for insert is obsolete now. try to use

INSERT into ZDCOM values ZDCOM.

regards

shiba dutta

Re: INSERT Statement not working

Former Member — Wed, 31 Jan 2007 08:16:25 GMT

hi,

try using the internal table with header line (i don know if u already do).

then chk this code it might help u.

tables spfli.

types: begin of line,

carrid type spfli-carrid,

connid type spfli-connid,

end of line.

data itab type table of line with header line.

*data itab type line.

select carrid connid from spfli into corresponding fields of table itab where carrid = 'LH'.

loop at itab .

READ TABLE itab INTO itab INDEX 1.

if sy-subrc eq 0.

itab-carrid = 'bb'.

itab-connid = '002'.

insert itab into itab.

endif.

endloop.

hope this helps

PLz reward if helpful.

Re: INSERT Statement not working

Former Member — Wed, 31 Jan 2007 08:18:11 GMT

Himanshu,

Use the below line:

INSERT INTO ZDCOM VALUES ZDCOM.

Susanth

Re: INSERT Statement not working

Former Member — Wed, 31 Jan 2007 09:11:22 GMT

Himanshu,

Is your problem resolved???