Solution : https://service.sap.com/sap/support/notes/514221 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance issues in displaying implemented equipment on the master record's tab page of a Technical Object (like Functional Location or Equipment), leading to long runtimes and potential timeouts. The issue is attributed to the poor index utilization for tables ILOA and EQUZ when accessing certain fields, causing inefficient queries. The recommendation is to evaluate the necessity of the table-control setup and consider modifying view profiles or employing structure lists for better performance. Adjustments in Customizing ensure more efficient data handling and potentially adjust index usage to improve system response.
Key words :
customer service --> - technical objects --> - equipments --> - equipment categories --> - maintain equipment category release 4, customer service --> - technical objects --> - general data --> - setting view profiles, customer service --> - technical objects --> - functional locations --> - define category, cost based optimizer considers field tplnr, customer service --> - master data, creating dummy master records, cost based optimizer, suitable view profiles, technical objects, basic program place
Related Notes :
| 534746 | Technical object: Performance problem for data transfer (2) |
| 515769 | Techn.obj.:Runtime during search for install.eqpmts (EQUZ~H) |
| 335415 | Creating and Maintaining Histograms |
| 182463 | Functional location: Performance during creation |