Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
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.
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
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
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
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
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.
Bluesky
