Code Inspector Errors

[Former Member]

Hi,

I have to release a task to the quality system. I am performing the code inspector check and it si giving some errors like

' Large table RESB: No field of a table index in WHERE condition'.

The scenario is that, first i am fetching data from the AUFK table and then firing a SELECT query on RESB table as:

SELECT <f1>

<f2>

..

....

<fn>

INTO TABLE it_resb

FROM resb

FOR ALL ENTRIES IN it_aufk

WHERE aufnr = it_aufk-aufnr

Can anyone suugest how to rectifi this? I can suppress this message by adding "#EC CI_NOFIELD, but i would like to know is there any other way.

Regards

s.a.k

[Former Member]

>

> ' Large table RESB: No field of a table index in WHERE condition'.
> The scenario is that, first i am fetching data from the AUFK table and then firing a SELECT query on RESB table as:
>     SELECT <f1>
>                  <f2> 
>                  ....
>                  <fn> 
>       INTO TABLE it_resb
>       FROM resb
>       FOR ALL ENTRIES IN it_aufk
>       WHERE aufnr = it_aufk-aufnr
> Regards
> s.a.k

this error can only be eliminated by passing key fields to the where condition. if you do not have any option to pass the key fields you have hide using the pseudo code.

click the info button before the error to see the description in detail

[Former Member]

Hello

Create secondary index for table RESB on field AUFNR. This is correct error in code inspector and increase performance of your report.

[Former Member]

Hi Dzed,

RESB table is SAP delivered table.

Can i make changes in this table?

Will it affect the other programs, in case i make any chnages to this table.

Please advice.

Regards

s.a.k

[Former Member]

Hello

You do not need make changes in RESB. You need create secondary index (it is not will change table).

Search SDN for "create index". You will have a lot of information about this.

[rainer_hbenthal]

You didnt used any of the key fields, resultung in a full table space scan with bad performance.

But this should not be an error. Talk to your database administrators if this is acceptable or not.

[Former Member]

Hi All,

Thank you all for your responses..:)

Regards

s.a.k

[Former Member]

I am facing an issue in code inspector check - warnings

[Former Member]

yes,

and use pseudo comment. no harm.

just for performance issue that warning is coming.

you can also avoid this by creating an secondary index as suggested.

[Former Member]

Hi All,

Reopening the thread as I am stuck.

Continuing with the Code inspector checks, I am getting some 'warnings' like:

Function <Function module> Row 1477 Column 0

The type of the VALUE parameter "RA_ERDAT" contains one or

more internal tables. No static write-access was found (refer

to test documentation)

The RA_ERDAT is a range table which i am using in my function module.

The problem is that the system gives a short dump when I click on the 'Info' button stating:

No space available for EXPORT/IMPORT data.

So can any one provide me the pusedocode comment for this to supress this message..:)

Also the row and column number points to the last line of my program, so please suggest where will i have to add the comment?

Regards

s.a.k

[Former Member]

Hi,

Any inputs on this..?

Regards

s.a.k

[Former Member]

put it in the tables parameter.

by the way are not you getting any pseudo comment in code inspector? just after info button there would be a chat (talk) kind of button which shows the pseudo comment.

[Former Member]

Hi Soumyapraksh,

Thanks for that.. I will test by putting the range tables in the TABLE tab.

I mentioned in my post, that when i press the documentation button, the system gives a short dump. Thats the reasons why I am asking.

Thanks for you help once again..will let you know if it works..:)

Regards

s.a.k

[Former Member]

what does the dump say?

[Former Member]

Hi Soumyapraksh,

Thanks a lot..:) it solved the problem..i put all the importing parameters in he tables tab. Now there is no error..:)

Thanks once again..:)

Regards

s.a.k