Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQVI - table connections

Dear All,

This question might be very primitive to you, but I don't know the answer, so I'd like you to help me.

If the jointtype is <i>'left outer'</i> I can list all record from the 'left' table even if it doesn't have its counterpart (suitable record) in the 'right' table.

But if I connect one more table to the 'right' one, I cannot get all record from the 'left' table - I can't get those that don't have their counterpart in the 'left'.

I mean:

MAST_1 - STKO - STPO - (Left outer ) - MAST_2

All children part (components) will be listed from STPO. But if I connect STKO_2 and STPO_2 to MAST_2 (in order to get the 2 level components) those components that don't have their suitable record in MAST2 will disappear.

parent children_1level children_2level

A____B

A____C____________D

The query won't display B because B doesn't have BOM.

How can this iisue be solved (in SQVI - I can't use ABAP).

Please help me!

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question