topic Re: Command WHERE in the SAP in QlikView https://community.qlik.com/t5/QlikView/Command-WHERE-in-the-SAP/m-p/455041#M698366 <HTML><HEAD></HEAD><BODY><P>SQL SELECT MANDT</P><P>FROM BKPF</P><P>WHERE MANDT = 400</P><P></P><P>If you have several tables in your SELECT then you must use the "~" character (beware that it will not work with mandt)</P><P></P><P>SQL SELECT MANDT</P><P>FROM BKPF</P><P>WHERE BKPF~BUKRS = 'ABCD'</P></BODY></HTML> Thu, 21 Feb 2013 12:36:45 GMT danielrozental 2013-02-21T12:36:45Z Command WHERE in the SAP https://community.qlik.com/t5/QlikView/Command-WHERE-in-the-SAP/m-p/455040#M698365 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P></P><P>Sorry for the blast. </P><P></P><P>How we can to do the command WHERE in the SAP, using SAP Connector?&nbsp; </P><P></P><P>Thanks</P></BODY></HTML> Wed, 20 Feb 2013 15:12:29 GMT https://community.qlik.com/t5/QlikView/Command-WHERE-in-the-SAP/m-p/455040#M698365 2013-02-20T15:12:29Z Re: Command WHERE in the SAP https://community.qlik.com/t5/QlikView/Command-WHERE-in-the-SAP/m-p/455041#M698366 <HTML><HEAD></HEAD><BODY><P>SQL SELECT MANDT</P><P>FROM BKPF</P><P>WHERE MANDT = 400</P><P></P><P>If you have several tables in your SELECT then you must use the "~" character (beware that it will not work with mandt)</P><P></P><P>SQL SELECT MANDT</P><P>FROM BKPF</P><P>WHERE BKPF~BUKRS = 'ABCD'</P></BODY></HTML> Thu, 21 Feb 2013 12:36:45 GMT https://community.qlik.com/t5/QlikView/Command-WHERE-in-the-SAP/m-p/455041#M698366 danielrozental 2013-02-21T12:36:45Z