topic Re: Select query in Application Development and Automation Discussions

Select query

Former Member — Fri, 02 May 2008 12:31:17 GMT

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.

Re: Select query

Former Member — Fri, 02 May 2008 12:35:53 GMT

hi,

Make use of CONVERSION_EXIT_ALPHA_INPUT before using select staement ...

Regards,

Santosh

Re: Select query

Former Member — Fri, 02 May 2008 12:37:50 GMT

Hi Santosh,

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

i don't undestand wat u said

Re: Select query

Former Member — Fri, 02 May 2008 12:39:59 GMT

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.

Re: Select query

Former Member — Fri, 02 May 2008 12:46:14 GMT

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...