We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-acct] Query with Left Outer Join

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by ayoung001 (FI/CO)
on Sep 20 at 2:41 AM
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
View this online
  
Popular White Papers

In the Spotlight
Have you explored the Toolbox.com Marketplace? Learn more and access a free course now.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language