leading zeros-master data
We have a characteristic 'Material'(custom defined master data infoObject) of length
10,Conversion routine:ALPHA, datatype :CHAR,& output length:10.
Requirement is Material number should be displayed as 10 digit number(characters ) in Bex
but for some of the materials,we don't have 10 digits for example we have a material
123(this 123 should be seen as 0000000123 in Query output).
When i am displaying infocube contents or master data contents i could see 123 as
0000000123. but with F4,it shows 123 as 123 and in Query output also as '123'
1.actually How data will be stored in infocube and master data tables? (either 123 or
2. one soution to display matarial as 10 char in report is with transfer/update routine by
adding leading zeros.
Is there any other way to achieve this without using routine ?kendly let me know.
correct me if my above asumption is wrong.