topic Re: Insertion a record into database table in Application Development and Automation Discussions

Insertion a record into database table

Former Member — Tue, 01 Jul 2008 07:39:46 GMT

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

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 07:41:27 GMT

hi,

Check the data that you are inserting.

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 07:42:22 GMT

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

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 07:42:59 GMT

Praveen,

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

Amit.

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 07:45:07 GMT

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.

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 08:24:56 GMT

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.

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 08:56:00 GMT

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.....

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 08:59:49 GMT

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

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 11:20:27 GMT

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?

Re: Insertion a record into database table

Former Member — Tue, 01 Jul 2008 11:21:38 GMT

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.