SELECT KONP~MANDT KONP~KNUMH[...] KONH~ERDAT KONH~KVEWE KONH~KOTABNR KONH~KAPPL [...]
INTO [...]
FROM KONH
INNER JOIN KONP
ON 
KONP~KNUMH = KONH~KNUMH
WHERE 
[...] and [...]
ORDER BY KONH~MANDT KONH~KNUMH KONH~ERNAM 
KONP~MANDT KONP~KNUMH KONP~KOPOS .