ABAP CDS ON HANA-(10)項目結合して一つ項目として表示
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