Query having different answer

[Former Member]

select *

from j_1iexchdr

into table i_j_1iexchdr

where bukrs = p_bukrs

and werks in s_werks

and exgrp in s_exgrp

and srgrp in s_srgrp

and exdat in s_exdat

and budat in s_budat

and not status in ('R','B','D')

and not trntyp in ('CEIV','57FC','ARE1','GRPO','DIEX').

S_WERKS IEQ1000

S_EXGRP IEQ01

S_SRGRP IEQ010

S_EXDAT 0000000000000000

S_BUDAT IBT2010050820100510

STATUS R,B,D

trntyp 'CEIV','57FC','ARE1','GRPO','DIEX'

IN data base table it comes

TRNTYP DOCYR DOCNO BUKRS WERKS EXGRP SRGRP STRTYP EXNUM EXDAT LIFNR STATUS BUDAT

57FC 2010 1000008786 1000 1010 03 032 01 1010000083 04.06.2010 0000110629 A 03.06.2010

57FC 2010 1000009494 1000 1010 03 032 01 1010000091 09.06.2010 0000110628 A 04.06.2010

57FC 2010 1000009495 1000 1010 03 032 01 1010000092 09.06.2010 0000110628 P 04.06.2010

OTHR 2010 1000004824 1000 1000 01 010 1010000083 08.05.2010 0000110634 P 08.05.2010

OTHR 2010 1000005078 1000 1000 01 010 1010000091 10.05.2010 0000110634 P 10.05.2010

OTHR 2010 1000005086 1000 1000 01 010 1010000092 08.05.2010 0000110634 P 08.05.2010

In internal table it comes

DLFC 2010 1000005171 1000 1000 01 010 1010000093 20100510 C 20100511 20100510

DLFC 2010 1000005176 1000 1000 01 010 1010000094 20100510 C 20100511 20100510

OTHR 2010 1000004824 1000 1000 01 010 1010000083 20100508 P 20100508 20100508

OTHR 2010 1000005078 1000 1000 01 010 1010000091 20100510 P 20100510 20100510

OTHR 2010 1000005086 1000 1000 01 010 1010000092 20100508 P 20100510 20100508

[Former Member]

Looks like the select did what you wanted...what's the problem?

[Former Member]

I am facing problem in this query

It has some selection criteria but the query taking all data from database table which you can see.

It can not following where conditions from database table.

I gave here what data comes and what data it is taking from select query.

Thank You,

Jahnavee