SAP Knowledge Base Article - Preview

3784926 - CE4JD00 select single performance degradation when table grows due to non-standard HANA index

Symptom

  • Performance issue in SAP standard code accessing table CE4JD00.
  • Runtime of a standard SELECT SINGLE against CE4JD00 increases significantly as table volume grows (for example, ~700,000 records take ~20 seconds; higher volumes increase runtime proportionally).
  • Bottleneck occurs in standard code, not in custom logic.
  • Subroutine pool reference: RK2AJD00_POST – SELECT SINGLE * FROM CE4JD00.
  • In one environment the API completes in an acceptable time, while another environment shows substantially longer runtimes with the same payload.


Read more...

Environment

  • Product: SAP S/4HANA
  • SAP HANA Database 

Product

SAP HANA, platform edition all versions ; SAP S/4HANA all versions

Keywords

ce4jd00, ce4xxxx, copa, controlling, profitability analysis, select single, performance, hana index, inverted value index, ce4jd00~z01, rk2ajd00_post, st12, slow query, plan regression, table growth , KBA , HAN-DB-PERF , SAP HANA Database Performance , 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.