Code inspector warning message

[Former Member]

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

[dirk_wittenberg]

Hi Thomas,

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

Regards,

Dirk

[Former Member]

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

[Kartik2]

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

[Former Member]

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

[Kartik2]

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

[Former Member]

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.

[Former Member]

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

[Kartik2]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

Any one have th answer?