SAP Knowledge Base Article - Preview

1903713 - MIGO: SAPSQL_ARRAY_INSERT_DUPREC - Material Document is not available in the database / MSEG - SAP ERP& SAP S/4HANA

Symptom

  • Material Document does not exist in the database after a Goods Movement is performed and "Document ### posted" message is displayed.
  • There is an offset / discrepancy of more than 1 between Material Document Interval Number (OMBT) and the latest material document available in MSEG / ACCTHD (Or any table that is causing the "SAPSQL_ARRAY_INSERT_DUPREC" runtime error);
  • You receive a short dump DBSQL_DUPLICATE_KEY_ERROR in the ABAP program *LMBMB (like SAPLMBMB, LMBMBU04...);
  • Dump SAPSQL_ARRAY_INSERT_DUPREC occurred in program SAPLMBMB when you post material document with T-codes MIGO, ML81N, MB1A, MB1C, MB01, VL02N or function module BAPI_GOODSMVT_CREATE.


Read more...

Environment

  • Materials Management (MM)
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

ECC, find, found, update, post, GR, posting, SAPSQL_ARRAY_INSERT_DUPREC , DBSQL_DUPLICATE_KEY_ERROR , MATBELEG, does not exist in calendar year, update termination, SM13 , KBA , MM-IM-GR-PO , Goods Receipt from External Procurement , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.