Skip to Content
0
Former Member
Apr 11, 2008 at 12:59 PM

ST05 Trace on a select query on BSEG table

182 Views

hi all,

this is my select query on table BSEG table:

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

SELECT bukrs

belnr

gjahr

buzei

KOART

mwskz

kostl

lifnr

aufnr

werks

ebeln

txjcd

projk FROM bseg

INTO TABLE i_bseg

FOR ALL ENTRIES IN i_ad_tab

WHERE bukrs EQ i_ad_tab-bukrs AND

belnr EQ i_ad_tab-belnr AND

gjahr EQ i_ad_tab-gjahr.

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

when i m doing SQL trace ST05 on this query and in the detail statement showed the following query

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

SELECT

"MANDT" , "BUKRS" , "BELNR" , "GJAHR" , "PAGENO" , "TIMESTMP" ,

"PAGELG" , "VARDATA"

FROM

"RFBLG"

WHERE

"MANDT" = ? AND "BUKRS" = ? AND "BELNR" = ? AND "GJAHR" = ?

ORDER BY

"MANDT" , "BUKRS" , "BELNR" , "GJAHR" , "PAGENO"

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

what is RFBLG table in SE11, but could not find it.

what is RFBLG?also, the above select query giving me performance issues.. the "for all entries" clause is used as per norms...

please suggest a solution..