Problem with CDS Table name $projection is unknown or obscured by an alias / werden verschattet

[Markus_Hapke]

Hello All

according to the book Core Data Service for ABAP , I try to create a CDS and using the Fields of it self by engaging the $projection :

On Check the code , the line concat( $projection... brings the error :

Why is ist not possible to access the view's own fields - for me a core requriement .

Any Ideas ? Do I have to use special annotations ? Is this a release level problem ?

We have ECC with underlying HANA DB:

SAP_BASIS 750 0025 SAPK-75025INSAPBASIS

SAP_ABA 750 0025 SAPK-75025INSAPABA

HANA DB: 2.00.059.01.

Here the coding of the view from ADT:

@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'Z_BOOK_V_Proj2'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{

serviceQuality: #X,

sizeCategory: #S,

dataClass: #MIXED }

define view Z_book_CDS_ViewWithProjFields2

as select distinct from T000

{ 'A' as FieldA ,

'B' as FieldB ,

concat( $projection.FieldA, $projection.FieldB ) as FieldC

}

Thanks in advance, Markus

[Markus_Hapke]

Additionall remark: astonishing : the auto-complete functionality works fine !

bildschirmfoto-2023-11-04-um-131957.png

[junwu]

your system is too old, which doesn't support to use $projection

[Markus_Hapke]

Hello Jun Wu. Thank you for replying . Is there a public SAP information site, where I can see the released functions of the HANA DB ?

regards, Markus