cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Query Tool linking problem (incomplete data selected)

mihailo_sundic
Active Contributor
0 Kudos

I used SQ03 to create a Query Group, then i used SQ02 to create InfoSet.

In infoset creation i make a link between tables:

(i want to have all the items from all sales order documents with respective delivery dates and few other not must have info)

VBAP (main table)

VBAP -> VBAK (left join)

VBAP -> LIKP (left join)

I then use SE93 to make my custom Z-transaction for the report-query.

Am i using joins properly? Or is it maybe because i have put a possibility to select by many parameters before query, so something is filtering my results?

It shows only some sales orders, i can't figgure out how to show all items from all sales orders and from other table (LIKP LIPS ?) to get my delivery date for the same items.

If anyone could help i'd appreciate.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

mihailo_sundic
Active Contributor
0 Kudos

Sorry for doubleposting but it would be very confusing if i wrote in the first post.

I managed to link tables and get what i wanted for my report except one thing:

-items from sales order that are not delivered are not in the report.

I linked VBAP to LIPS and LIPS to MKPF (for BUDAT).

How do i get all the items from sales orders on this report whether or not they are having a BUDAT date from MKPF?

Yes i need items that are and are not shipped and i take them from VBAP initially.

mihailo_sundic
Active Contributor
0 Kudos

Can someone please help me on this?

VBAP - LIPS (left join) : VBELN - VGBEL

LIPS - MKPF (inner join) : VBELN - LE_VBELN

When executed it doesn't return rows which are not delivered...

I need all the records from VBAP no matter if there is data in other tables (LIPS and MKPF)

Can someon PLEASE help?

Thanks.

Answers (0)