SAP CDS---拼接字段和类型转换和join关联

@AbapCatalog.sqlViewName: 'ZV_YYY_CDS_02'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: '拼接字段和类型转换和join关联'

@Metadata.ignorePropagatedAnnotations: true

define view ZVYYY_CDS_02

as select from ska1 as A

inner join skat as T on A.saknr = T.saknr and T.spras = '1'

and A.ktopl = T.ktopl

{

key A.ktopl ,

A.saknr ,

A.erdat ,

A.ernam ,

A.xloev ,

A.xspea ,

A.xspeb ,

A.xspep ,

T.spras ,

T.txt20 ,

T.txt50 ,

@EndUserText.label: '科目编号+创建用户名（拼接）' // 尝试注解 但是失败了 应该咋注解

concat( A.saknr , A.ernam ) as ZNAME , // 拼科目和用户名

cast( T.txt20 as abap.char(10)) as TXT10

}

where A.saknr = '0000001000'