cancel
Showing results for 
Search instead for 
Did you mean: 

How to Clear a A/R GL with Huge line items

Former Member
0 Kudos

Hi All,

Could you please suggest a way to solve this issue:

A/R GL which has more than 90 Million open line items. We want to clear all the open items in this GL account.

Also we use back ground job for program SAPF124 for clearing open items.

We would like to know if they is any alternative way for clearing huge open items in GL.

Appreciate your quick response.

Thanks

Prasad

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I have some ideas on this issue, but I am very interesting why there are so many open items. Have you activated the open item management within ECC6 SR3?

I suggest you can clear these items by standard way, however you must breakdown to periods and as execute as background job, else this will cause performance issue and time out issue.

Best Regards!

Flex Yang

SAP FI/CO, MM, SD Certificed

Former Member
0 Kudos

Hi,

Thanks for your response. We have this situation for different company codes. For few company codes we had less number of line items (5 million). We cleared them with background jobs with different variants.

But now the problem is with company code which has 90 Million line items which needs to be cleared. even if we make the job with different variants. It takes huge time to clear them (assuming 1 million records per variant).

Client is in entertainment industry and we keep getting those line items increased everyday. I need to clear this GL with less number of records ex:250,000 per variant so that job should not fail.

If i create a job with variants each variant consists of 250,000 records, i need to create lot of variants for this.

I want to know if there is any alternative way of dealing this issue, so that performace of system is not disturbed.

Thanks

Prasad