Skip to Content
0
Former Member
Dec 06, 2006 at 11:10 PM

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;