I have to create quite a few Custom CDS views and Custom Analytical Queries for reporting purposes but find it hard to find where (CDS views) the data I see at the "front-end" actually resides in the "back-end".
For example, if I wanted to create a Custom CDS view that joins Project data with Transactions data, how would I know which out of the box CDS views to use and join together? Is there perhaps a data model somewhere out there? That would make my life alot easier!!
Help would be greatly appreciated