Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Dec 20 at 2:09 PM We should stop posting in this thread until our OP gives us more information about the issue (and ... if any post helped in solving the problem too).
Otherwise, we're just guessing...and wasting a lot of time.
@Ralph, I believe you could check your posts. Some of them were obviously wrong (For example, that one suggesting to remove the "M" in the material number, not only because you were removing the last character ... and the M was the first character in the mat. number., but also because you were finishing with a totally different material number. If there were associated records - rows ? - in mseg or somewhere else, you'd be losing them. ) I mean, keep on posting, we need new flesh here :), but check the answer before posting it (as we're supposed to help our peers, not to mislead them)
Regards,
Horacio
| | | ---------------Original Message---------------
From: john.louk
Sent: Thursday, December 20, 2012 10:36 AM
Subject: Add Zeros to a Field in Internal Table
I believe it also had a dash in it. Also, we have not heard back from the OP as to whether any of the suggestions helped. Nor, has the OP anwsered any of the questions. This issue with the leading zeroes would be if the field was then going to be used to select data in SAP as leading zeroes with non-numeric value still in the field would not work in selecting SAP material data. Unless, you change SAP's conversion routine (MATN1) which is two function modules.
Honestly too me an easy solution (if you really had to do this; I am not sure that I see a reason to do this) is below.
It is a character field length 18.
Shift right deleting trailing space (check sfull statement syntax).
translate <field> using ' 0' (there is a blank space before the zero). or use the REPLACE cammand either is fine (check sfull statement syntax).
Cheers
John |
| Reply to this email to post your response. __.____._ |   _.____.__ |
