Remove zero leading

[Former Member]

The length of the Material Master is 18 Char in R/3. It will start will zero, i.e. 000000001008119839

This will be extracted into PSA with zero leading, then loaded and stored in Material Master InfoObject Master Data as 000000001008119839. When I display this in the query, it will display as 000000001008119839.

In the Query Designer, is there a way for me to remove the zero so that it will display as 1008119839?

Please advice, thank you.

[former_member205352]

You can adjust the material display using transaction OMSL.

Try using it.

Hope this helps.

[former_member207028]

HI,

for 0MATERIAL infoobject, see in General tab any conversion Routine exists.

in our case we have conversion routine : MATN1 and output length 18 is there, it will supress leading zeros.

hope this helps

Regards

Daya Sagar

[Former Member]

Hi Daya,

All I need to do is just to assign the mentioned routine in the InfoObject? Is there any other programming/steps required during the loading/updating process?

This might be a option for the incoming Material Master but I already have some 5000 Material Master loaded and used in the system already...

[Former Member]

nope, you just need to add it there... but, if it's 0MATERIAL it should have been there in the first place?!

and it has nothing to do with loading data... it's just a "display" feature... conversion exits are used to "convert" between internal (SAP) and external (user interface) format... so before displaying anything to the screen, the system checks for conversion exits... those 5000 materials will be just fine

Edited by: RafB on Oct 10, 2008 2:33 PM

[p_m8]

I have the MATN1 assigned in 0Material.

In the P table of this InfoObject Master Data, I can see the Material # 000000001950002134 is stored in the 0Mateial.

When I display the Material Master query created from the Query Designer, I still have the following display on the screen:

000000001950002134

The zero is still there infront of the Material Number.

What could be wrong? Please advice.

[Former Member]

>

> When I display this in the query, it will display as 000000001008119839.

do you mean it displays this in the query result? or just in the query definition?

the latter won't really hurt, will it? if it shows you that in the query result, the next question would be how are looking at those results: in Analyzer, Report Designer, Web Application Designer, Portal?

[Former Member]

RafB,

It is stored 000000001008119839 in the InfoObject now.

Query is developed in the Query Designer. When I execute this Query from the Query Designer, I see 000000001008119839 in the result.

How can I suppress the zero in Query Designer?