Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to join multiple tables using outer joins !

Former Member
0 Likes
443

Please Any one help me ....how to join more than three tables

using left outer joins So that E.g

if I am joining tables A,B,C,D etc

and A has vbeln then I should get the output of this join in such a way that I will get all the values of vbeln on the left in the final table but corresponding field values in the final table

may or may not present. If B,C,D.... has the values of other filelds corresponding to vbeln then they will be dislayed other wise blank....

SEND ME AN EXAMPLE OF LEFT OUTER JOIN WITH MORE THAN 4 TABLES

2 REPLIES 2
Read only

Former Member
0 Likes
423

joining vbap outer join vbep and if there is no corresponding record i vbep, you will still get a record from vbap.

Read only

0 Likes
423

SEND ME AN EXAMPLE OF LEFT OUTER JOIN WITH MORE THAN 4 TABLES