topic Re: problem with select stmt in Application Development and Automation Discussions

problem with select stmt

Former Member — Wed, 14 May 2008 21:36:07 GMT

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.

Re: problem with select stmt

naimesh_patel — Wed, 14 May 2008 21:41:03 GMT

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

Re: problem with select stmt

Former Member — Wed, 14 May 2008 21:59:53 GMT

thanks for your effort.