Issue while Using Table CKIS With MBEW

[Former Member]

Hi All,

I have created a 'Z' Report for MB51 some of table MBEW and CKIS but I showing error while I am doing Performance check and code inspector it showing error like this ( Large table CKIS: No first field of a table index in WHERE Condition) as well as I try to create a secondary index but after creation it showing index does not exist in database table with inactive status , the code which I wrote for this are shown below

select kalnr kalka kadky bwvar werks matnr gpreis

  from ckis into table tt_ckis

  for all entries in tt_mbew

  where kalnr = tt_mbew-kaln1

  and  kadky in so_budat

  and  werks = tt_mbew-bwkey

  and  matnr = tt_mbew-matnr.

  sort tt_ckis by kadky.

I fetch data For mbew based on Matnr and Bwkey.

I want all data from ckis based on kalnr and kadky.it showing error large table ckis..

Regard's,

Shaikh Ali.

[deependra_shekhawat3]

Hi Shaikh Ali,

Have you tried to activate and adjust  index in database using Se14?

If not please do it first.

Thanks

Deependra

[Former Member]

Hi Deependra,

Yes I did now it got active.

just go through to my code and u will find that Both Table don't have matching P. Key.

like Ckis-Kalnr is P.Key and MBEW-Matnr is P.Key how would do?

Regard's shaikh ali.

[Former Member]

hi friend's

issue was closed.

Regard's,

shaikh khalid.

[Former Member]

and how did you close it?