Common Message when i use to code inspector before release

[Former Member]

Dear all,

when i m going to release driver program(any).

i used....

1) se09

2) click on related request.

3) then check tab

4) then select or double click on third option "Code Inspector"

5) Performnace check

always many error message are occured.

like:

Program ZPPR020_DAILY_REPORT Include ZPPI020_VORNR_SELECTION Row 34 Column 8

Large table PLAS: No first field of a table index in WHERE

condition

my query is:

SELECT PLNTY PLNNR PLNAL PLNFL PLNKN ZAEHL LOEKZ FROM PLAS

INTO CORRESPONDING FIELDS OF TABLE I_PLAS

FOR ALL ENTRIES IN I_CAUFV

WHERE PLNNR = I_CAUFV-PLNNR

AND PLNAL = I_CAUFV-PLNAL

AND LOEKZ = ''.

above type of error is always occured for any executable program

plz reply me as soon as possible.

thanx in advance

[nikhil_chitre]

Hi,

It appears that the key PLNTY field of table PLAS is not in your select Query.

try including this field..

Regards,

Nikhil

[Former Member]

hi nikhil,

but look at my written query. i have already mentioned this field in query.(below)

this type of message occure for every program

[Former Member]

+SELECT PLNTY PLNNR PLNAL PLNFL PLNKN ZAEHL LOEKZ FROM PLAS+

+INTO CORRESPONDING FIELDS OF TABLE I_PLAS+

+FOR ALL ENTRIES IN I_CAUFV+

+WHERE PLNNR = I_CAUFV-PLNNR+

+AND PLNAL = I_CAUFV-PLNAL+

+AND LOEKZ = ''.+

[nikhil_chitre]

Hi,

In meant include in the where Clause...!!!

[Former Member]

so, is this necessary to take primary keys in where condition?

if we avoid it then what will be effect???????

[nikhil_chitre]

I does not give an syntax error.....!!! if you don't...!!

but it gives an error in code inspector...

besides this....it will also help in performnance

Edited by: Nikhil A Chitre on Apr 30, 2008 4:49 PM