Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance Issue:Select statement

Hello Experts,

Plz suggest how can i improve the performance of both these queries.

select abelnr agjahr abldat agsber ablart abudat admbtr axblnr

ashkzg awerks agsber abukrs

into corresponding fields of table i_bsis_main

from bsis as a

where a~bukrs eq p_bukrs and

a~hkont eq p_hkont and

a~budat <= s_budat and

( a~belnr in s_fi_doc ).

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

select abelnr agjahr abldat agsber ablart abudat admbtr axblnr

ashkzg awerks agsber abukrs

into corresponding fields of i_bsis_main

from bsas as a

where a~bukrs eq p_bukrs and

a~hkont eq p_hkont and

a~budat <= s_budat and

a~augdt > s_budat and

a~augbl <> ' ' and

( a~belnr in s_fi_doc ).

append i_bsis_main.

endselect.

PLz suggest.

Ravi

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question