Hi,
Our production system has a setting to kill SELECT query if its running for more than 12 hours without any updates.
We want to fetch all open items from DFKKOP table for any given date (could be a past date), company code, business area and reconciliation account. We tried fetching this list using SAP report RFKKOP03 and also by writing custom SELECT query however because of large volume of DFKKOP table in our system, none of the report is getting completed within 12 hours and hence getting terminated by system.
It would be helpful if anyone can suggest us any other option to fetch the list of open items on any given key date.
Thanks,
Amol