Skip to Content
0
Former Member
Nov 20, 2012 at 04:28 PM

left() in CE_FUNCTIONS

20 Views

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