SELECT cust~customid cust~vorname cust~nachname
adr~addressid adr~ort adr~plz adr~strasse 
INTO CORRESPONDING FIELDS OF TABLE lt_vca 
UP TO 2 ROWS 
FROM ( zsch017customer AS cust 
INNER JOIN zsch017address AS adr
ON cust~customid = adr~customid )
WHERE cust~customid = pa_cust
AND adr~addressid IN so_adr
ORDER BY cust~customid adr~plz ASCENDING.