| 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
