'Modify' stmt showing sy-subrc = 0 for duplicate record

[ricky_shaw]

Hi,
In my prog, I am updating a Z*table using Modify from a workarea stmt within a loop..endloop.
The work area is exactly like DBtable structure with 4 unique keys. I have 4 keys in a Z*Table.

I have a Modify Z*INVDBTAB from wa_invdoc stmt. Modify is showing sy-subrc = 0 even when it encounters a duplicate record with same set of unique keys but fortunately the Z*DB table is NOT updating that duplicate record(which is correct).

The Modify stsmt should show sy-subrc = 4 right? 

Can someone Pls clarify.

[Sandra_Rossi]

Answer is here: https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abapmodify_dbtab.htm . 4 happens only for a duplicate in a SECONDARY unique index. MODIFY is an "UPSERT". It tries to INSERT but if it exists it does an UPDATE.