topic Re: Removing Padding Zeros from RFC input in Application Development and Automation Discussions

Removing Padding Zeros from RFC input

Former Member — Fri, 19 Sep 2008 06:12:43 GMT

Hi,

I have written one RFC which accepts PERNR as input and gives some records in a output table.

My query is

SELECT pernr vorna from pa0002 into CORRESPONDING FIELDS OF TABLE Z_PD_TABLE WHERE pernr Like 'InputValue'

When i enter 12, input value automatically becomes '00000012'. i want such values which contains 12 in it.

Any help??

Prashant

Re: Removing Padding Zeros from RFC input

Former Member — Fri, 19 Sep 2008 06:18:37 GMT

PERNR is a numc 8 field that's why u r getting 00000012 after entering 12.

Use input field as type c field.

Regards,

Joy.

Re: Removing Padding Zeros from RFC input

Former Member — Fri, 19 Sep 2008 06:29:35 GMT

Hi,

Other use this abap command before query


SHIFT <InputValue> LEFT DELETING LEADING '0'.

SELECT pernr vorna from pa0002 into CORRESPONDING FIELDS OF TABLE Z_PD_TABLE WHERE pernr Like 'InputValue'



CONVERSION_EXIT_ALPHA_OUTPUT Conversion exit ALPHA, internal->external

call function 'CONVERSION_EXIT_ALPHA_OUTPUT'
  exporting
    input  = <InputValue>
  importing
    output = <InputValue>.

Hope it will helps

Re: Removing Padding Zeros from RFC input

Former Member — Fri, 19 Sep 2008 06:34:10 GMT

Thanks for the help

Re: Removing Padding Zeros from RFC input

Former Member — Fri, 19 Sep 2008 06:34:50 GMT

HI ,

USE THIS FM: 'CONVERSION_EXIT_ALPHA_INPUT'

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

input = wa_crrb_audit-cust_acct_id

IMPORTING

output = wa_crrb_audit-cust_acct_id.

IT WILL DEFINATELY HELP YOU

regards

Rahul Sharma