topic Re: Common Message when i use to code inspector before release in Application Development and Automation Discussions

Common Message when i use to code inspector before release

Former Member — Wed, 30 Apr 2008 06:00:58 GMT

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

Re: Common Message when i use to code inspector before release

nikhil_chitre — Wed, 30 Apr 2008 06:09:01 GMT

Hi,

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

try including this field..

Regards,

Nikhil

Re: Common Message when i use to code inspector before release

Former Member — Wed, 30 Apr 2008 06:12:02 GMT

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

Re: Common Message when i use to code inspector before release

Former Member — Wed, 30 Apr 2008 06:12:57 GMT

+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 = ''.+

Re: Common Message when i use to code inspector before release

nikhil_chitre — Wed, 30 Apr 2008 06:38:43 GMT

Hi,

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

Re: Common Message when i use to code inspector before release

Former Member — Wed, 30 Apr 2008 06:42:34 GMT

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

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

Re: Common Message when i use to code inspector before release

nikhil_chitre — Wed, 30 Apr 2008 06:44:58 GMT

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