This website is not affiliated with, sponsored by, or approved by SAP AG.

LEFT OUTER JOIN between fields VBRK-VBELN and BSAD-VBELN

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

LEFT OUTER JOIN between fields VBRK-VBELN and BSAD-VBELN

Postby pejuz1 » Fri Jun 19, 2015 6:01 am

Hello SAP experts,

I have created a query between tables VBRK and BSAD.

For joining I used LEFT OUTER JOIN between fields VBRK-VBELN and BSAD-VBELN.
In the table VBRK I have two records XXX and YYY. In the table BSAD I have only one record XXX.
I expected that as a result I will see both documents XXX and YYY because I used LEFT OUTER JOIN. But I see only document XXX which is in the both tables.
Do you know why?

Thanks a lot
Pejuz
pejuz1
 
Posts: 164
Joined: Mon Jul 30, 2007 3:34 am

Re: LEFT OUTER JOIN between fields VBRK-VBELN and BSAD-VBELN

Postby Gothmog » Fri Jun 19, 2015 6:59 am

Do you have any selection condition on the BSAD table?
If yes, it's because of this - the WHERE condition is applied to the resulting set of the join.
68 74 74 70 3a 2f 2f 74 69 6e 79 75 72 6c 2e 63 6f 6d 2f 62 64 6f 37 6d 77 67
Gothmog
 
Posts: 1941
Joined: Wed Sep 12, 2007 4:46 am
Location: Probably not home

Re: LEFT OUTER JOIN between fields VBRK-VBELN and BSAD-VBELN

Postby pejuz1 » Fri Jun 19, 2015 7:25 am

Thank you very much.

I had selection condition BSAD-GJAHR.
now it works.

Thanks a lot :-)
pejuz1
 
Posts: 164
Joined: Mon Jul 30, 2007 3:34 am


Return to ABAP

Who is online

Users browsing this forum: Google Adsense [Bot] and 9 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.