I have a view that contains two tables LFA1 and WYT3. the join is on LIFNR and the view contains the partner function, the "reference to other vendor" field LIFN2, and address information. the problem that I have is the for 1 vendor, there can be multiple records in the WYT3 table that have different LIFN2 values. What I would need to have in the view is the address if the LIFN2 vendor, not the address of the LIFNR vendor. I do not know how to get this information in the view. I am not sure if this is handled on the tab "selection Conditions" when you display the view or not.
Bluesky
