topic Urgent : Query on select statement!! in Application Development and Automation Discussions

Urgent : Query on select statement!!

Former Member — Tue, 04 Sep 2007 16:18:39 GMT

Hi All,

i am trying to get the customer number from VBPA table into my work area based on vbeln and parvw values. but it is giving me an sysubrc value is 4.

here is my code :

select single kunnr into wa_i_vbpa

from vbpa

where vbeln = p_i_vbeln

and parvw = 'SP'.

Kindly check and let me know whether this is correct or not? if not, please correct it and send it to me back.

Thanks in advance.

Re: Urgent : Query on select statement!!

Former Member — Tue, 04 Sep 2007 16:22:23 GMT

HI Ramesh,

Use Conversion FM before the select statement in this way ...


CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
  EXPORTING
    INPUT         = p_i_vbeln
 IMPORTING
   OUTPUT        = p_i_vbeln

Re: Urgent : Query on select statement!!

ferry_lianto — Tue, 04 Sep 2007 16:23:08 GMT

Hi,

Please try this instead.


select single kunnr into wa_i_vbpa
from vbpa
where vbeln = p_i_vbeln
and parvw = 'AG'.

Regards,

Ferry Lianto

Re: Urgent : Query on select statement!!

Former Member — Tue, 04 Sep 2007 16:26:46 GMT

Try:


CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
  EXPORTING
    input  = p_i_vbeln
  IMPORTING
    output = p_i_vbeln.

SELECT SINGLE kunnr INTO wa_i_vbpa
  FROM vbpa
  WHERE vbeln = p_i_vbeln
    AND parvw = 'SP'.

Rob

Re: Urgent : Query on select statement!!

Former Member — Tue, 04 Sep 2007 16:30:35 GMT

Hi,

No its not working. still i am getting Sy-sUBRC is 4.

Re: Urgent : Query on select statement!!

Former Member — Tue, 04 Sep 2007 16:36:24 GMT

Ramesh,

As Ferry Lianto mentioned,

select single kunnr into wa_i_vbpa

from vbpa

where vbeln = p_i_vbeln

and parvw = 'AG'.

should work...Even after using this code, it doesn't work means there is no record in the database table with this selection.

Regards,

Vivek

Re: Urgent : Query on select statement!!

Former Member — Tue, 04 Sep 2007 16:38:26 GMT

Then there's no record there for these values.

Rob