SELECT statement

[Former Member]

Friends,

Could you tell me the difference between below two select statements.

data : itab like ztab occurs 0 with header line.

1. SELECT * FROM ztab

INTO table itab

WHERE cust IN s_cust

AND shipdt IN s_date

AND Xflag NE 'Y'

AND status NE 'XX'

AND ddate LE gv_deldate

AND cflag EQ ' '.

2. SELECT * FROM ztab

WHERE cust IN s_cust

AND shipdt IN s_date

AND Xflag NE 'Y'

AND status NE 'XX'

AND ddate LE gv_deldate.

check ztab-cflag is initial.

move-corresponding ztab to itab.

append itab.

ENDSELECT.

I am looking up for a particular entry in the ztab but it would give me the result when i use the 2nd select statement. But i think both the statements should give the same results.

Thanks,

Dev

[Former Member]

I do not see any diffrenece in both query's

data : itab like ztab occurs 0 with header line.

1. SELECT * FROM ztab

INTO table itab

WHERE cust IN s_cust

AND shipdt IN s_date

AND Xflag NE 'Y'

AND status NE 'XX'

AND ddate LE gv_deldate

AND cflag EQ <b>space</b>.

2. SELECT * FROM ztab

WHERE cust IN s_cust

AND shipdt IN s_date

AND Xflag NE 'Y'

AND status NE 'XX'

AND ddate LE gv_deldate.

check ztab-cflag is initial.

move-corresponding ztab to itab.

append itab.

ENDSELECT.

What is data type of cflag ?

sort the internal table and see the results.

Thanks

Seshu

[Former Member]

cflag data type is 1 character in both cases.

I tried using space instead of ' ' in the select statement . It gives me result only when i use check statement.

[Pawan_Kesari]

depending on the type of field CFLAG the select statement may give you different result.... Both statement will give same result of CFLAG is of type CHAR with lenth 1

[ferry_lianto]

Hi,

Please try this.

SELECT * FROM ztab
INTO table itab
WHERE cust IN s_cust
AND shipdt IN s_date
AND Xflag NE 'Y'
AND status NE 'XX'
AND ddate LE gv_deldate
AND cflag IS initial.             "Change here

Regards,

Ferry Lianto

[Former Member]

It works when i use cflag is NULL. But would like to know the difference. Why would it not show up in case of 1st select stmt.

[former_member194669]

Hi,

Try this way

SELECT * FROM ztab
INTO table itab
WHERE cust IN s_cust
AND shipdt IN s_date
AND Xflag NE 'Y'
AND status NE 'XX'
AND ddate LE gv_deldate.
if sy-subrc eq 0.
 delete ztab where cflag ne space.
endif.

aRs

[Former Member]

Performance wise 2nd one is better..

though results will be same.

Reward if useful..

Regards

Prax