Create a maintenance view for purchase order tables.

Create a view

Click on maintenance view and copy.

Click on relation ship

It will display the relation ship Select table and copy it

It will display the join conditions

View fields

Activate the view and click on execute button

Output of the view