topic Re: Code inspector warning message in Application Development and Automation Discussions

Code inspector warning message

Former Member — Tue, 24 Apr 2012 08:10:06 GMT

Hi Experts,

Code inspector throws warning message "Name of table in SELECT condition : BNKA". How to correct this warning message. My coding is

select single * from bnka into wa_bnka

where banks eq p_banks

and bankl eq p_bankl.

Thanks in advance,

Thomas

Re: Code inspector warning message

dirk_wittenberg — Tue, 24 Apr 2012 08:17:42 GMT

Hi Thomas,

which tests are you running? The standard from within the editor ?

Regards,

Dirk

Re: Code inspector warning message

Former Member — Tue, 24 Apr 2012 08:36:21 GMT

Hi Dirk,

Running in Tcode SCI . How to correct that warning message. Also it throws warning message for selection screen fields validation that "key field "VBLNR" doesn't check the equality.

My coding is

SELECT SINGLE laufi FROM reguh INTO lv_laufi

WHERE laufd eq p_laufd

and laufi EQ p_laufi.

Thanks

Re: Code inspector warning message

Kartik2 — Tue, 24 Apr 2012 08:46:01 GMT

Dear Kelvin,

While using SELECT SINGLE, you have to provide all the key fields in the where clause. so that the query will result only in a single record. Thank you.

Regards,

kartik

Re: Code inspector warning message

Former Member — Tue, 24 Apr 2012 10:01:58 GMT

Hi Karti,

Code inspector throws warning message "Name of table in SELECT condition : BNKA". Why this error is coming and how to correct this warning message. My coding is

select single * from bnka into wa_bnka

where banks eq p_banks

and bankl eq p_bankl

Thanks

Re: Code inspector warning message

Kartik2 — Tue, 24 Apr 2012 10:13:00 GMT

Dear Kelvin,

Here you have used both the key fields of the table in your query, I do not see any problem with the query at all. Can you just post your data declaration of variables.

Regards,

kartik

Re: Code inspector warning message

Former Member — Tue, 24 Apr 2012 11:05:54 GMT

Thanks Karthi. These are the declarion part. what is the reason for this error and how to correct it.

TYPES: tt_bnka TYPE STANDARD TABLE OF bnka

WITH NON-UNIQUE DEFAULT KEY

INITIAL SIZE 0.

DATA: tt_bnka TYPE STANDARD TABLE OF bnka

INITIAL SIZE 0,

wa_bnka TYPE bnka.

data: gv_banks type banks,

gv_bankl type bankl.

Parameters: p_banks like gv_banks,

p_bankl like gv_bankl.

Re: Code inspector warning message

Former Member — Tue, 24 Apr 2012 11:17:04 GMT

Hi Karti,

Under one transport request number, can we create one program, five tables? If yes..can we transport it together with the one transport request number?

Package also need to be included under the same transport request number?

Thanks

Re: Code inspector warning message

Former Member — Tue, 24 Apr 2012 11:33:16 GMT

For me, this is an information message. Are you sure it's being reported as an Error? Which column is it in in Code Inspector, red, yellow or green? The message comes from General Checks, Table Names in Code Inspector variant.

Re: Code inspector warning message

Former Member — Tue, 24 Apr 2012 11:49:02 GMT

Yes.. It is a Information Message in green color. The same information messages comes 20 times for 20 differnent select statements. How to avoid/solve or suppress this information message..?

Under one transport request number, can we create one program, five tables? If yes..can we transport it together with the one transport request number?

Package also need to be included under the same transport request number. please resolve it.

Re: Code inspector warning message

Kartik2 — Tue, 24 Apr 2012 12:06:24 GMT

Dear Kelvin,

Yes, you can create any number of objects under a single transport request and all will be transported together. So you can have one program and 5 tables in a single TR.

Thanks and regards,

kartik

Re: Code inspector warning message

Former Member — Fri, 06 May 2016 10:08:04 GMT

Any one have th answer?