Skip to Content
0
Jul 31, 2023 at 08:50 AM

Maintenance view - Join tables validity dates foreign key

105 Views

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?

image.png

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!

Attachments

image.png (19.8 kB)