Skip to Content
0
Former Member
Nov 07, 2007 at 02:41 PM

ISU FICA: Fetching Key date based open item list

327 Views

Hi,

Our production system has a setting to kill SELECT query if it’s 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