SAP Knowledge Base Article - Preview

3367232 - There is lot of slowness in accessing table BKPF after NW version and DB version upgrade- SAP ASE for Business Suite

Symptom

  • The performance of MIRO is slower than before upgrading NW version and DB version.
  • According to STAT trace, the slowest query is accessing to table BKPF as follows. 
    SQL Text: SELECT * FROM "BKPF" WHERE "MANDT" = ? AND "BUKRS" = ? AND "BKTXT" = ? AND "GJAHR" >= ? AND "BLART" IN ( ? , ? , ? , ? ) AND "BUDAT" >= ? AND "STBLG" = ? AND "BSTAT" <> 'S' /* R3:SAPLZGFNCF:3635 T:BKPF M:300 */ /*124*/]]>


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Netweaver 7.53

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.5

Keywords

MIRO, BKPF, SAPLZGFNCF  , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.