Insertion a record into database table

[Former Member]

Hi All,

I ahve written code to insert a recrod into database table.

eg : INSERT INTO smen_buffc VALUES wa_smen_buffc.

the work area contains same structure as that of table name smen_buffc.

but when i execute it returns sy-subrc value as 4.

what is the reason y it is not inserting the rows.

pls help me

urgent

[Former Member]

hi,

Check the data that you are inserting.

[Former Member]

hi,

Goto SM12 transaction and check whether the table is locked ....if so then unlock the table and then try inserting the entires in to the table ..

Regards,

Santosh

[Former Member]

Praveen,

Check in SE11 whether with the same key data available in table already?if so than this entry would not be enter.

Amit.

[Former Member]

Hi Praveen,

This is the meaning of sy-subrc = 4:

At least one row could not be inserted, because the database table already contains a row with the same primary key or a unique secondary index.

Thanks,

Victor.

[Former Member]

Hi Parveen,

Try it this way.

INSERT Internal_table into Database_table.

and also check that there should not any duplicate values of primary key.

hope this will work.

Thanks & Regards.

Rajesh Kumar.

[Former Member]

hi....

The reason may be that you are inserting dulicate entriesi.e.the entry must be already existing in the table.

In that case it is giving sy-subrc = 4.

check your table again.....

[Former Member]

means similar data with same key already exists....

check your table entries

after insert... use the statement Modify..

Regards,

VIjay

Edited by: Vijay on Jul 1, 2008 11:00 AM

[Former Member]

hi,

I am inserting new entries into the table.

I am getting sy-surbc eq 0.

When i check the table the data is not inserted into the table.

y is it soo?

[Former Member]

I am inserting new entries into the table still the records are not inserted into the tables.

I am getting sy-subrc =0. When I check it in the table. the data is not inserted.