Hello everyone,
I have created a Z table With PERNR and and ENDDA as key fields, to maintain this table I wanted to create a maint. view with an additional field that displays pernr -> person name, for this i tried to join PA0002 in view(auto detected conditions in image).
The problem is that my Z table has different validity dates from PA0002, and if the full name is only found if validity dates match.
Is there any way to change this so it displays full name valid for "today"? or any type of particular date?

Limitations:
- It should be a maintenance view(due to delimit record functionality)
-Full name cannot be saved in Z table
thank you for your time!