Performance improvement on BSEG table

[Former Member]

Hi,

For one of our programs, we are hitting BSEG table with ZUONR value and BSCHL as '01' values.

The program is taking too long just of this query and causing performance issue.

Is there any alternative through which we can achieve better performance using ZUONR and BSCHL? all we need is just the BELNR.

I've checked couple of threads and tried alternating the solution with BSID/BSAD but couple of cases are failing.

Any help would be highly appreciated!

Thanks,

Sandeep Kumar S

[Former Member]

Hi,

For one of our programs, we are hitting BSEG table with ZUONR value and BSCHL as '01' values.

The program is taking too long just of this query and causing performance issue.

Is there any alternative through which we can achieve better performance using ZUONR and BSCHL? all we need is just the BELNR.

I've checked couple of threads and tried alternating the solution with BSID/BSAD but couple of cases are failing.

Any help would be highly appreciated!

Thanks,

Sandeep Kumar S

[former_member235395]

Hi Sandeep,

Avoid get records from BSEG Table, for that use the Auxiliar Tables:

For Vendors: BSAK(Cleared Items) / BSIK (Open Items)

For Customers: BSAD(Cleared Items) / BSID (Open Items)

For G/L account: BSAS(Cleared Items) / BSIS (Open Items)

Regards

[RaymondGiuseppi]

Which problem did you get with BSID/BSAD 'couple of cases are failing' ?

Note that depending on your actual requirement, you may have to select from both tables (cleared or not-cleared item)