Clave duplicada en INSERT

[chivi82]

Hola, te pongo un ejemplo de como capturar excepciones:
TRY.
SELECT matnr charg ingew sitbu bulid FROM z40bupa
INTO TABLE g_it_z40bupa
WHERE matnr IN s_matnr
AND charg IN s_charg
AND sitbu IN s_sitbu
AND werks IN s_werks
AND ersda IN s_ersda.

CATCH cx_sy_open_sql_db.
MESSAGE i098(z40pp) WITH 'Select con demasiados registros'.
EXIT.
ENDTRY.