topic Re: query, where clause not working. in Application Development and Automation Discussions

query, where clause not working.

Former Member — Wed, 30 Jan 2008 14:18:48 GMT

Hi,

Query is:

select vbeln posnr matnr

from vbap

into table it_ivbap.

it_ivbap is internal table. i got records when i executed this query.

gave a where clause

select vbeln posnr matnr

from vbap

into table it_ivbap

where vbeln = '5049'.

it is not returning any records. i tried with all the possile values of vbeln

what I am doing wrong.

Thanks in advance.

Re: query, where clause not working.

Former Member — Wed, 30 Jan 2008 14:20:10 GMT

Hello,

Change like this,


select vbeln posnr matnr
from vbap
into table it_ivbap
where vbeln = '0000005049'. " Check here

Regards,

vasanth

Re: query, where clause not working.

Former Member — Wed, 30 Jan 2008 14:21:46 GMT

Hi,

VBELN is the 10 charecters field, so whenever you use the where clause you need to provide the total length, so use the ZEROS before that number to execute that query

Regards

Sudheer

Re: query, where clause not working.

Former Member — Wed, 30 Jan 2008 14:22:39 GMT

Thank you so much.