Solution : https://service.sap.com/sap/support/notes/85957 (SAP Service marketplace login required)
Summary :
When executing settlement transactions in SAP (e.g., KO88, AIBU) for CO objects or assets under construction, users may encounter an ABAP/4 runtime error 'SAPSQL_ARRAY_INSERT_DUPREC'. This error, occurring in the program SAPLKO78, is typically due to overlapping or duplicated document numbers from internal number ranges during CO or FI-AA settlements. To resolve, administrators should run the RKOABRNR report to identify and adjust the affected number ranges through SAP Customizing, ensuring number levels are set above the last issued document number or moving to a new range if necessary. Ensuring correct range settings prevents future occurrence of these errors.
Key words :
'controlling -> internal orders -> actual postings -> settlement -> maintain number ranges, 'financial accounting -> asset accounting -> transactions -> capitalization, line item settlmt' -> 'change number ranges, message 'abap/4 runtime error sapsql_array_insert_duprec', construction -> maintain number ranges, incorrect number range settings, relevant controlling areas, internal number assignment, internal number interval, internal settlement document
Related Notes :
| 397799 | INFORMATION: CO-OM-OPA (Order & Project Accounting) |
| 396767 | RKANRCHK - analysis program correction |