I run something similar due to problems with the UBE in E811 SP1
select ilitm,illitm, imdsc1, ilmcu, sum(iltrqt),lilocn, lilotn, lipqoh
from proddta_f4111, proddta_f41021, proddta_f4101
where ilitm = liitm
and ilitm = imitm
and lilocn = illocn
and lilotn = illotn
and limcu = ilmcu
and ilmcu = ' 160'
group by ilitm, illitm, imdsc1, ilmcu,lilocn, lilotn, lipqoh
having sum(iltrqt) <> lipqoh