How to display the data in one column from one more column data in CDS VIEWS

[Former Member]

Hi,

I am very new to CDS views. am facing ONE problem in CDS views in ABAP on HANA module. Here I have only one table. The table having 5 columns. Suppose in the 4 th column some time i have a data, some times don't have data to displaY.

If i dont have a data to display in 4 th column , i need to get the data from 5th columns and display the same data in 4 th columns.

like

if 4th column is initial.

--> get the data from 5th column and display same data in 4th coulmn..

we can use case conditions for that. i dont want to use case conditions to achive this functionality..

--> One concept is there in CDS views to achiving this func tionality ??what is that?/

Thanking you all.

[ssurampally · Accepted solution]

you can define a CDS view to read the data from your table, you will have a new column name which will have a logic either to take the data from column 4 or column 5 based on NULL value as you described in the SELECT statement of CDS view definition.