SAP Knowledge Base Article - Preview

2178099 - ERKRS/CE4KEY fields missing from COEP/ COEJ/ CECOEP/ CECOEJ


-During a client copy (or extension of CI_COBL structure or upgrade) there are errors on COEP, COEJ, CECOEP or CECOEJ indicating that the tables are inconsistent. After checking the tables in SE11 there are errors indicating that fields ERKRS and CE4KEY exist in the database but not in the SAP data dictionary:

  • "ERKRS does not exist ERKRS 82 NVARCHAR 4"
  • "CE4KEY does not exist CE4KEY 83 NVARCHAR 10"

2178099_1.png 2178099_2.png

-Logs for client copy failure can be accessed in SCC3. The log looks like this:

"Copy canceled; restart required
Message no. TA349
The main client copy process has been canceled at least once.
System Response
The copy cancelled itself after copying the tables, because the cancellation lost information needed to complete the copy."

-Also, in ST22, short dump is generated as below:

"Category ABAP programming error
Runtime Errors DBSQL_SQL_ERROR
Application Component BC-CTS-CCO
Date and Time :
Short Text
SQL error "SQL code: -10802" occurred while accessing table "CECOEJ".
What happened?
Database error text: "SQL message: Invalid numeric value for parameter/column
(167) source type NVARCHAR, target type DECIMAL"

-Missing Tables

Transaction Dbacockpit-> Diagnostics->Missing Tables and Indexes show that there are missing tables CECOEP CECOEJ in the system.

-SCC9N, SCCLN (new client copy) might raise the error as below:

"SQL Exception: SQL code: 330; SQL message: cannot use duplicate synonym name: CECOEJ: line 1"

Error Message Statements for Table CECOEJ could not be executed.



  • Controlling and Profitability Analysis (COPA)
  • SAP enhancement package for SAP ERP 6.0
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA Finance


SAP S/4HANA Finance all versions ; SAP S/4HANA, on-premise edition 1511 ; SAP Screen Personas 3.0 ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions


COPA, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, COEP, COEJ, RKE_HDB_EXTEND_COEX, client copy, inconsistency, SQL Error [406], SAP DBTech JDBC: [406]: INSERT, UPDATE and UPSERT are disallowed on the generated field , KBA , db02 , CO-PA , Profitability Analysis , CO-OM , Overhead Cost Controlling , BC-CTS-CCO , Client Copy (For ByD issues select BC-TLM-CP) , How To

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.