Select query

[Former Member]

Hi all there,

Can anybody tell me wat is problem with below select query

it is not selectin the data even itab-low has the value equal to vbeln .

select vbeln from vbap into corresponding fields of jtab where vbeln = itab-low.

select VBELN from vbap into (jtab-vbeln) where vbeln = itab-low.

[Former Member]

hi,

Make use of CONVERSION_EXIT_ALPHA_INPUT before using select staement ...

Regards,

Santosh

[Former Member]

Hi Santosh,

Can u explain in details I am using both the query inside the looop.

i don't undestand wat u said

[Former Member]

Hi,

do this way

loop at itab.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
  EXPORTING
    input         = itab-vbeln
 IMPORTING
   OUTPUT        = itab-vbeln
          .
select vbeln from vbap appending corresponding fields of jtab where vbeln = itab-vbeln.
endloop. 

[Former Member]

Can only guess but look at itab-low in debugging .

LOW should match VBELN exactly. Common

errors are different amount of leading zeros or , if alphanumeric, the char-orientation eg leading blanks.

Also, your query does not make sense ( hope thats just for example ). you select a field that you already have as qualifier - and no other fields...