Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

leading zeros-master data

Hi All,

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.


Former Member
Not what you were looking for? View more on this topic or Ask a question