INSERT Statement not working

[Former Member]

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

[Former Member]

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

[Former Member]

use commit work after insert statement.

[Former Member]

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

[Former Member]

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

INSERT into ZDCOM values ZDCOM.

regards

shiba dutta

[Former Member]

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.

[Former Member]

Himanshu,

Use the below line:

INSERT INTO ZDCOM VALUES ZDCOM.

Susanth

[Former Member]

Himanshu,

Is your problem resolved???