Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Query on joint tables

tim_schoenmakers2
Explorer

‎2008 Feb 19 5:10 PM

0 Likes
396

Dear experts,

I am trying to create a query with SQVI with different tables, but it does not seem to work correctly.

I have linked VBAK with 3 tables

Links:

Left: VBAK-VBELN

Right: VBAK-VBELN(2)

Jointype: Left Outer

Left: VBAK-VBELN

Right: VBAP-VBELN(3)

Jointype: Left Outer

Left: VBAK-VBELN

Right: LIPS-VGBEL

Jointype: Left Outer

Then I linked the LIPS table to the LIKP table:

Link:

Left: LIPS-VBELN

Right: LIKP-VBELN(2)

Jointyp: Inner

The query is working, but only displays sales orders which have already a delivery linked to it. What we need is that all the sales orders are displayed (also when a delivery has not been created).

Can anyone help me with this problem? <REMOVED BY MODERATOR>

Kind regards,

Tim

Edited by: Alvaro Tejada Galindo on Feb 19, 2008 12:15 PM

Dear experts,

I am trying to create a query with SQVI with different tables, but it does not seem to work correctly.

I have linked VBAK with 3 tables

Links:

Left: VBAK-VBELN

Right: VBAK-VBELN(2)

Jointype: Left Outer

Left: VBAK-VBELN

Right: VBAP-VBELN(3)

Jointype: Left Outer

Left: VBAK-VBELN

Right: LIPS-VGBEL

Jointype: Left Outer

Then I linked the LIPS table to the LIKP table:

Link:

Left: LIPS-VBELN

Right: LIKP-VBELN(2)

Jointyp: Inner

The query is working, but only displays sales orders which have already a delivery linked to it. What we need is that all the sales orders are displayed (also when a delivery has not been created).

Can anyone help me with this problem? <REMOVED BY MODERATOR>

Kind regards,

Tim

Edited by: Alvaro Tejada Galindo on Feb 19, 2008 12:15 PM

Reply
1 REPLY 1
Read only

Former Member

‎2008 Feb 19 6:20 PM

0 Likes
364

Hi,

When u use SQVi to build a query using table join, it will only display those sales order which has a delivery document.

you need to create 2 single table queries, one for VBAK/VBAP and the other for LIKP/LIPS.

Once u query the first VBAK/VBAP then u can use the output sales order numbers to query LIKP/LIPS.

Hope this helps.