1. select --distinct LPBELNR,
2. *
3. --BPSTUECK,
4. --aranummer,
5. --BPPOSNR,
6.  
7. from mention.dbo.ael ael
8. left join mention.dbo.AELLIEF lief on ael.ARIDNR=lief.ALIDNR and lief.ALMANKEY=1
9. left join mention.dbo.BESTLP kp on ael.ARIDNR=kp.LPBELNR and kp.LPMANKEY=1
10. left join mention.dbo.BESTLK rk on kp.LPBELNR=rk.LBBELNR
11. where lief.ALLNUMMER='71000001'
12. --and BSBELTYP='B' and bsoffen<>'R'