Performance Problem in using the BSEG table - Required alternative

[Former Member]

Hi All,

Pl go thru the below program.

I am unable to change this code

It is having 46 performance errors

Pls check the code and suggest.

***************************************************************************************************************************************************

*To get Pmt Doc No & Posting Date

SELECT SINGLE

BELNR

ZFBDT

FROM BSEG

INTO (WA_ZFT011_FIFO-PAY_DOC_NO, WA_ZFT011_FIFO-POST_DATE)

WHERE AUGBL = W_CLR_DOC

AND AUGDT = WA_ZFT011_FIFO-CLR_DATE

AND BSCHL = '15'.

IF SY-SUBRC <> 0.

SELECT SINGLE

BELNR

ZFBDT

FROM BSEG

INTO (WA_ZFT011_FIFO-PAY_DOC_NO, WA_ZFT011_FIFO-POST_DATE)

WHERE AUGBL = W_CLR_DOC

AND AUGDT = WA_ZFT011_FIFO-CLR_DATE

AND BSCHL = '11'.

***************************************************************************************************************************************************

The above code is having performance error "NO field of a table Index in WHERE"

The same error repeated for 45 select statements and for all statements the "BSEG" table is used for selecting data.

But creating a secondary index on BSEG table columns will not be possible

So pls suggest me accordingly

Awaits for the Reply.

P Kamal

[Former Member]

hi

Check it here

[Performance Tuning for the BSEG selection|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19538] [original link is broken] [original link is broken] [original link is broken];

[gerd_rother]

Hi,

Perhaps my post here: might help you.

Regards, Gerd Rother