Skip to Content
0
Former Member
Feb 14, 2011 at 08:08 PM

Performance Issue while accessing table BSEG

117 Views

Hi All,

I see a performance issue when accessing tables BSEG using the data from table BKPF.

I extracted the fields from BKPF table and then made the following statemnt :

Select bukrs, belnr, gjahr, buzei, hkont, txjcd, mwart

from bseg

for all entries in it_bkpf

where bukrs EQ it_bkpf-BUKRS AND

belnr EQ it_bkpf-belnr AND

gjahr EQ it_bkpf-gjahr AND

buzei EQ it_bkpf-buzei AND

hkont EQ it_bkpf-hkont.

But this statement causes a serious performance issue and my program stops working from here.

Could someone please help me out with this.

Thanks & Regards,

Sushanth Hulkod