Skip to Content
0
Jan 21, 2013 at 11:40 AM

No first field of table index in where condition

295 Views

Hi Friends,

I have got the following error when i am running code inspector, " No first field of a table index in WHERE Condition" My code is like below:

if git_cabn is not initial.

select objek

atinn

atwrt from ausp

into table git_ausp

for all entries in git_cabn

where "objek BETWEEN c_2ser_zero AND c_2ser_nine AND

atinn = git_cabn-atinn.

endif.

loop at git_ausp into gwa_ausp.
gwa_kna2-kunnr = gwa_ausp-atwrt.
call function 'CONVERSION_EXIT_ALPHA_INPUT'
exporting
input = gwa_kna2-kunnr
importing
output = gwa_kna2-kunnr.

if git_ausp is not initial.
select atinn
atzhl
atwrt from cawn
into table git_cawn
for all entries in git_ausp
where atinn = git_ausp-atinn
and atzhl in r_atzhl
and adzhl in r_adzhl.
* AND atwrt = git_ausp-atwrt.
sort git_ausp by atwrt.
loop at git_cawn into gwa_cawn.
read table git_ausp into gwa_ausp with key atwrt = gwa_cawn-atwrt
binary search.
if sy-subrc ne 0.
delete table git_cawn from gwa_cawn.
endif.
endloop.
endif.

if git_cawn is not initial.
select atinn
atzhl
spras
atwtb from cawnt
into table git_cawnt
for all entries in git_cawn
where atinn = git_cawn-atinn
and atzhl = git_cawn-atzhl.
endif.

Please help me out for the above issue.

Thanks in advance.

Viji.

Moderator Message: Please do some research before posting

Message was edited by: Kesavadas Thekkillath