topic Re: how to catch error after INSERT command in Application Development and Automation Discussions

how to catch error after INSERT command

former_member190312 — Mon, 11 Nov 2013 00:28:54 GMT

Hi all,

I am using INSERT command to insert record into

Database table lfa1 as per below code. I want to capture

Exact error ( like duplicate record) why insert lfa1 command is unsuccessful. Please advise.

Loop at I_lfa1 into wa_lfa1.

INSERT LFA1 from wa_lfa1.

If sy-subrc ne 0.

Capture error why insertion not success.

Endif.

Endloop.

Thanks

Pabi

Re: how to catch error after INSERT command

custodio_deoliveira — Mon, 11 Nov 2013 02:43:00 GMT

Hi Pabitra,

It's all on the online help <F1>:

sy-subrc	Meaning
0	When a work area was declared in source, the specified row was changed. In the declaration of an internal table in source, all declared rows were inserted, or the internal table is empty.
2	When a LOB handle structure was specified with a component for writer streams, the non-LOB handle components were not yet written to the database, but instead are passed when the stream is clased, at the latest. Whether this situation occurs or not depends on the database. Refer to LOB handles.
4	When a work area was specified in source, the declared row was not inserted, or, when an internal table was specified in source, not all declared rows were inserted, since a row in the database table has the same primary key or a unique secondary index.

Cheers,

Custodio

Re: how to catch error after INSERT command

arivazhagan_sivasamy — Mon, 11 Nov 2013 02:58:39 GMT

This message was moderated.

Re: how to catch error after INSERT command

former_member209120 — Mon, 11 Nov 2013 03:45:02 GMT

This message was moderated.

Re: how to catch error after INSERT command

Former Member — Mon, 11 Nov 2013 05:19:51 GMT

Pabitra,

Try this one.

Loop at I_lfa1 into wa_lfa1.

select single * from lfa1 into (another workarea)

where field = wa_lfa1-field.

if sy-subrc is not initial.

INSERT LFA1 from wa_lfa1.

if sy-subrc is initial.

commit work.

else.

rollback work.

endif.

else.

* Take the value in any other workarea that this is duplicate record or record already exists.

endif.

Endloop.

Regards

Vivek

Re: how to catch error after INSERT command

former_member192023 — Mon, 11 Nov 2013 05:32:39 GMT

This message was moderated.

Re: how to catch error after INSERT command

Former Member — Mon, 11 Nov 2013 10:43:42 GMT

Check sy-subrc value if '0' means record inserted else error.

Hope this helps.