ABAP CDS View query

[former_member3017]

Hello Colleagues,

I have created CDS view to read the VC characteristics assigned to material from AUSP table (ATINN is internal number of characteristic here). I have also created another CDS view to retrieve the characteristic names from CABN table. How can I join both these views to display all characteristics in a row.

Thanks..

[horst_keller]

Just join them, either in ABAP CDS or in Open SQL ...

[former_member284740]

There's an SAP blog about transposing records the way you want it. You can search for it.

[former_member3017]

I have searched all the blogs regarding this topic, do you mind sharing the link?

[former_member284740]

https://blogs.sap.com/2014/01/02/table-transpose-in-sap-hana-modeling/

https://blogs.sap.com/2014/09/10/transposing-rows-to-columns-using-calculation-view/

that wasn't so hard to find actually...

[former_member3017]

May be, it wasn't hard to find but it is irrelevant to my question. My question was about ABAP CDS views.

[former_member284740]

ok good luck then! 🙂