topic Re: performance wise in Application Development and Automation Discussions

performance wise

Former Member — Tue, 29 Apr 2008 07:32:20 GMT

Hi experts,

SELECT A_{AUFNR A}BUKRS A_{WERKS A}KOKRS A~OBJNR

A_{PRCTR B}GSTRP B_{GSTRS C}MATNR INTO TABLE

GT_ORDER FROM AUFK AS A INNER JOIN AFKO AS B ON A_{AUFNR = B}AUFNR

INNER JOIN AFPO AS C ON A_{AUFNR = C}AUFNR WHERE A~AUFNR IN SO_AUFNR

AND A_{BUKRS IN SO_BUKRS AND A}PRCTR IN SO_PRCTR AND A~WERKS IN SO_WERKS.

IF GT_ORDER IS NOT INITIAL.

SELECT

A~KOKRS

A~BELNR

B~BUZEI

B~WOGBTR

B~OBJNR

B~KSTAR

B~OWAER

A~BUDAT

B~BELTP

FROM COBK AS A INNER JOIN COEP AS B

ON A_{KOKRS = B}KOKRS AND

A_{BELNR = B}BELNR INTO TABLE GT_COVP FOR ALL ENTRIES IN GT_ORDER

WHERE OBJNR = GT_ORDER-OBJNR AND

OWAER = 'INR' AND

KSTAR IN R_COSTGL AND

BUDAT IN SO_BUDAT.

this is the code i have written . in development it is taking less than one minute but in quality it is taking to

too much time . can any help me to reduce the time in quality.

thanks & regards

suri

Re: performance wise

Former Member — Tue, 29 Apr 2008 07:50:53 GMT

goto st05 activate the trace.

then run your report.

deactivate the trace. then check when select query is made is the system using any indexes if no then adjust your query as to use indexes or create new if not available.

But be carefull in making indexes since to many indexes may slow down updation and insertion.

Regards

Khusro Habib

Re: performance wise

Former Member — Tue, 29 Apr 2008 07:53:45 GMT

HI Suresh,

I would suggest one correction:

IF GT_ORDER[] IS NOT INITIAL.

Because your statement checks for the header line & this one check for the table.

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: performance wise

Former Member — Tue, 29 Apr 2008 08:01:24 GMT

IF GT_ORDER[] IS NOT INITIAL.

SELECT

A~KOKRS

A~BELNR

A~BUDAT

B~BUZEI

B~WOGBTR

B~OBJNR

B~KSTAR

B~OWAER

B~BELTP

FROM COBK AS A INNER JOIN COEP AS B

ON A_{KOKRS = B}KOKRS AND

A_{BELNR = B}BELNR INTO TABLE GT_COVP FOR ALL ENTRIES IN GT_ORDER

WHERE OBJNR = GT_ORDER-OBJNR AND

OWAER = 'INR' AND

KSTAR IN R_COSTGL AND

BUDAT IN SO_BUDAT.

Better if OBJNR is the first field in internal table GT_ORDER ..

also sort GT_ORDER by OBJNR ...