Improve select query performence.

[Former Member]

Hi Guru's,

I want to improve my code performence please can any one help me in this.

I reten my select statement like..

SELECT mandt bukrs hkont gjahr belnr buzei budat shkzg gsber dmbtr

wrbtr sgtxt aufnr kostl bstat prctr fistl segment

FROM bsis INTO TABLE it_bsis

FOR ALL ENTRIES IN it_final

WHERE bukrs EQ it_final-bukrs

AND hkont EQ it_final-sakn1.

IF sy-subrc = '0'.

SELECT bukrs hkont gjahr belnr buzei kkber vbeln FROM bsid INTO TABLE it_bsid

FOR ALL ENTRIES IN it_bsis

WHERE bukrs EQ it_bsis-bukrs

AND belnr EQ it_bsis-belnr

AND gjahr EQ it_bsis-gjahr.

for this any other way to improve select performence.

Tks,

Moderator message - Please see before posting - post locked

Edited by: Rob Burbank on Jan 5, 2010 10:34 AM

[Former Member]

Hi Guru's,

I want to improve my code performence please can any one help me in this.

I reten my select statement like..

SELECT mandt bukrs hkont gjahr belnr buzei budat shkzg gsber dmbtr

wrbtr sgtxt aufnr kostl bstat prctr fistl segment

FROM bsis INTO TABLE it_bsis

FOR ALL ENTRIES IN it_final

WHERE bukrs EQ it_final-bukrs

AND hkont EQ it_final-sakn1.

IF sy-subrc = '0'.

SELECT bukrs hkont gjahr belnr buzei kkber vbeln FROM bsid INTO TABLE it_bsid

FOR ALL ENTRIES IN it_bsis

WHERE bukrs EQ it_bsis-bukrs

AND belnr EQ it_bsis-belnr

AND gjahr EQ it_bsis-gjahr.

for this any other way to improve select performence.

Tks,

Moderator message - Please see before posting - post locked

Edited by: Rob Burbank on Jan 5, 2010 10:34 AM

[Former Member]

hi

You can pass the blank range BSIS primary keys.

(HKONT,AUGDT,AUGBL,ZUONR,GJAHR,BELNR,BUZEI)

use the ranges in where condition.

ex:

Rnages r_belnr for bsid-belnr.

select.....

where belnr in r_belnr.

Edited by: dharma raj on Jan 5, 2010 5:08 PM

[Former Member]

Hi,

If in bsis select you get a document with more than one position, i think in bsid select you are doing duplicates selects because you have more than one row in it_bsis with the same key bukrs/belnr/gjahr. Use other table without this duplicates for bsid select...