ISU FICA: Fetching Key date based open item list

[Former Member]

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

[Former Member · Accepted solution]

Hey Amol,

Try asking your BW team to perform this query for you. BW system is supposed to pull queries faster.

Regards,

Yuvi.

[former_member645257]

Amol,

You can use transaction FPO4P. It is run in parallel mode and you can get open items by several selection criteria, directly put in transaction or by creating predefined selection of partners, accounts or dunning related data using FPSELP and using FPSELP1 to define the layout of the resulting information.

You get the result in spools which can be unified, or aditional data set in binary or text format.

Hope this helps.

Regards,

Daniel