cancel
Showing results for 
Search instead for 
Did you mean: 

Please advice for better performance of select query on CKIS table

Former Member
0 Kudos

I wrote a select query on CKIS table based on the inputs from KEKO table for which plant and material number are inputs.

Here is my select query:

SELECT bzobj kalnr kalka kadky tvers bwvar kkzma matnr werks posnr

INTO TABLE it_keko

FROM keko

WHERE werks = p_werks

AND matnr = p_matnr.

IF sy-subrc = 0.

SORT it_keko BY bzobj kalnr kalka kadky tvers bwvar kkzma.

ENDIF.

IF NOT it_keko[] IS INITIAL.

SELECT bzobj kalnr kalka kadky tvers bwvar kkzma posnr kstar

gpreis lstar vornr

INTO TABLE it_ckis

FROM ckis

FOR ALL ENTRIES IN it_keko

WHERE bzobj = it_keko-bzobj

AND kalnr = it_keko-kalnr

AND kalka = it_keko-kalka

AND kadky = it_keko-kadky

AND tvers = it_keko-tvers

AND bwvar = it_keko-bwvar

AND kkzma = it_keko-kkzma.

Please advice for better performance of this query.

Thanks in advance.

Jeevi.

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Thanks for your advices.

Former Member
0 Kudos

Hi,

Check for the indexes and add the indexes which you are using in where condition.

Regards,

Naresh.

Former Member
0 Kudos

Hi Chalasani,

Please fetch all the key fields from the csik table, LEDNR is alone missing pls add this field. Otherwise i dont find any error in your select query.

Regards,

Shobana.k

Former Member
0 Kudos

why you are retreiving the same fields from both tables.

better if you are using a join to get the details from both tables at ones that will help reducing the no of roundtrips.

try to use the join statement like this.

SELECT T1BZOBJ T1KALNR T1KALKA T1KADKY T1TVERS T1BWVAR T1KKZMA T1MATNR T1WERKS T1POSNR

T2KSTAR T2GPREIS T2LSTAR T2VORNR

INTO TABLE IT_KEKO_CKIS

FROM

KEKO AS T1 JOIN CKIS AS T2 ON

T1BZOBJ = T2BZOBJ AND

T1KALNR = T2KALNR

WHERE T1~WERKS = P_WERKS

AND T1~MATNR = P_MATNR.

Edited by: Yogananda Namala on Sep 11, 2008 4:07 PM

Former Member
0 Kudos

Hi chalasani

You can delete duplicate records from KEKO using

Delete Adjacent duplicates from it_KEKO comparing bzobj kalnr kalka kadky tvers bwvar kkzma.

before your query on CKIS, as less no of records in IT_KEKO will take lesser time for CKIS.

Regards

Rajnesh

Former Member
0 Kudos

You are all already using key fields in the where clause in both the fetch 's , it cannot be optimized better !!!!!