topic Re: Query problem in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605076#M1940561 <HTML><HEAD></HEAD><BODY><P>belnr is your document number</P></BODY></HTML> Fri, 01 Apr 2016 06:37:12 GMT Former Member 2016-04-01T06:37:12Z Query problem https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605073#M1940558 <HTML><HEAD></HEAD><BODY><P>this is the main query</P><P></P><P></P><P><SPAN class="L1S52">clear</SPAN> : itab[], tmpitab[].</P><P></P><P> <SPAN class="L1S31">*------------Get Open Items-----</SPAN></P><P> <SPAN class="L1S52">select</SPAN></P><P> bukrs</P><P> lifnr</P><P> <SPAN class="L1S31">*LGORT</SPAN></P><P> <SPAN class="L1S31">*LGOBE</SPAN></P><P> <SPAN class="L1S31">*DB</SPAN></P><P> <SPAN class="L1S31">*CR</SPAN></P><P> zuonr</P><P> shkzg</P><P> wrbtr</P><P> blart</P><P> <SPAN class="L1S52">into</SPAN> corresponding <SPAN class="L1S52">fields</SPAN> <SPAN class="L1S52">of</SPAN> <SPAN class="L1S52">table</SPAN></P><P> tmpitab&nbsp; <SPAN class="L1S52">from</SPAN> bsik <SPAN class="L1S52">where</SPAN></P><P> bukrs <SPAN class="L1S52">eq</SPAN> p_bukrs <SPAN class="L1S52">and</SPAN> lifnr <SPAN class="L1S52">eq</SPAN> p_lifnr</P><P> <SPAN class="L1S52">and</SPAN> budat&nbsp; <SPAN class="L1S52">in</SPAN> s_budat</P><P> <SPAN class="L1S52">and</SPAN> zuonr <SPAN class="L1S52">ne</SPAN> <SPAN class="L1S33">''</SPAN> .</P><P></P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/919966" height="182" width="476" /></P><P>it is fetching from Assignment (4500000417, CHQ# 34343456).</P><P></P><P>i only want to fetch only PO NO ( <SPAN style="font-size: 13.3333px;">4500000417) </SPAN></P><P></P><P>i am using&nbsp; Assignment (zuonr) and PO no(ebeln) for that.</P><P></P><P>when i used zuonr eq itab-ebeln. it not giving the right result.</P><P></P><P></P><P>can any one help.</P><P></P><P>khurram nagi</P></BODY></HTML> Fri, 01 Apr 2016 06:14:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605073#M1940558 Former Member 2016-04-01T06:14:27Z Re: Query problem https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605074#M1940559 <HTML><HEAD></HEAD><BODY><P>try adding blart eq 'OC' in where clause</P></BODY></HTML> Fri, 01 Apr 2016 06:33:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605074#M1940559 Former Member 2016-04-01T06:33:26Z Re: Query problem https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605075#M1940560 <HTML><HEAD></HEAD><BODY><P>PO number only</P></BODY></HTML> Fri, 01 Apr 2016 06:34:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605075#M1940560 Former Member 2016-04-01T06:34:46Z Re: Query problem https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605076#M1940561 <HTML><HEAD></HEAD><BODY><P>belnr is your document number</P></BODY></HTML> Fri, 01 Apr 2016 06:37:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-problem/m-p/11605076#M1940561 Former Member 2016-04-01T06:37:12Z