Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from TerryB on Jun 18 at 6:08 PM MATNR, as you have mentioned, is an alpha-numeric field, and therefore it does not act like a numeric or NUMC field would. As far as leading zeros are concerned. I take it that the problem is that you have a bunch of existing materials with leading zeros in their MATNRs that are all numeric, and you are trying to update them from a non-SAP system (say, Excel, for instance) that interprets these all-numeric values as integers, and strips the leading zeros. Did I surmise correctly?
Once a material is used in transactional data, there is no "approved" way to change the MATNR value. It is usually necessary to deal with it either from the non-SAP system (for example, in Excel, define the column as "text" instead of "general" so that it no longer strips the leading zeros) or in coding in the receiving ABAP program.
If I completely misinterpreted your issue, please clarify the situation and I'll give it another try.
Cheers,
TerryB
| | | ---------------Original Message---------------
From: David Fuentes
Sent: Monday, June 18, 2012 5:55 PM
Subject: Leading Zeros from Alphanumerical Material
Hi All,
I need to remove the leading zeros from the alphanumerical material ids.
The system is set up without the lexicographical check box checked and the leading zeros is not checked either.
The issue is that for all the alphanumerical MATNR we need to add the leading zeros otherwise we get and error message saying that the material number in not in the correct range. As soon as we add the leading zeros the material is created accordingly.
How can you remove the leading zeros in the input and output? This is really annoying! |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
