Skip to Content
0
Former Member
Oct 08, 2005 at 07:15 AM

Select-Options

112 Views

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.