Triming Leading Zeroes

[Former Member]

Hi,

We have a query which uses a variant to accept a value for a field by the name of Internal Order. In our Cube the data for this field is stored with leading Zeroes e.g. '0002000'.

When the user enters the value for this variant without the leading zeroes e.g. 2000 instead of 0002000 then the query does not return any output. But if the leading zeroes are entered then the query returns the results.

How do we trim the leading zeroes while checking from the field in the cube.

One more thing the query does not return any error while executing if leading zeroes are not entered.

Thanks & Regards

Raj

[Former Member]

Hi,

you can try to change the field definition to number, because in an number field you don't have to type the leading zeros .

( I assume you defined the field as character, because in an char field you have to type the leading zeros.)

Reguards

Sebastian

[Former Member]

Use ALPHA, conversion routine in the Infoobject , this would automatically enable users to enter data without leading zeros.

[Former Member]

I would recommend using ALPHA conversion also. Why delete something if you don't have to, it's dangerous. Plus, in your transfer rules, you can just check a box.

If you need to code it, you can use function module 'CONVERSION_EXIT_ALPHA_INPUT'.

Brian