Numeric Functions in ABAP CDS View Entities

Business applications constantly perform numeric calculations. Whether you're calculating discounts, taxes, quantities, averages, percentages, exchange rates, or analytical KPIs, numeric operations are an essential part of almost every CDS View Entity.

Instead of retrieving raw data and performing calculations in ABAP, SAP recommends pushing these calculations to the database whenever possible. This approach allows SAP HANA to execute the logic directly, improving performance and reducing application server processing.

ABAP CDS provides several built-in numeric functions for rounding, division, absolute values, and mathematical calculations. Understanding when and how to use these functions is an important skill for every RAP and ABAP Cloud developer.

After completing this lesson, you'll understand the purpose, behavior, and limitations of the most commonly used numeric functions available in ABAP CDS View Entities.

SAP provides several built-in numeric functions for performing common mathematical operations. Each function is designed for a specific purpose and supports a defined set of data types.

The ABS() function returns the absolute value of a numeric expression by removing its sign.

abs( numeric_expression )

abs( TotalNetAmount ) as AbsoluteAmount

The CEIL() function always rounds a numeric value upward to the next whole integer.

ceil( numeric_expression )

ceil( GrossWeight ) as RoundedWeight

The FLOOR() function rounds a numeric value downward to the nearest whole integer.

floor( numeric_expression )

floor( GrossWeight ) as RoundedWeight

The ROUND() function rounds a numeric value to the specified number of decimal places. Unlike CEIL() andFLOOR(), ROUND follows normal mathematical rounding rules.

round( numeric_expression, decimal_places )

round(
    TotalNetAmount,
    2
) as RoundedAmount

The DIV() function performs integer division and returns only the quotient. Any fractional part of the result is discarded.

div( operand1, operand2 )

div(
    cast( TotalNetAmount as abap.dec(13,2) ),
    20
) as Quotient

While DIV() returns only the integer quotient, the DIVISION() function preserves decimal precision.

division(
    operand1,
    operand2,
    decimal_places
)

division(
    TotalNetAmount,
    20,
    2
) as AverageValue

The MOD() function returns the remainder after integer division.

mod( operand1, operand2 )

mod(
    cast( TotalNetAmount as abap.int4 ),
    20
) as Remainder

Many developers assume that DIV() and MOD() support the same operand types. This assumption leads to one of the most common activation errors in CDS development.

mod(
    cast( TotalNetAmount as abap.dec(13,2) ),
    20
) as ModAmount

Function MOD:
Type DEC not supported by parameter 1.

Expected:
INT1
INT2
INT4
INT8

Although TotalNetAmount is numeric, MOD() accepts only integer data types. Therefore, the expression fails during CDS activation.

mod(
    cast( TotalNetAmount as abap.int4 ),
    20
) as ModAmount

This restriction is intentional and often discussed in architect interviews.

Consider the following calculation:

25.75 MOD 4 = ?

Should the answer be:

• 1.75
• 1
• Another value?

Different databases and programming languages interpret decimal modulo operations differently. To avoid ambiguity and ensure consistent behavior, ABAP CDS restricts MOD() to integer operands.

Numeric functions are easy to use, but developers frequently make mistakes because they assume every numeric function supports the same data types and behaves identically.

The following compiler errors are frequently encountered while working with numeric functions in CDS View Entities.

Function MOD:
Type DEC not supported by parameter 1.

Reason: MOD() accepts only integer data types (INT1, INT2,INT4, and INT8).

mod(
    cast( TotalNetAmount as abap.dec(13,2) ),
    20
)

mod(
    cast( TotalNetAmount as abap.int4 ),
    20
)

Function DIV:
Type DECFLOAT34 not supported.

Reason: DIV() supports integer, DEC, and QUAN data types but does not support DECFLOAT operands.

Numeric functions are executed directly in SAP HANA as part of the generated SQL statement. This allows calculations to benefit from code pushdown and minimizes application server processing.

In the accompanying video, we'll implement every numeric function discussed in this lesson using Eclipse ADT and SAP S/4HANA Public Cloud. We'll also reproduce common compiler errors, explain why they occur, and demonstrate the correct production-ready solutions.