topic Re: Calculated Columns in CDS in Application Development and Automation Discussions

Calculated Columns in CDS

Former Member — Fri, 21 Apr 2017 14:35:34 GMT

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 — Fri, 21 Apr 2017 15:00:00 GMT

You can do that in ABAP CDS.

Former Member — Mon, 24 Apr 2017 07:09:50 GMT

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