I have a program that creates a short dump in the background when I call a function module more than once in the same program.
Basically what I do is call BUPR_RELATIONSHIP_CREATE
for each relationship I need to create in our CRM system.
I even do a COMMIT WORK AND WAIT after each call, however I get a short dump of DUPLICATE key insert (SAPSQL_ARRAY_INSERT_DUPREC)
Looking at SAP's own code where the dump occurs, SAP have commented out the line:
INSERT BUT051 FROM TABLE LT_BUT051 ACCEPTING DUPLICATE KEYS.
Here is an excerpt of the code from my program:
CALL FUNCTION 'BUPR_RELATIONSHIP_CREATE'
EXPORTING
iv_partner_1 = '0010003939'
iv_partner_2 = '0010008090'
iv_relationship = 'ZUR010'
iv_date_from = '00010101'
iv_date_to = '99991231'
iv_testrun = ' '
iv_x_save = 'X'
TABLES
et_return = gt_return.
PERFORM disp_error USING gs_warning.
COMMIT WORK AND WAIT.
CALL FUNCTION 'BUPR_RELATIONSHIP_CREATE'
EXPORTING
iv_partner_1 = '0010003939'
iv_partner_2 = '0010004555'
iv_relationship = 'ZUR010'
iv_date_from = '00010101'
iv_date_to = '99991231'
iv_testrun = ' '
iv_x_save = 'X'
TABLES
et_return = gt_return.
PERFORM disp_error USING gs_warning.
COMMIT WORK AND WAIT.
Can anyone offer any advice?
Many Thanks
David