How to create a relative selection for Task Approver field from Approval Task Details data source

[and_y]

Hello,

I would like to create relative selection for field Task Approver from Approval Task Details data source, to be able to filter the tickets which are pending approval with the current logged in user.

I would like to create Employee - My User Name" Relative Select For this field, to be able to filter for the users the tickets they need to approve.

Thanks!

[konstantin_p]

Hello,

as you might know the Data Source "Approval Task Details" only draws results if it is joined with an application created data source as an anchor. More about this in the following KBA: https://me.sap.com/notes/0002599498

Your requirement to create a relative selection for the field "Task Approver" can be achieved by joining the "Employee Master Data" Data Source as well. 

In the attached example, the application created Data Source "Ticket" is joined with the "Approval Task Details" Data Source based on the attributes "Ticket" and "Business Document UUID". The "Approval Task Details" Data Source is joined with the "Employee Master Data" Data Source based on the attributes "Task Approver" and "User". 

Finally, in the Report you build on top of this joined Data Source, use the "Employee" attribute from the "Employee Master Data" Data Source for your relative selection. You might want to consider renaming it so it is easier to identify.

Kind regards,

Konstantin