Performance Problem in using the BSEG table - Required alternative

Former Member — Thu, 03 Jun 2010 06:17:15 GMT

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

Re: Performance Problem in using the BSEG table - Required alternative

Former Member — Thu, 03 Jun 2010 06:29:49 GMT

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];

Re: Performance Problem in using the BSEG table - Required alternative

gerd_rother — Thu, 03 Jun 2010 06:44:33 GMT

Hi,

Perhaps my post here: might help you.

Regards, Gerd Rother

topic Performance Problem in using the BSEG table - Required alternative in Application Development and Automation Discussions

Performance Problem in using the BSEG table - Required alternative

Re: Performance Problem in using the BSEG table - Required alternative

Re: Performance Problem in using the BSEG table - Required alternative