Calculated Columns in CDS

[Former Member]

Hi,

I am looking to create multiple calculated columns in a CDS view.

Can I not create multiple calculated columns in one CDS view (like we do in a single node in HANA Modeling)?

Code Below:

CONCAT( kna1.name1, kna1.name2 ) as full_name,

UPPER( full_name ) as full_name_up

Thanks,
Remya

[retired_member]

You can do that in ABAP CDS.

[Former Member]

Hi Horst,

I am creating ABAP CDS view only.

It is not letting me use the calculated column 'full_name' in another calculation within same view - Below is the error;

"Column full_name is not known Z_A_CUSTOMER_AA (Data Definition) ABAP Syntax Check Problem"

Could you please let me know.

Regards,
Remya