SELECT
Dense_RANK() Over (Order by pkn.name3 asc) As Belegnummer,
Row_number () OVER (Partition BY pkn.name3 Order by (rko.belegnr)asc) AS Position,
ART.Bez3 as Teil_und,
REPLACE (RPO.Mg,'.',',') as Menge,
Case
When rpo.Me = 'STK' then 1
When rpo.Me = 'LFM' then 26
When rpo.Me = 'MIN' then 28
end,
'?' AS Lagerort,
'14' AS Lieferbedingung,
'' AS Gewicht,
'' AS Verpackungsgewicht,
'' AS Wunschtermin,
''AS Liefertermin,
'' AS TransPortZeitAenderSelect,
'' AS Zeiteinheit_tt,
Ltrim (AKO.FremdNr) as Bezeichnung_und,
'' AS Bezeichnung_und,
'' AS Bezeichnung_und,
'#'+AKO.BelegNr as Bezeichnung_und,
REPLACE (RPO.Preis,'.',',') as Einzelpreis,
'' AS wertm_R_Z,
'' AS wertm_R_Z,
'' AS wm_Rab_ZuArt,
'' AS wm_Rab_ZuArt,
'' AS R_Z_und,
'' AS R_Z_und,
'' AS R_Z_und,
'' Rab_ZuArt_und,
'' Rab_ZuArt_und,
'' Rab_ZuArt_und,
PKN.Name3 as GWName,
RKO.Belegnr as ABC_ReNr,
LSK.BelegNr as LieferscheinNr,
AKO.Info
FROM OpAusgangsrechnung RKO WITH (NOLOCK)
INNER JOIN OpArPos RPO WITH (NOLOCK) ON RPO.ArId = RKO.ArId
INNER JOIN OpArArt RCA WITH (NOLOCK) ON RCA.ArtId = RKO.ArArtId
LEFT OUTER JOIN OpKunde KUN WITH (NOLOCK) ON KUN.KundId = RKO.AuftraggeberId
INNER JOIN OpKunde KRE WITH (NOLOCK) ON KRE.KundId = RKO.FaktEmpfaengerId
INNER JOIN OpKunde KRG WITH (NOLOCK) ON KRG.KundId = RKO.ReguliererId
LEFT OUTER JOIN OpArtikel ART WITH (NOLOCK) ON ART.ArtikelId = RPO.ArtikelId
LEFT OUTER JOIN OpAuftrag AKO WITH (NOLOCK) ON AKO.AufId = RPO.AufId
LEFT OUTER JOIN OpLfsPos LSP WITH (NOLOCK) ON LSP.PosId = RPO.LfsPosId
LEFT OUTER JOIN OpLieferschein LSK WITH (NOLOCK) ON LSK.LfsId = LSP.LfsId
INNer Join OpPerson PKN WITH (NOLOCK) ON PKN.PersonId = LSK.WarenEmpfaengerId
LEFT OUTER JOIN OpKostenstelle KST WITH (NOLOCK) ON KST.KostenstellenId = RPO.KostenstellenId
WHERE (Rko.belegnr = 107141) and (AKO.Info is not null)
order by pkn.name3 asc