SAP Knowledge Base Article - Preview

1843623 - Update Termination error 'SAPSQL_ARRAY_INSERT_DUPREC' when making changes in Sales documents relevant for Revenue Recognition

Symptom

  • Update Termination when making changes to sales documents relevant for Revenue Recognition of Type 'B'.
  • 'SAPSQL_ARRAY_INSERT_DUPREC' in transaction ST22 after saving changes to sales documents.
  • Transaction ST22 shows the following dump details:
    • SAPSQL_ARRAY_INSERT_DUPREC
    • CX_SY_OPEN_SQL_DB
    • SAPLVFRU or LVFRUU01
    • SD_REV_REC_VBREV_TABLES_POST


Read more...

Environment

  • Sales and Distribution (SD)
  • SAP R/3 4.6B
  • SAP R/3 4.6C
  • SAP R/3 Enterprise 4.7x110 (Extension Set 1.10)
  • SAP R/3 Enterprise 4.7x200 (Extension Set 2.00)
  • SAP ERP 6.0
  • SAP ERP Central Component 5.0
  • SAP ERP Central Component 6.0
  • SAP enhancement package 2 for SAP ERP 6.0
  • SAP enhancement package 3 for SAP ERP 6.0
  • SAP enhancement package 4 for SAP ERP 6.0
  • SAP enhancement package 5 for SAP ERP 6.0
  • SAP enhancement package 6 for SAP ERP 6.0
  • SAP enhancement package 7 for SAP ERP 6.0
  • SAP enhancement package 6 for SAP ERP 6.0, version for SAP HANA

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

Service related revenue recognition , KBA , cx_sy_open_sql_db , dump , sapsql_array_insert_duprec , revenue recognition , pod (proof of delivery) , lvfruu01 , podkz , update termination error , sd_rev_rec_vbrev_tables_post , saplvfru , st22 , va42 , sales document , va02 , SD-BIL-RR , Revenue Recognition , 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.