on 01-10-2015 11:43 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.