How can I apply the CEIL in an ABAP SQL statement?, for example, first I want to make a SUM and then I'd like to do a CEIL in the same column.
START-OF-SELECTION.
IF so_auart[] IS INITIAL. SELECT A~Material, "A~FecCreacion, A~ClaseDoc, SUM( A~CantPedidoUMV ) AS CantPedidoUMV, SUM( B~StockLibreUMV ) AS StockLibreUMV, B~UMVenta INTO TABLE @it_data FROM ZMATITEST2 AS A LEFT JOIN ZMARDV002 AS B ON B~Material = A~Material WHERE FecCreacion IN @so_erdat GROUP BY A~Material, "A~FecCreacion, A~ClaseDoc, B~UMVenta.