5 Replies Latest reply: Apr 14, 2014 6:04 AM by Jerry Lau RSS

    alphanumeric field from sap

    Jerry Lau

      hello all


      i have problem in loading data

      in material master, the material code can be numeric, alphabetical or a combination of both

      so when i load from e.g. MARA, the material code (matnr) will read as a text

      numeric values come with preceding zeroes, which is not what i want

      i try loading with:

      if (IsNum(matnr), 'Y', 'N')

      but the result shows that all data cannot be recognized as numbers

      how can i perform loading to make numeric values remove the preceding zeroes?


      thank you