Is CDS allow to write Select in a select

Have to find the accounting documents from ACDOCA from where GL account & amount having duplicate values. I tried all possible ways to get the output in a single view. But no success. Finally I used view on view concept to resolve it.

Thank you in advance,

Suresh