topic Re: Help with a very basic select in Application Development and Automation Discussions

Help with a very basic select

Former Member — Fri, 13 Jul 2007 20:35:36 GMT

Hi, I am embarrassed to say this but I can't figure out why this select isn't working.

SELECT single adrnr INTO w_adrnr FROM lfa1
  WHERE lifnr = w_lifnr.

I know that I have a match in LFA1 where LIFNR = W_LIFNR but the select will not return anything. Can you tell me what [obvious] mistake I have made?

Regards,

Davis

Re: Help with a very basic select

Former Member — Fri, 13 Jul 2007 20:40:11 GMT

Davis,

did you see data at SE11 ? if so then use

Use Below FM -> pass CONVERSION_EXIT_ALPHA_INPUT

give input w_lifnr and output is w_lifnr

SELECT single adrnr INTO w_adrnr FROM lfa1

WHERE lifnr = w_lifnr.

now see the results

Thanks

Seshu

Re: Help with a very basic select

Former Member — Fri, 13 Jul 2007 20:40:48 GMT

Just a guess - but does w_lifnr contain the leading zeroes?

Rob

Re: Help with a very basic select

Former Member — Fri, 13 Jul 2007 20:42:36 GMT

Seshu, thanks for the reply. Can I call this function module inside a SmartForm? I just tried it and it gives me a syntax error saying that CONVERSION_EXIT_ALPHA_INPUT is unknown. I guess maybe I need to put it in the global definitions?

Regards,

Davis

Re: Help with a very basic select

Former Member — Fri, 13 Jul 2007 20:42:54 GMT

It's working man...

data: w_ADRNR like lfa1-ADRNR.

parameters: w_lifnr like lfa1-lifnr.

start-of-selection.

select single adrnr from lfa1 into w_adrnr where lifnr = w_lifnr.

check sy-subrc eq 0.

write:/ w_adrnr.

Re: Help with a very basic select

Former Member — Fri, 13 Jul 2007 20:43:15 GMT

No it doesn't, I guess that is the problem.

Rob, thanks for the help. I didn't even think about the leading zeros. Now I feel even dumber than I did 10 minutes ago.

Davis

Message was edited by:

Davis

Re: Help with a very basic select

ferry_lianto — Fri, 13 Jul 2007 20:44:47 GMT

Hi,

Your coding seems fine

How did you declare W_ADRNR and W_LIFNR?

Please check table LFA1 (SE16) and see whether you have record for the corresponding LIFNR.

Regards,

Ferry Lianto

Re: Help with a very basic select

Former Member — Fri, 13 Jul 2007 20:45:38 GMT

Try:



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

SELECT SINGLE adrnr INTO w_adrnr FROM lfa1
  WHERE lifnr = w_lifnr.

Rob