SAP Knowledge Base Article - Preview

3321191 - How to maintain Database Hints for optimizing CDS views for program “Read from Universal Journals” in S/4HANA Finance for Group Reporting

Symptom

While executing the Task “Release Universal Journals” (aka Data Release Task) the following may happen:

  • a time out limit is stopping the program
  • Hana Memory limits are ending the execution

OR

  • runtime may not fulfill the KPIs defined

Root Cause Analysis made by you or by SAP Support showed that a certain SQL statement reading from a certain CDS view can be optimized by database hints. For more information regarding hints, refer to KBA 2142945 - FAQ: SAP HANA Hints. This KBA aims to give guidance on how to maintain the recommended hints and give background information for ongoing system operations with the chosen settings.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • S/4HANA Finance for Group Reporting Private Cloud Edition
  • S/4HANA Finance for Group Reporting On Premise

Keywords

Performance, CDS Views, HANA Hints, Group Reporting, S/4HANA Finance, Release of Universal Journals, Data Release Task, HANA Memory, DBSQL_SQL_INTERNAL_DB_ERROR, CX_SY_OPEN_SQL_DB , KBA , FIN-CS-COR-DT-RUJ , Release Universal Journals , FIN-CS-COR , S/4HANA Financial Consolidation, Core Processing , FIN-CS-COR-DT , Data Transfer , 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.