在CDS中常用的字符串函数说明。
1.一、CONCAT(arg1, agr2)
string function can be used to concatenate two character strings.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
@AbapCatalog.sqlViewName: 'ZCDS_STR_FUN' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'TEST' define view ZCDS_SQL_FUN as select from kna1 { // CONCATENATE kunnr & name1 CONCAT( kna1.kunnr, kna1.name1 ) as full_name, kunnr, name1, name2 } |
数据浏览如图
2.二、CONCAT_WITH_SPACE
This string function is used to concatenate two character strings with space. The number of blanks between the arguments arg1 and arg2 is specified in spaces.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
@AbapCatalog.sqlViewName: 'ZCDS_STR_FUN' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'TEST' define view ZCDS_SQL_FUN as select from kna1 { // CONCATENATE kunnr & name1 CONCAT_WITH_SPACE( kna1.kunnr, kna1.name1,4 ) as full_name, kunnr, name1, name2 } |
数据浏览如图
3.三、 SUBSTRING(arg, pos, len)
To get sub string of arg from the position pos in the lenght len.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
@AbapCatalog.sqlViewName: 'ZCDS_STR_FUN' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'TEST' define view ZCDS_SQL_FUN as select from kna1 { // CONCATENATE kunnr & name1 CONCAT_WITH_SPACE( kna1.kunnr, kna1.name1,4 ) as full_name, kunnr, name1, SUBSTRING( kna1.name1, 2, 10) as name,//从第二位,取10个长度 name2 } |
浏览数据如图
4.其它函数
LEFT(arg, len) & RIGHT(arg, len)
EFT(arg, len) – It returns the left-side part of the string which is passed as argument arg of length len.
RIGHT(arg, len) – It returns the right-side part of the string which is passed as argument arg of length len.
Note: Trailing blanks are ignored
LTRIM(arg, char) & RTRIM(arg, char)
LTRIM(arg, char) – It removes the trailing blanks and leading character which matches the parameter char.
RTRIM(arg, char) – It removes the trailing blanks and trailing character which matches the parameter char.