how would you write tthis oracle sql in ABAP. Thank you verry verry much
48 Views
SELECT
to_char(sum(dmbtr)),s.budat,shkzg,hkont
FROM
sapr3.bsas s,
sapr3.bkpf k
WHERE
s.belnr=k.belnr AND s.gjahr=k.gjahr AND s.bukrs=k.bukrs AND k.bukrs='02' AND k.gjahr>=EXTRACT(YEAR FROM ADD_MONTHS(SYSDATE,-12)) GROUP BY s.budat,shkzg,hkont;