topic Re: Query not working in Application Development and Automation Discussions

Query not working

Former Member — Wed, 09 Jun 2010 11:05:41 GMT

Hi,

My query is below, it isnt working,

select single MATNR

into t_disp-MATNR

from vbrp

where vbeln = o_vbeln

and posnr = o_posnr.

i dont know why? any one have solution for this?

Thanx & Regards

Jahnavee

Re: Query not working

Former Member — Wed, 09 Jun 2010 11:06:43 GMT

help

Re: Query not working

Former Member — Wed, 09 Jun 2010 11:09:39 GMT

Hi,

Are you passing any value in O_VBELN and O_POSNR or leaving it blank.

In case you are leaving black it wont give you any output.

Please Check.

Sany.

Re: Query not working

birendra_chatterjee — Wed, 09 Jun 2010 11:18:23 GMT

Hi,

Check whether o_vbeln has leading zeroes in it. If not then use 'CONVERSION_EXIT_ALPHA_INPUT' to add leading zeroes.

Regards,

Birendra

Re: Query not working

Former Member — Wed, 09 Jun 2010 11:36:28 GMT

no the value is not coming blank

still the query is not working i am facing such vierd problem

Jahnavee

Re: Query not working

birendra_chatterjee — Wed, 09 Jun 2010 11:43:14 GMT

Hi,

Check whether o_vbeln has leading zeroes in it.

For example if your billing document number is '900111' check in debug mode, that when your query gets executed the value of o_vbeln is '900111' or '0000900111'. This should be '0000900111'. If there are no leading zeroes, and the total length billing document number is less than 10 then this is nothing weird.

You have to use 'CONVERSION_EXIT_ALPHA_INPUT' to add leading zeroes.

Regards,

Birendra