CDS view based Query

[iwan_santoso4]

Hi All,

I'm looking at standard Query as part of Display Trial Balance Fiori app (2CCFITRIALBALQ0001) I'm also working on exercises from S4H410 course. I'm struggling to accomplish to set 1 column that consist of key and description like the highlighted columns:

I can only get two separate column like this:

Any idea on how to accomplish merging key and description as 1 column? Below is the CDS view query definition for Trial Balance:

and here's mine:

Any information on this is greatly appreciated and thank you in advance for your time.

Regards,

Iwan

[Former Member · Accepted solution]

Hi Iwan,

In the Basic view, that contains the elements - 'Airline' and 'AirlineName', kindly try assigning the below annotation to the 'Airline' element. Something like this.

@ObjectModel.text.element: 'AirlineName'
Airline,

@Semantics.text: true
AirlineName,

Let Me know if this helps.

Thanks,

Sagar J.

[iwan_santoso4]

Thanks Jagar. That did it.