topic Re: Select statement on VBPA in Application Development and Automation Discussions

Select statement on VBPA

Former Member — Thu, 28 Aug 2014 12:00:27 GMT

Hi all,

I have written select statement on VBPA table, it not working as expected.

my code:

data wa type land1.

Select land1 from VBPA into wa where vbeln = 12 and parvw = 'SH'.

Endselect.

write: 'Destination', wa.

when i keep where part it is not working, i mean result is empty.

Thanks & regards,

NarsiReddy.

Former Member — Thu, 28 Aug 2014 12:06:56 GMT

VBELN is a NUMC type field. You should have '(00)00000012' in the WHERE clause (don't remember if it is 10 or 8 characters).

And if you only want to get the first record that matches your criteria better user SELECT SINGLE.

regards

Former Member — Thu, 28 Aug 2014 12:07:48 GMT

Hi,

Check Vbeln field is having conversion routine pass vbeln = '0000000012'

Former Member — Thu, 28 Aug 2014 12:25:27 GMT

USE vbeln = '0020000001' STRING VALUE OR USE FM CONVERSION_EXIT_ALPHA_INPUT

RaymondGiuseppi — Thu, 28 Aug 2014 12:34:01 GMT

Actually BOTH fields have conversion exit, so

Regards,

Raymond

Former Member — Thu, 28 Aug 2014 12:57:34 GMT

I assume you tested if you get a result when you enter this in SE16?

Best regards,

Thomas Wagner