Hi All,
Can anyone please explain the concept of using SELECT-OPTIONS in data fetching (In, Select statement, where clause).
For Ex.
SELECTION-SCREEN BEGIN OF BLOCK selsrn WITH FRAME TITLE
text-001.
SELECT-OPTIONS: s_vbeln FOR vbak-vbeln NO-EXTENSION,
s_erdat FOR vbak-erdat NO-EXTENSION
NO INTERVALS,
s_vbtyp FOR vbak-vbtyp,
s_auart FOR vbak-auart,
s_vkbur FOR vbak-vkbur.
PARAMETER: p_kunnr TYPE vbak-kunnr.
SELECTION-SCREEN END OF BLOCK selsrn.
START-OF-SELECTION.
SELECT vbeln
vbtyp
kunnr
FROM vbak INTO TABLE it_vbak1
WHERE vbeln = s_vbeln AND
erdat = s_erdat AND
vbtyp = s_vbtyp AND
auart = s_auart AND
vkbur = p_vkbur.
WHERE vbeln IN s_vbeln AND
erdat IN s_erdat AND
vbtyp IN s_vbtyp AND
auart IN s_auart AND
vkbur IN s_vkbur AND
kunnr EQ p_kunnr.
Here, I need to know what is the diffrence in the commented "WHERE" and the other. Iam also aware of the select-option structure (Option, Sign, Low and High).
Regards,
Sumanth.