Skip to Content
0
Jun 02, 2015 at 12:42 PM

Error: Large table KNA1: No field of a table index in where condition

3225 Views

Hi All,

In my code i have written a statement to select records from KNA1 database table.

SELECT kunnr name1 name2 ort01 pstlz stras stceg FROM kna1 INTO CORRESPONDING FIELDS OF TABLE lt_data
         WHERE stceg <> ''.

I need to select all records which have a VAT number(STCEG).

I am not getting any syntax error, but when i check using code inspector i am getting 'error: Large table KNA1: No field of a table index in where condition'.

How to improve the above syntax to avoid this error?

Thanks in advance,

regards,

NarsiReddy.