Issue in ABAP CDS Views - SAP S/4 Hana Public Edition

[SriSaiBhargav]

Hi SAP Experts!!

I have created a Data definition with Sales Order and Sales Order Item fields and when I see the output I am getting as below.

But My requirement is to get data as below. 

I require order items grouped with order no. 

Kindly Help.

Thanks,

Sai Bhargav

[Sandra_Rossi]

You have used the generic ADT data preview which is only used by developers. What kind of application will be used by users?

[Sahil_Grover]

Dear Sri Sai,

Thats Data Preview in ADT , for end use/business user you can create your own application .

Regards

Sahil 

__PRESENT