3648688 - Low performance with report SAPLV61Z

Symptom

You are experiencing performance issues due to a search query in condition table ,e.g. A912. Several operational processes, such as invoicing, sales order creation, merchandise movement, etc., call this table.
When checking the statement executed in the database, following expensive statement is found to be run in high amount of times:

SELECT /* Buffer Loading */ "MANDT" , "KAPPL" , "KSCHL" , "KUNNR" , "WERKS" , "MATNR" , "KFRST" , "DATBI" , "DATAB" , "KBSTAT" , "KNUMH" FROM "A912" WHERE "MANDT" = ? ORDER BY "A912" . "MANDT" , "A912" . "KAPPL" , "A912" . "KSCHL" , "A912" . "KUNNR" , "A912" . "WERKS" , "A912" . "MATNR" , "A912" . "KFRST" , "A912" . "DATBI"
statement hash: 9a1fe3613a6ce2173c15c503b51d8367

Environment

HANA 2.0

Product

SAP HANA, platform edition 2.0

Keywords

Buffer Loading, condition table, Pricing tables, Buffer Loading, SD_COND_ACCESS, Fully Buffered , KBA , HAN-DB-PERF , SAP HANA Database Performance , SD-MD-CM , Conditions and Condition Maintainance , How To

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.