Remove duplicates rows from new created view

[Sandra_Rossi]

Hi Dear SAP Community,

I have created new Database view using SE11 to merge AGR_AGRS and AGR_TCODES tables.

The reason is to view single roles, and regarding to these single roles transactions for selected composite role.

But when I execute this view in SE16N with selected some random composite role, there were duplicate rows; every row has 3 duplicate rows. It's interesting that not 2,7 or 8, but 4.

I have attached screen of view configuration and result.

Can I remove this duplications without codding?

Please advise,

Thanks to all in advance,

Best Regards,

Sergey Aliyev

[Sandra_Rossi]

Probably a CDS view would work. Did you try? (Eclipse ADT needed)