can any one tell y tihs join statment is not working the conditions are clearly given in the code itself
SELECT *
INTO TABLE i_main
FROM bkpf as a
INNER JOIN rbkp as B
ON axblnr = bxblnr
AND agjahr = bgjahr and
abudat = bbudat
INNER JOIN ekbe as c
ON cbelnr = bbelnr
AND cgjahr = bgjahr
INNER JOIN ekbz as d
ON dbelnr = cbelnr
AND dgjahr = cgjahr
WHERE abukrs in bukrs and abudat in budat and ablart in ('RD' , 'RE') AND CBEWTP = 'Q'
AND D~BEWTP = 'M'.
LOOP AT I_MAIN.
WRITE:/I_MAIN-BELNR.
ENDLOOP.
Add a comment