topic Re: Issue while Using Table CKIS With MBEW in Application Development and Automation Discussions

Issue while Using Table CKIS With MBEW

Former Member — Fri, 28 Feb 2014 11:42:57 GMT

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.

Re: Issue while Using Table CKIS With MBEW

deependra_shekhawat3 — Fri, 28 Feb 2014 11:54:31 GMT

Hi Shaikh Ali,

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

If not please do it first.

Thanks

Deependra

Re: Issue while Using Table CKIS With MBEW

Former Member — Fri, 28 Feb 2014 12:13:38 GMT

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.

Re: Issue while Using Table CKIS With MBEW

Former Member — Mon, 24 Mar 2014 07:00:53 GMT

hi friend's

issue was closed.

Regard's,

shaikh khalid.

Re: Issue while Using Table CKIS With MBEW

Former Member — Mon, 24 Mar 2014 08:42:00 GMT

and how did you close it?