I would like to get customer address (street) from one table (kna1) when customer partner role is "WE" in other table (vbpa).
I've done it like this however it returns completely different address from wrong customer. What am I doing wrong?
SELECT SINGLE stras
FROM kna1
INNER JOIN vbpa ON (vbpa-kunnr)
WHERE parvw EQ 'WE'
INTO @zadrwe.
Thank you.