topic Re: very small doubt in Application Development and Automation Discussions

very small doubt

Former Member — Wed, 04 Apr 2007 13:21:44 GMT

Hi all,

I m facing a very small / silly / very imp doubt.

Plz go through the follwing code and help me.

REPORT ZTEST_SELECT.

parameters : p_vbeln type vbeln.

data : v_adrnr type adrnr,

v_vbeln type vbeln.

v_vbeln = '90000613'.

SELECT single adrnr FROM vbpa INTO v_adrnr where vbeln EQ v_vbeln.

Write : 'sy-subrc:',sy-subrc,

/ v_adrnr.

Error: for paramaters , its working fine.

If i give vbeln directly (hardcoding) its not fetching data.

Thanks

Re: very small doubt

kostas_tsioubris — Wed, 04 Apr 2007 13:24:30 GMT

Hi,

you should give v_vbeln = '0090000613'.

regards

Kostas

Re: very small doubt

Former Member — Wed, 04 Apr 2007 13:24:38 GMT

Hi try this..

<b>v_vbeln = '0090000613'.</b>

as it is of type C of size 10.

while u r using screens it will take care of leading zeroes(in case of parameters).

But , when u hard code u need to take care of zeroes also...

Message was edited by:

Rammohan Nagam

Re: very small doubt

Former Member — Wed, 04 Apr 2007 13:25:35 GMT

check in ur database table if there are any laeding zeros in vbeln hard coded value.

if yes give them too

regards

navjot

reward if helpfull

Re: very small doubt

Former Member — Wed, 04 Apr 2007 13:26:35 GMT

thankx sir!!

Re: very small doubt

Former Member — Wed, 04 Apr 2007 13:26:45 GMT

Hi,

REPORT ZTEST_SELECT.

parameters : p_vbeln type vbeln.

data : v_adrnr type adrnr,

v_vbeln type vbeln.

v_vbeln = '90000613'.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT.

exporting

field = v_vbeln

importing

field = v_vbeln

SELECT single adrnr FROM vbpa INTO v_adrnr where vbeln EQ v_vbeln.

Write : 'sy-subrc:',sy-subrc,

/ v_adrnr.

Regards

Sudheer

Re: very small doubt

Former Member — Wed, 04 Apr 2007 13:27:31 GMT

thanx

Re: very small doubt

Former Member — Wed, 04 Apr 2007 13:27:51 GMT

REPORT ZTEST_SELECT.

parameters : p_vbeln type vbeln.

data : v_adrnr type adrnr,

v_vbeln type vbeln.

v_vbeln = '90000613'.

You have to use the appropriate conversion exit to get the leading zeroes

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = v_vbeln

importing

output = v_vbeln

exceptions

others = 1.

SELECT single adrnr FROM vbpa INTO v_adrnr where vbeln EQ v_vbeln.

Write : 'sy-subrc:',sy-subrc,

/ v_adrnr.

CONVERSION_EXIT_ALPHA_INPUT

Re: very small doubt

Former Member — Wed, 04 Apr 2007 13:28:14 GMT

Hi ,

The reason for this is when you give a parameter or select option the input automatically gets converted to the internalt format.

What i would suggest , put a paramater and debug the program and see what is the value of your parameter.

This will help you better.

Regards

Arun