very small doubt

[Former Member]

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

[kostas_tsioubris]

Hi,

you should give v_vbeln = '0090000613'.

regards

Kostas

[Former Member]

thanx

[Former Member]

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

[Former Member]

hi

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

[Former Member]

thankx sir!!

[Former Member]

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

[Former Member]

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

[Former Member]

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