topic Re: Insert statement is returning sy-subrc 4 in Application Development and Automation Discussions

Insert statement is returning sy-subrc 4

Former Member — Tue, 04 Dec 2007 10:40:15 GMT

I have genereated a table maintenance for a custom table and maintaining values using the table maintenance.

The below code is quto generated.

INSERT ZCSC_EAP_BTI .

When I check in debug it returns sy-subrc = 4. But the values are not in the table.

What can be issue.

Re: Insert statement is returning sy-subrc 4

Former Member — Tue, 04 Dec 2007 10:42:23 GMT

SY-SUBRC = 4 means that stament not executed successfully

if it equals to zero then only that table fileds will be update d

Re: Insert statement is returning sy-subrc 4

Former Member — Tue, 04 Dec 2007 10:43:01 GMT

Use syntax.

Insert ZCSC_EAP_BTI from <work area>.
commit work.

Regards,

Satish

Re: Insert statement is returning sy-subrc 4

former_member386202 — Tue, 04 Dec 2007 10:43:32 GMT

Hi,

Try like this

INSERT INTO dbtab VALUES dbtab. OR

INSERT INTO scustom VALUES wa

Regards,

Prashant

Re: Insert statement is returning sy-subrc 4

Former Member — Tue, 04 Dec 2007 10:48:42 GMT

the syntax for insert is :

INSERT INTO dbtab VALUES WA.

n if it sy-subrc returns any value other than '0' then the statement has not executed correctly.

regards,

sohi

Re: Insert statement is returning sy-subrc 4

matt — Tue, 04 Dec 2007 11:02:08 GMT

Insert (into database) is valid in this format, but obsolete

Read the ABAP help for the keyword INSERT, and you'll see that sy-subrc = 4 means:

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.

You should be able to use UPDATE rather than INSERT. Or just use MODIFY.

matt

Re: Insert statement is returning sy-subrc 4

Former Member — Tue, 04 Dec 2007 11:15:31 GMT

Since the insert statement is autogenerated by SAP by generating table maintenance. I donot want to change that code. I want to know what is the issue

Re: Insert statement is returning sy-subrc 4

Former Member — Tue, 04 Dec 2007 11:50:51 GMT

check in your work area if there is any value present not

normally it occurs because you are trying to enter a value which is already present in the unique field of table

please cross check again may be it is u r missing some data

Re: Insert statement is returning sy-subrc 4

matt — Tue, 04 Dec 2007 12:07:52 GMT

The issue is that you are trying to create a record with the same key as a record already in the table.

>Read the ABAP help for the keyword INSERT, and you'll

>see that sy-subrc = 4 means:

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

matt