SAP Knowledge Base Article - Preview

2940035 - SQL code: 2048 occurred while accessing table C_PURGMATLPRICECHG3

Symptom

Users are facing low performance in the Fiori Launchpad and the following dump is being raised on the back-end system:

Category External Error
Runtime Errors DBSQL_SQL_INTERNAL_DB_ERROR

Short Text
SQL error "SQL code: 2048" occurred while accessing table "C_PURGMATLPRICECHG3".

[...]
Database Interface Information
SELECT /* CDS access control applied */ "DISPLAYCURRENCY" "K____3350" , COUNT(*) "Z____268_SUM" , SUM( "WEIGHTEDNETPRICE" ) "Z____3355_SUM" , SUM("INVOICEAMTINDISPLAYCURRENCY" ) "Z____3356_SUM" FROM /* Entity name: C_PURGMATLPRICECHG3 CDS access controlled */ "CMMMATLPRC3" ( "P_STARTDATE" => ? , "P_ENDDATE" => ? , "P_DISPLAYCURRENCY" => ? ) "A1" WHERE "MANDT" = ? GROUP BY "DISPLAYCURRENCY" WITH HINT(RESULT_LAG ('hana_short')) WITH RANGE_RESTRICTION('CURRENT');


Read more...

Environment

  • SAP Fiori
  • SAP Fiori for S/4HANA 1709

Product

SAP Fiori all versions ; SAP Fiori for SAP S/4HANA 1709

Keywords

MM, FIORI, OOM, DBSQL_SQL_INTERNAL_DB_ERROR, SQL code, 2048, occurred, while, accessing, table, C_PURGMATLPRICECHG3, SELECT /* CDS access control applied */, low, slow, poor, performance, hana, launchpad , KBA , MM-FIO-PUR-ANA , Fiori UI for Purchasing Analytics , Problem

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.