My select statment as
select ebelnr, htariftyp, csparte, cvertrag, cvkont, mbelzart, cbegabrpe, cendabrpe, sum (mv_abrmenge, mn_abrmenge), e~budat
from erchc as e
join dberchz1 as m
on ebelnr = mbelnr
join erch as c
on mbelnr = cbelnr
join ever as r
on cvertrag = rvertrag
join eanlh as h
on hanlage = ranlage
where h~tariftyp in @p1@
and c~erchc_v = 'X'
and c~simulation = space
and c~tobreleasd = space
and e~budat in @p2@
and e~simulated = space
and e~tobreleasd = space
and m~belzart in @p3@
and m~belnr in @p4@
Bluesky
