Solution : https://service.sap.com/sap/support/notes/107284 (SAP Service marketplace login required)
Summary :
In SAP environments, function module SD_COND_ACCESS is engaged for condition access in applications like pricing or batch determination, setting up dynamic SELECT statements, possibly causing high system loads if access structures are complex and accesses are frequent. Optimizing system performance can be achieved by enhancing buffering and refining the creation process. Code adjustments in programs LV61ZU01 and LV61ZTOP are recommended. The updated source code for module SD_COND_ACCESS for Release 4.0B is also provided as a reference for implementation.
Key words :
entire function module sd_cond_access, function module sd_cond_access, additional key words, high system load, complex access structures, select statement dynamically, select statement#, effective access, system performance, batch determination
Related Notes :
| 324772 | OPEN SQL: Runtime at dynamic clauses |
| 318216 | IS-H NL : Performance improvement billing |
| 315238 | Pre-step does not use fixed values in the access |
| 168906 | IS-H Performance improvement patient billing |
| 154091 | Performance in delivery process: Collective note |
| 145092 | Tuning in billing and settlement |
| 109886 | ME21, ME22: Performance improvements |
| 95274 | Performance problems with application of overhead |
| 91830 | Performance in pricing |
| 66196 | Revenue acct determination with specific values |
| 62536 | Info: Conditions in Profitability Analysis |
| 38631 | ABAP/4 runtime error SAPSQL_WHERE_PARENTHESES |