| 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
