topic Re: question on view in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/question-on-view/m-p/2220392#M476693 <HTML><HEAD></HEAD><BODY><P>You have to go to the Table/Join Conditions tab.</P><P>GIve the join condition as WYT3-LIFN2 = LFA1-LIFNR</P></BODY></HTML> Fri, 27 Apr 2007 19:21:53 GMT Former Member 2007-04-27T19:21:53Z question on view https://community.sap.com/t5/application-development-and-automation-discussions/question-on-view/m-p/2220391#M476692 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 27 Apr 2007 19:13:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/question-on-view/m-p/2220391#M476692 Former Member 2007-04-27T19:13:37Z Re: question on view https://community.sap.com/t5/application-development-and-automation-discussions/question-on-view/m-p/2220392#M476693 <HTML><HEAD></HEAD><BODY><P>You have to go to the Table/Join Conditions tab.</P><P>GIve the join condition as WYT3-LIFN2 = LFA1-LIFNR</P></BODY></HTML> Fri, 27 Apr 2007 19:21:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/question-on-view/m-p/2220392#M476693 Former Member 2007-04-27T19:21:53Z Re: question on view https://community.sap.com/t5/application-development-and-automation-discussions/question-on-view/m-p/2220393#M476694 <HTML><HEAD></HEAD><BODY><P>change the join condition to</P><P></P><P>WYT3 LIFN2 = LFA1 LIFNR</P></BODY></HTML> Fri, 27 Apr 2007 19:24:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/question-on-view/m-p/2220393#M476694 Former Member 2007-04-27T19:24:06Z