Skip to Content
author's profile photo Former Member
Former Member

temporarily disable automatic matnr matn1 conversion

is there a way to temporarily disable automatic matnr conversion? when user input 747 in matnr, behind the scene it put 000000747, is there a way to temporary disable the conversion without programming?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Oct 19, 2005 at 05:50 PM

    It depends on where you want this. Please explain your scenario in detail. Where do you want the conversion to be disabled and for what purpose?

    If you are using a field referring to a database field that has a conversion routine associated with it, then you don't have an option except to code. I don't think you can avoid it without coding.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 05:58 PM

    i have a custom table which refer to matnr. this table is loaded outside of SAP, the material number is store without leading zeros. when user user abap query to select material#, it do a automatic conversion. e.g. input 747, it translate to 0000000747. I want to disable the automatic conversion in abap query. i don't think it is possible. i am using 3.1h sap

    Add a comment
    10|10000 characters needed characters exceeded

    • I think you need to change the way you insert records into this table. You need to convert the material number into internal format before inserting it into the table. This is a mistake that happens lot of times with custom tables. If material number is part of the key fields, then it will be even more difficult. Let us say you have a record with matnr as 1234. Now you want to update this record through SM30. System brings up the record, you make changes to the some non-key fields and save it. Systems issues the message 'Data Saved', but if you check, the data will not change. This is because of the conversion.

      You need to change your program that inserts records into this table to convert the material number into internal format before inserting.

      For the existing records, you will have to do a conversion either programatically or through SM30(if maintenance is allowed). In SM30, bring all the records in change mode. Select all of them and then press copy. Now you will have two sets of records. They all look the same, but you will have select the first set(it will still remain as selected) and delete them. You then save. Your table should now have the records in the internal format.

      Srinivas

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.