topic Re: Code Inspector in Application Development and Automation Discussions

Code Inspector

Former Member — Thu, 04 Oct 2007 11:37:21 GMT

Hi Friends,

I have written a program to generate a report using the table EKBE and during releasing to transport (SE10), I am getting the following Errors in the Code Inspector.

1. Message code 0502.

Large table EKBE. No field of table index in where condition.

2. Message code 0503.

Prog xxxxxxx include xxxxxx Row xxx column xx.

Large table EKBE. No first field of a table indes in where condition.

Kinldy could you explain me what is index problem and how to do the same.

TIA.

Regards,

Mark K

Re: Code Inspector

Former Member — Thu, 04 Oct 2007 11:41:22 GMT

The message 1 implies

In coding reading large table EKBE without any where statement which is very time consuming.

The message 2 implies

In reading large table EKBE, first field of indexes (primary key) is not being used in where statement.

Hope this helps

anya

Re: Code Inspector

Former Member — Thu, 04 Oct 2007 11:44:14 GMT

Have a look in your WHERE condition of your select statements. There is no field of the primary key or from a index of ekbe. So your response time will be bad, try to select the fields

EBELN

EBELP

ZEKKN

VGABE

GJAHR

BELNR

BUZEI

which are the primary key of table ekbe. (Fields that are check in the column key in transaction se11/se12)

Kind regards

Matthias

Re: Code Inspector

Former Member — Thu, 04 Oct 2007 11:45:09 GMT

just in that where condition put one primary field so that this will remove

that error

Re: Code Inspector

Former Member — Thu, 04 Oct 2007 11:47:53 GMT

your SELECT is not index supported and therefore slow if the table is large.

That is what the code inspector tells you, either accept it, there youi can add an escape seqeuence to override the code inspector or change it, i.e. specify an index field, better a first index field in the WHERE condition or create an index with your fields of the WHERE condition.

Siegfried

Re: Code Inspector

Former Member — Thu, 04 Oct 2007 12:10:25 GMT

Could you pls tell me as to how to create index.

Regards,