Select statement on VBPA

[Former Member]

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]

Hi

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_member183607]

Hi,

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

[Former Member]

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

[raymond_giuseppi]

Actually BOTH fields have conversion exit, so

• VBELN ->ALPHA -> CONVERSION_EXIT_ALPHA_INPUT -> '12' -> '0000000012'
• PARVW  -> PARVW -> CONVERSION_EXIT_PARVW_INPUT -> 'SH' -> 'WE'

Regards,

Raymond

[Former Member]

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

Best regards,

Thomas Wagner