topic Open Sql in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/open-sql/m-p/8127217#M1619005 <HTML><HEAD></HEAD><BODY><P>How to write open sql query for this .</P><P></P><P></P><P> Do select COUNT(*) from R.TFRSOUT where I_APT = in_MATERIAL NO.</P><P>If COUNT(*) &gt; 0,</P><P> record is present.</P><P>endif.</P></BODY></HTML> Fri, 16 Sep 2011 06:25:25 GMT Former Member 2011-09-16T06:25:25Z Open Sql https://community.sap.com/t5/application-development-and-automation-discussions/open-sql/m-p/8127217#M1619005 <HTML><HEAD></HEAD><BODY><P>How to write open sql query for this .</P><P></P><P></P><P> Do select COUNT(*) from R.TFRSOUT where I_APT = in_MATERIAL NO.</P><P>If COUNT(*) &gt; 0,</P><P> record is present.</P><P>endif.</P></BODY></HTML> Fri, 16 Sep 2011 06:25:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-sql/m-p/8127217#M1619005 Former Member 2011-09-16T06:25:25Z Re: Open Sql https://community.sap.com/t5/application-development-and-automation-discussions/open-sql/m-p/8127218#M1619006 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Did you try something like...</P><PRE><CODE> SELECT COUNT( * ) INTO LV_COUNT FROM .... WHERE I_APT = IN_MATERIAL_NO. IF LV_COUNT &gt; 0. ... ENDIF. </CODE></PRE><P></P></BODY></HTML> Fri, 16 Sep 2011 07:25:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-sql/m-p/8127218#M1619006 Former Member 2011-09-16T07:25:47Z