SQ01 problem

[Former Member]

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.

[Former Member]

nobody knows nothing?

[Former Member]

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.

[Former Member]

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

[Former Member]

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