topic Code Inspector: Common Message in Application Development and Automation Discussions

Code Inspector: Common Message

Former Member — Wed, 30 Apr 2008 06:35:06 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: Code Inspector: Common Message

Sm1tje — Wed, 30 Apr 2008 06:40:42 GMT

It just mean that you are doing a select on large table without using primary index (key).

If there is no other way, ignore this message. But always try to use the key (as many fields from the key as possible, or secondary index) when doing a select on a (large) table for performance reasons.

Re: Code Inspector: Common Message

Former Member — Wed, 30 Apr 2008 06:41:46 GMT

Hello Anshuman

You are getting error because you are not using the first field of the table in your where clause of Select. To overcome this error see whether you can use the first first in the Where clause else you can hide using the pseudo comment like # EC NO_FIRST.

Regards

~ Ranganath

Re: Code Inspector: Common Message

Former Member — Wed, 30 Apr 2008 06:48:48 GMT

Hi Thanx for ur answer,

but what is # EC NO_FIRST.

where i use?????

Re: Code Inspector: Common Message

Sm1tje — Wed, 30 Apr 2008 07:31:27 GMT

ABAP STATEMENT. "EC NO_FIRST

In general you can put these messages at the end of a statement and use the double quotes (") followed by the comment EC NO_FIRST.

In general these statements will be ignored by the check, but the problem remains. You are not using the (primary) key. But like I said, in some cases there is no other way.