performance issue

hi chary the select sequence of fields should be according to the table

just like this below...

SELECT bsis_{bukrs bsis}gjahr bsis_{belnr bsis}budat bsis_{bldat bsis}xblnr bsis~blart .......... and so on

so change the sequence.. and try

<b>IS UR PROBLEM SOLVED? IF NOT PLZ LET ME KNOW</b>

Regards

- Gopi

Message was edited by: Gopi Narendra

Hi Chary,

Try this

SELECT

bukrs

hkont

augdt

augbl

zuonr

gjahr

belnr

buzei

budat

bldat

WAERS

xblnr

blart

shkzg

dmbtr

wrbtr

sgtxt

aufnr

kostl

dmbe2

prctr

zztitle

zzterr

FROM bsis

into table ITAB_BSIS "Declare an Internal table with

"all above selected fields

WHERE bukrs IN so_bukrs

AND hkont = so_hkont

AND augdt = so_augdt

AND gjahr = so_gjahr

AND belnr = so_belnr

AND budat = so_budat

AND blart = so_blart

AND xblnr = so_xblnr

AND bldat = so_bldat

AND zztitle = so_title

AND zzterr = so_terr

AND kostl = so_kostl

AND prctr = so_prctr

AND aufnr = so_aufnr.

if not ITAB_BSIS[] is initial.

select BUKRS BELNR GJAHR bvorg bstat waers hwaer hwae2 cpudt

from bkpf

into table ITAB_BKPF "Declare an Internal table with

"all above selected fields

for all entries in ITAB_BSIS

where bukrs = ITAB_BSIS-bukrs

and belnr = ITAB_BSIS-belnr

and gjahr = ITAB_BSIS-gjahr

AND cpudt = so_cpudt

AND bvorg = so_bvorg.

endif.

Hope this will resolve your problem.

Please assign points if the above solution is help full to you.

Regards,

Mohammad

Message was edited by: SAP User

Message was edited by: SAP User

If so_hkont is empty, it will have to read the entire table (BSIS). Try it with a small range. I think that'll be pretty quick.

Rob

PS - you'll probably get more response if you mark this as a question.

Message was edited by: Rob Burbank

Hi

select bukrs belnr

from bkpf

into table i_bkpf "declare an internal table

where gjahr in so_gjahr.

Select bsis data based on i_bkpf.

Hope it helps