JTL_DirectTableQuery("SELECT SUBSTRING(ta.cArtNr + SUBSTRING(REPLICATE(' ', 100),1,100 - LEN(ta.cArtNr)),1,10) , SUBSTRING(tab.cName + SUBSTRING(REPLICATE(' ', 255),1,255 - LEN(tab.cName)),1,40) , CAST(Round(ta.fVKNetto,2) AS DECIMAL(10,2))
FROM tartikel AS ta LEFT JOIN tArtikelBeschreibung AS tab ON tab.kArtikel=ta.kArtikel AND tab.kSprache=1
WHERE tab.kPlattform=1 AND ta.kVaterArtikel="+ ToString$ (Preislistenartikel.InterneArtikelnummer),' ','¶')