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 for Me (Login required).

Search for additional results

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