cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Query Prompt Values ( Removing Alpha Conversion)

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

ccc_ccc
Active Contributor
0 Kudos

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