How to find correct CDS View as per requirement.

Hi Experts,

I am new in S4hahan cloud as well CDS View.

Working on creating an app for getting pending WF task related to x-employee. Have created app with all the details just the manager details are not maintained in system for ex-employees. I have also checked some CDS View but there also the same.

we are also facing the challenge finding the right CDS View to check.

Please suggest.

Thanks and Regards