Leading zeroes

[Former Member]

Hey Team,

On My report the 0material does not show up as 18 chars with the leading zeroes.?

What is the setting I'm missing.?

Same goes with Material group...it has to be 3 chars...and the leading zero is missing..

EX: Material shows up as 123456789 instead of 000000000123456789

and Mat grp shows up as 12 instead of 012.

Thanks

/Tb

[former_member207028]

Hi,

check the data for 0Materila and Material group in Source system (R/3) at infoobject level and at Report level.

infoobject change mode -> general tab check ALPHA conversion is enabled or not, if enabled remove and activate infoobject and load data and check in report.

Regards

Daya Sagar

[Former Member]

Thanks guys!!!..

for the pointers....

-tb

[Former Member]

any ideas pros.....

thnx

Tb

[Former Member]

Hi,

Do you know any thing about ALPHA Conversrion??

- Check the data in your Cube, if the data in cube is same as in reports, check transformations

- Check the transformations, if there are any routines used to do some ALPHA CONVERSION, if there is transformations logic used

- Check the data in source system(eg: R/3.)

If you want to add leading zeros to you info object, you can achieve this by writing simple ABAP routine in transformations

use function module CONVERSION_EXIT_ALPHA_INPUT

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
                EXPORTING
                  input         = 0material
                IMPORTING
                  OUTPUT        = 0materail

[Former Member]

Is there any "conversion routine" @ General tab in master data.

In case you have a conversion routine(like Alpha or Matn1), then its removing the ZERO's and hence u cant see in reporting.

E.g.: If you need values of material without zero's in infocube(s), then you have to specifically write Conversion routine during mapping so that cube doesnt have zero's.

Cheers.