Wie wärs damit:

select lbfirm, lbwknr, lbtenr, max(lbdate)
from lgbw
where ... lbbwsl='xx'
group by lbfirm, lbwknr, lbtenr