Hi @ all,
we have the following sql statement in a calculation view.
var_out = select vbep.mandt, vbep.vbeln, vbep.posnr, max(left(mbdat,6)) as mbdatmax, sum(bmeng) as bmeng, vbep.lifsp
from "FP3040"."VBEP" vbep
group by vbep.mandt,
vbep.vbeln,
vbep.posnr,
vbep.lifsp
Would it be possible to receive the same result with CE_Functions?
We tried the following but it seems that the combination of max(left()) is not feasable within CE_AGGREGATE().
var_table = CE_COLUMN_TABLE("FP3040"."VBEP", ["MBDAT", "BMENG", "MANDT", "VBELN", "POSNR", "LIFSP"]);
var_out = CE_AGGREGATION(:var_table, [max(left("MBDAT", 6)), sum("BMENG")],["MANDT","VBELN","POSNR","LIFSP"]);
Thanks a lot for you input.
Flo