cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

Hi,

I have an Excel formula that I want to convert to an SQL formula so I can use it in a query.

The Excel formula is:

=D2*CEILING((B2-C2)/D2;1)

I thought I could use RoundUp, but that funcation is not available in SAP.

The formula in SAP looks like this:

t0.purpackun*RoundUp((T1.[Maxstock]-((t1.onhand-t1.iscommited)+ t1.onorder))/t0.purpackun,1) as 'Order quantity',

0 Likes
View Entire Topic
RaymondGiuseppi
Active Contributor
0 Likes

Doesn't (recent versions of) Abap SQL handle a CEIL( sql_exp ) function?