Inner Join

SELECT t685~kschl t682z~kozgf t682i~kotabnr t682z~kvewe t682z~kappl t682z~kolnr zaehk zifna
FROM t685
INNER JOIN t682i
ON t685~kvewe eq t682i~kvewe and
t685~kappl eq t682i~kappl and
t685~kozgf eq t682i~kozgf
INNER JOIN t682z
ON t682i~kvewe eq t682z~kvewe and
t682i~kappl eq t682z~kappl and
t682i~kozgf eq t682z~kozgf and
t682i~kolnr eq t682z~kolnr
INTO TABLE gt_t682
WHERE t685~kvewe = 'A' AND " 'A' - Pricing
t685~kappl = 'V' AND " 'V' - Sales/Distribution
t685~kschl IN gr_kschl AND
t682z~qustr NE ''.