Application Development 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: 

SQ01 problem

milascon_daniel
Participant

‎09-16-2008 9:31 AM

0 Kudos

Hi,

I have a problem...I have create an infoset with logical database VFV; then a query based on this infoset.

Fields that i want in my report are:

VBRK-FKDAT

VBAK-BSTNK Additional tabel

VBRP-ARKTX

VBRP-VBELN

VBRP-FKIMG

VBRP-NETWR

VBPAPO-ADRNR

Problem is that in my report it only select one item from VBRP table. Why?? Example: if billing document 10 has 5 items it select only first item.

If i remove VBPAPO-ADRNR the result it's OK.

Please someone help.

Thank you.

4 REPLIES 4

milascon_daniel
Participant

‎09-16-2008 9:55 AM

0 Kudos

nobody knows nothing?

Former Member

‎09-16-2008 10:49 AM

0 Kudos

The read on table VBPAPO is an inner join. Only one record appears for the document 10 in your example.

Change it to left outer join.

milascon_daniel
Participant
In response to Former Member

‎09-16-2008 10:59 AM

0 Kudos

how can i change join type? beacause when i have created infoset i have choose logical database

milascon_daniel
Participant
In response to Former Member

‎09-16-2008 12:03 PM

0 Kudos

Any clue? I'm stuck in this weird problem... if someone could help me, answers will be awarded with points.