Tuesday, June 3, 2008

Select-Options Restricting Entry of Rows

Select-Options Restricting Entry of Rows

To restrict entry to only one row you can use the following Syntax.

SELECT-OPTIONS s_vbeln FOR VBAK-VBELN  NO-EXTENSION

If NO-EXTENSION is used then the Push Button for multiple selection does not appear on the selection screen and hence multiple selections are not available for the User.

Find the code below.

REPORT ZEX_SELECTOPTIONS.

Tables: VBAK,
        VBAP.

Data: int_vbak type vbak occurs 0 with header line.

Select-options: s_vbeln for vbak-vbeln NO-EXTENSION.

Select * INTO int_VBAK from VBAK where
         VBELN in s_vbeln.
APPEND int_VBAK.
CLEAR int_VBAK.
ENDSELECT.

Loop at s_vbeln.
WRITE: /   'SIGN:',   s_vbeln-sign,
           'OPTION:', s_vbeln-option,
           'LOW:',    s_vbeln-low,
           'HIGH:',   s_vbeln-high.
Endloop.

loop at int_vbak.
Write:/ int_vbak-vbeln, int_vbak-AUART.
endloop.

No comments:

Post a Comment