Ok,

If you create an index on Lotno,Kapan and Position it should improve the selection in the where condition.

where Lotno=@Lotno

and Kapan=@Kapan

and Position='CURRENT'

Ensure Lotno is the first key column in the index:

create non-clustered index IX_Entry_Jangad_Lot_index1 on Entry_Jangad_Lot(Lotno,Kapan,Position)