Query not working

[Former Member]

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

[Former Member]

help

[Former Member]

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.

[birendra_chatterjee]

Hi,

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

Regards,

Birendra

[Former Member]

no the value is not coming blank

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

Jahnavee

[birendra_chatterjee]

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