Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
BTW when I add an extra field in the infoset and write some code for that, the system always shows errors, I'm not sure whether the code is wrong or it is written in the wrong place... Instead I add an extra table bnka without any coding, the problem solved.
| | | ---------------Original Message---------------
From: Sean Jia
Sent: Tuesday, September 20, 2011 2:42 AM
Subject: Query with Left Outer Join
Hi all,
I want to create a query to display vendor, bank and bank name. Three tables are involved lfb1, lfbk, bnka.
But during the table join, I can place only one outer join between 'lfb1 and lfbk' or 'lfbk and bnka', either way can't display those vendors without bank information in master data.
vendor:A bank:1 bankname:aaa
vendor:C bank:2 bankname:bbb
What can I do to make all vendors displayed?
vendor:A bank:1 bankname:aaa
vendor:B bank: bankname:
vendor:C bank:2 bankname:bbb
Thank you. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight View the "Managing the Application Life Cycle" webinar and learn how organizations optimize their SAP applications.   _.____.__ |
