ABAP CDS Views

[Ash_ok]

Hi !

Am trying to create a CDS view between PRHI (WBS Element hierarchy) and PRPS (WBS Elements) to get both internal and external numbers of WBS Elements in their hierarchical format.

I am able to use the 'UP' / 'DOWN' columns of PRHI in my CDS view but calling either PRHI-LEFT or PRHI-RIGHT is giving an 'Unexpected word <left> / <right>' error. Is there an escape sequence to call table field names with either LEFT or RIGHT ? PRHI-UP and PRHI-DOWN seem to work normally. And, yes, I am using an alias for PRHI as well as PRPS.

TIA,

Ashok.

[chandu_bhanuri]

I am facing similar issue, please provide solution in case if you are able to resolve it.

[sgkrish07]

Can anyone please answer this question?

[Former Member]

I am facing the same issue. Did you find a resolution?

[steck_andreas]

I have used a database view to give the fields "left" and "right" in PRHI alias names. The view can then be used in the CDS view and you can avoid the reserved terms in the CDS view:

CDS view:

[Ash_ok]

Nice outside the box solution !