Performance issue in KONP or KONV table
We are preparing a SD rebate agreement report where we need to fetch data from condition tables like KONP, KONV, KONH.
Firstly we need key fields (KNUMH, KOPOS) from KONP by providing Agreement no (KNUMA). Its taking a absurd time to fetch the data, sometimes showing time out error.
When we normally accessing the table via se16 or se11 or se16n, its also taking long time to run.
I have collected the trace also( attaching herewithin).
Kindly help us in how to reduce the time to fetch data from the tables.