ABAP CDS on HANA-10

SQL functions in ABAP CDS   

 

 

List of SQL Functions

Numeric Functions

ABS(arg)

CEIL(arg)

DIV(arg1, arg2)

DIVISION(arg1, arg2, dec)

FLOOR(arg)

MOD(arg1, arg2)

ROUND(arg, pos)

String Functions

CONCAT(arg1, arg2)

CONCAT(arg1, arg2, space_cnt)

LPAD(arg, len, src)

REPLACE(arg1, arg2, arg3)

SUBSTRING(arg, pos, len)

CDS View

---

@AbapCatalog.sqlViewName: ‘ZFLIGHT_VW’
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: ‘Demo View SQL Functions’
define view Zflight_View
as select from spfli as s
{
key s.carrid,
key s.connid,
concat_with_space(s.cityfrom, s.cityto, 4 ) as City_From_To
}

---

Data Preview

---