2007 Apr 27 8:13 PM
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.
2007 Apr 27 8:21 PM
You have to go to the Table/Join Conditions tab.
GIve the join condition as WYT3-LIFN2 = LFA1-LIFNR
You have to go to the Table/Join Conditions tab.
GIve the join condition as WYT3-LIFN2 = LFA1-LIFNR
2007 Apr 27 8:21 PM
You have to go to the Table/Join Conditions tab.
GIve the join condition as WYT3-LIFN2 = LFA1-LIFNR
2007 Apr 27 8:24 PM
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |