topic Re: SQ01 problem in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434915#M1052641 <HTML><HEAD></HEAD><BODY><P>how can i change join type? beacause when i have created infoset i have choose logical database</P></BODY></HTML> Tue, 16 Sep 2008 09:59:06 GMT Former Member 2008-09-16T09:59:06Z SQ01 problem https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434912#M1052638 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a problem...I have create an infoset with logical database VFV; then a query based on this infoset.</P><P></P><P>Fields that i want in my report are:</P><P></P><P>VBRK-FKDAT</P><P>VBAK-BSTNK <STRONG>Additional tabel</STRONG></P><P>VBRP-ARKTX</P><P>VBRP-VBELN</P><P>VBRP-FKIMG</P><P>VBRP-NETWR</P><P>VBPAPO-ADRNR</P><P></P><P><STRONG>Problem is that in my report it only select one item from VBRP table. Why??</STRONG> Example: if billing document 10 has 5 items it select only first item.</P><P>If i remove VBPAPO-ADRNR the result it's OK.</P><P></P><P>Please someone help. </P><P></P><P>Thank you.</P></BODY></HTML> Tue, 16 Sep 2008 08:31:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434912#M1052638 Former Member 2008-09-16T08:31:16Z Re: SQ01 problem https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434913#M1052639 <HTML><HEAD></HEAD><BODY><P>nobody knows nothing? <SPAN __jive_emoticon_name="sad"></SPAN></P></BODY></HTML> Tue, 16 Sep 2008 08:55:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434913#M1052639 Former Member 2008-09-16T08:55:00Z Re: SQ01 problem https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434914#M1052640 <HTML><HEAD></HEAD><BODY><P>The read on table VBPAPO is an inner join. Only one record appears for the document 10 in your example. </P><P></P><P>Change it to left outer join.</P></BODY></HTML> Tue, 16 Sep 2008 09:49:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434914#M1052640 Former Member 2008-09-16T09:49:56Z Re: SQ01 problem https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434915#M1052641 <HTML><HEAD></HEAD><BODY><P>how can i change join type? beacause when i have created infoset i have choose logical database</P></BODY></HTML> Tue, 16 Sep 2008 09:59:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434915#M1052641 Former Member 2008-09-16T09:59:06Z Re: SQ01 problem https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434916#M1052642 <HTML><HEAD></HEAD><BODY><P>Any clue? I'm stuck in this weird problem... if someone could help me, answers will be awarded with points.</P></BODY></HTML> Tue, 16 Sep 2008 11:03:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sq01-problem/m-p/4434916#M1052642 Former Member 2008-09-16T11:03:21Z