Skip to Content
avatar image
Former Member

Bex Query Prompt Values ( Removing Alpha Conversion)

Dear Experts,

I am facing an issue in my Bex query. Here we have used 0DEBITOR infoobject in query prompt.

This is 10 digit field and values that we have are six digit like 123456.

Whenever we have to enter in Bex prompt we need to write 0000123456.

If we put 123456 then it says value doesnot ecist.

Is there any way thorugh which we do not need to pass intial 0000 in beignning??

Thanks

Sumit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 10, 2015 at 02:09 PM

    Hi Sumit,

    There are two solutions for this issue.

    1)

    Generally system will automatically take care of conversion 12345 to 0000012345 but in your case not happened may be because of ALPHA conversion not maintained at 0DEBITOR infoobject.

    Please check that and maintain, for permanent solution.

    2)  Create customer exit variable

         In I_STEP 3, validate the all values as like below

    check each value length with the STRLEN function .

    case len

    when 1

    concatenate 000000000 , 1 into temp variable

    when 2

    concatenate 0000000 12  into temp variable

    ...

    ...

    when 10

    temp variable into low ,no need to prefix.

    basically we are concatenating absence values with 0(Zeros). after conversion send these values to E_T_RAGE table.

    Please try get help from ABAPer and write code

    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded