SAP Knowledge Base Article - Preview

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

Symptom

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
Diagnosis
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
Except. CX_SY_OPEN_SQL_DB
ABAP Program SAPLSCCR
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


Read more...

Environment

  • 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

Product

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

Keywords

COPA, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, COEP, COEJ, RKE_HDB_EXTEND_COEX, client copy, inconsistency , 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 ONE Support launchpad (Login required).

Search for additional results

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