CDS view:get current year from date of one association and use it as condition in other association

Hello Experts,I have a requirement to write a Query reporting that list out the Purchase requisition Workflow details with the combination of FM data (FMHIENODES and FMBASOBJNR).I created one CDS view to have all PR details called _PRBase and other o...