problem with select stmt

[Former Member]

hi gurus,

i need to select all the vbeln data from vbap, where the vbeln ends with 005.

i am trying to use the following, but its not picking any values,

SELECT * FROM vbap INTO TABLE temp_vbap WHERE vbeln like ' *005 '.

please help.

[naimesh_patel]

Try like this:

DATA: IT_VBAP TYPE STANDARD TABLE OF VBAP.
RANGES: R_VBELN FOR VBAP-VBELN.

R_VBELN-SIGN = 'I'.
R_VBELN-OPTION = 'CP'.
R_VBELN-LOW = '+++++++005'.
APPEND R_VBELN.
CLEAR  R_VBELN.

SELECT * FROM VBAP INTO TABLE IT_VBAP WHERE VBELN IN R_VBELN.
WRITE: SY-DBCNT.

Regards,

Naimesh Patel

[Former Member]

thanks for your effort.