topic Re: BSIS Query performance issue. in Application Development and Automation Discussions

BSIS Query performance issue.

dani_mn — Wed, 20 Dec 2006 06:27:54 GMT

HI,

our BSIS table contains almost 10 millions records, now during check printing process when we are quering BSIS table for getting cost center from the line item.

it is taking almost 30-60 seconds which is slowing the check printing process.

 SELECT single * FROM BSAK
  WHERE BUKRS = COMP AND GJAHR = YR AND AUGBL = PDOC AND BELNR <> PDOC.

  SELECT SINGLE * FROM BSIS WHERE
  BELNR =  BSAK-BELNR  AND BUKRS = COMP AND GJAHR = YR
  AND ( HKONT LIKE 'A%' OR BLART = 'RE' ).

 kostl = bsis-kostl.

for getting cost center first it picks the FI document number from BSAK using Payment document number. and then getting cost center from bsis.

Is there any alternative way of getting cost center of document skiping BSIS.

Thanks,

Re: BSIS Query performance issue.

Former Member — Wed, 20 Dec 2006 06:32:07 GMT

hi,

if you are firing this query regularly then create intex on bsis table.

performance can improve by creating index only.

regards,

raj

Re: BSIS Query performance issue.

graghavendra_sharma — Wed, 20 Dec 2006 06:34:32 GMT

I have a question here. If you are using SELECT SINGLE * ... then where from ENDSELECT came into picture?