SAP Knowledge Base Article - Preview

3350691 - Performance slow on SD_COND_ACCESS related to condition table processing.

Symptom

Performance issue on SD document processing ( VF04 or background job SDBILLDL ) , the expensive statements indicates SAPLV61Z ( the ABAP program for function module SD_COND_ACCESS)  for some condition tables are the most consuming executions. 

Trace analysis indicates that following statement as the cause of the slow performance:

            SELECT * FROM (t681-kotab) APPENDING TABLE <cond_tab>
                   WHERE kappl  = se_kappl
                   AND   kschl  = se_kschl
                   AND   datbi >= se_date
                   AND   datab <= se_date
                   AND   (coding_tab).


Read more...

Environment

  • Sales And Distribution (SD)
  • Logistics Execution (LE)
  • SAP R/3
  • SAP R/3 Enterprise 4.7
  • SAP ERP Central Component
  • SAP ERP
  • SAP Enhancement package for SAP ERP
  • SAP Enhancement package for SAP ERP, version for SAP HANA

Product

SAP ERP all versions

Keywords

performance, conditions, SD_COND_ACCESS, SDBILLDL,  SAPLV61Z   , KBA , SD-MD-CM , Conditions and Condition Maintainance , 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.