SAP Note 18065 - MRP: SAPLM61U SAPSQL_ARRAY_INSERT_DUPREC

Symptom:

Consumption-based planning ( MD01 MD02 MD03 MS02 ) terminates with SAPSQL_ARRAY_INSERT_DUPREC. The termination occurs in LM61UF20 during insert in table MDTB.

Cause and prerequisites

Incorrect number range status for the MRP lists.

Solution

1. First determine the highest number range status.
Report with the following source:
tables: MDKP.

select * from MDKP.
write: / MDKP-DTNUM.
endselect.

Hold highest number.

2. Check and change status.
Call OMI2 and then choose 'Number ranges' under MRP list. Write down the number of the number range for the planned plant and then go back.

Then call the intervals and set the status >= highest number (see above) for the interval belonging to this number.

Additional key words

INSERT_MDTB_MDTBX