SAP Note 19030 - SAPSQL_ARRAY_INSERT_DUPREC in table CE4xxxx

Symptom:

When you update data in Profitability Analysis, for example, when you enter a line item (Transaction KE21) or when you post to the profitability segment in Financial Accounting (Transaction FB01), the program terminates with short dump SAPSQL_ARRAY_INSERT_DUPREC. The table is CE4xxxx or CE4xxxx_ACCT (xxxx = operating concern).

Cause and prerequisites

When copying/transporting a client, table CE4xxxx or CE4xxxx_ACCT (as of Release 4.5A) was also copied. The number range status, however, was not adapted. If you want to add new profitability segments, a number for which a record already exists in table CE4xxxx or CE4xxxx_ACCT is assigned during the number assignment.

Solution

Adapt the number range status for tables CE4xxxx and CE4xxxx_ACCT to the current database status:

1. Determine the last number assigned, for example, with the following ABAP (replace xxxx with the corresponding operating concern):
report zztest01.
tables: CE4xxxx.
data: max_ce4 like CE4xxxx-paobjnr.
select max( paobjnr ) into max_ce4 from CE4xxxx.
write: / max_ce4.
As of Release 4.5, also add the following lines to the program:
select max( paobjnr ) into max_ce4 from CE4xxxx_ACCT.
write: / max_ce4.
The last object number used is output for each table.

2. Change the number range status using Transaction SNRO: Number range object COPA_OBJ, operating concern xxxx. Enter the greatest number determined in 1. as the current number status.

If the last number used of tables CE4xxxx or CE4xxxx_ACCT is smaller than the current number status, the termination problem will not be solved by this note.

Additional key words

CE4nnnn, CE4nnnn_ACCT