Solution : https://service.sap.com/sap/support/notes/155497 (SAP Service marketplace login required)
Summary :
High performance issues occur when displaying change documents in condition maintenance, particularly due to inefficient database accesses in SAP. The main problem lies in unfavorable queries on the CDHDR table, used for tracking changes in condition records. Modified solutions range from code adjustments in RV16ACHD and LV64AU06 to prevent unnecessary detail expansions, to creating database indices on CDHDR for enhanced query performance. Earlier versions may need specific solutions like using NATIVE SQL for indexing or manual table conversion, given the lack of secondary indices in default settings which affects write operations.
Key words :
mandant objectclas username udate utime tcode, additional key words display report, indirectly changed condition records, changenr <= wk-changenr-max, changenr >= wk-changenr-min, number range occurs buffered, username = i_level1-username, udate = i_level1-udate, utime = i_level1-utime, tcode = i_level1-tcode
Related Notes :
| 324279 | Rebate: Displ of change docs f conditions is too slow |
| 150925 | Performance during access to table CHDHR |
| 82164 | Conditions: Display change document (RV16ACHD) is slow |