topic Re: Query having different answer in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/query-having-different-answer/m-p/6983116#M1492856 <HTML><HEAD></HEAD><BODY><P>I am facing problem in this query </P><P></P><P>It has some selection criteria but the query taking all data from database table which you can see.</P><P>It can not following where conditions from database table.</P><P></P><P>I gave here what data comes and what data it is taking from select query.</P><P></P><P>Thank You,</P><P></P><P>Jahnavee</P></BODY></HTML> Fri, 18 Jun 2010 04:49:20 GMT Former Member 2010-06-18T04:49:20Z Query having different answer https://community.sap.com/t5/application-development-and-automation-discussions/query-having-different-answer/m-p/6983114#M1492854 <HTML><HEAD></HEAD><BODY><P>select *</P><P> from j_1iexchdr</P><P> into table i_j_1iexchdr</P><P> where bukrs = p_bukrs</P><P> and werks in s_werks</P><P> and exgrp in s_exgrp</P><P> and srgrp in s_srgrp</P><P> and exdat in s_exdat</P><P> and budat in s_budat</P><P> and not status in ('R','B','D')</P><P> and not trntyp in ('CEIV','57FC','ARE1','GRPO','DIEX').</P><P></P><P></P><P>S_WERKS IEQ1000</P><P>S_EXGRP IEQ01</P><P>S_SRGRP IEQ010</P><P>S_EXDAT 0000000000000000</P><P>S_BUDAT IBT2010050820100510</P><P>STATUS R,B,D</P><P>trntyp 'CEIV','57FC','ARE1','GRPO','DIEX'</P><P></P><P></P><P></P><P>IN data base table it comes</P><P>TRNTYP DOCYR DOCNO BUKRS WERKS EXGRP SRGRP STRTYP EXNUM EXDAT LIFNR STATUS BUDAT</P><P></P><P>57FC 2010 1000008786 1000 1010 03 032 01 1010000083 04.06.2010 0000110629 A 03.06.2010</P><P>57FC 2010 1000009494 1000 1010 03 032 01 1010000091 09.06.2010 0000110628 A 04.06.2010</P><P>57FC 2010 1000009495 1000 1010 03 032 01 1010000092 09.06.2010 0000110628 P 04.06.2010</P><P>OTHR 2010 1000004824 1000 1000 01 010 1010000083 08.05.2010 0000110634 P 08.05.2010</P><P>OTHR 2010 1000005078 1000 1000 01 010 1010000091 10.05.2010 0000110634 P 10.05.2010</P><P>OTHR 2010 1000005086 1000 1000 01 010 1010000092 08.05.2010 0000110634 P 08.05.2010</P><P></P><P></P><P></P><P></P><P></P><P>In internal table it comes</P><P></P><P>DLFC 2010 1000005171 1000 1000 01 010 1010000093 20100510 C 20100511 20100510</P><P>DLFC 2010 1000005176 1000 1000 01 010 1010000094 20100510 C 20100511 20100510</P><P>OTHR 2010 1000004824 1000 1000 01 010 1010000083 20100508 P 20100508 20100508</P><P>OTHR 2010 1000005078 1000 1000 01 010 1010000091 20100510 P 20100510 20100510</P><P>OTHR 2010 1000005086 1000 1000 01 010 1010000092 20100508 P 20100510 20100508</P></BODY></HTML> Thu, 17 Jun 2010 12:44:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-having-different-answer/m-p/6983114#M1492854 Former Member 2010-06-17T12:44:36Z Re: Query having different answer https://community.sap.com/t5/application-development-and-automation-discussions/query-having-different-answer/m-p/6983115#M1492855 <HTML><HEAD></HEAD><BODY><P>Looks like the select did what you wanted...what's the problem?</P></BODY></HTML> Thu, 17 Jun 2010 13:29:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-having-different-answer/m-p/6983115#M1492855 Former Member 2010-06-17T13:29:35Z Re: Query having different answer https://community.sap.com/t5/application-development-and-automation-discussions/query-having-different-answer/m-p/6983116#M1492856 <HTML><HEAD></HEAD><BODY><P>I am facing problem in this query </P><P></P><P>It has some selection criteria but the query taking all data from database table which you can see.</P><P>It can not following where conditions from database table.</P><P></P><P>I gave here what data comes and what data it is taking from select query.</P><P></P><P>Thank You,</P><P></P><P>Jahnavee</P></BODY></HTML> Fri, 18 Jun 2010 04:49:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-having-different-answer/m-p/6983116#M1492856 Former Member 2010-06-18T04:49:20Z