data fetching from BSEG table

[Former Member]

Hi,

I have used smartforms for generating suppler payment statement for financial department. more time duration is taken by the program when it is generating.

I think this problem comes while data fetching from BSEG table. because, it has more records for one vendor ID.

I want reduce this time duration.

Please guide me.

[Former Member · Accepted solution]

Have you tried this selection in se16? I'm quite sure that It will take

a long time.

The problem has been explained in this group before and I think you

should search for bseg in the answers given.

As a hint: It has to do with the selection universe. You are restricting

only bukrs from the primary key (all the other restrictions in your

where clause are filters that are applied on SAP's side (not on the

database side)). The problem is that bseg isn't stored as separated

fields in the RDBMS, but as a table with the primary key and a stream of

bits in a raw field.

You should review and change the logic you're using before reading bseg.

It's the only way you'll improve the performance of this select. (for

example, you could use one or more secondary index tables - bi or ba

to retrieve belnr and access bseg with a better where clause).

[nivin_varkey]

please refer to tables BSIK and BSAK, they have same entries as of BSEG but are indexed on vendor..Hope this solves ur problem..