Skip to Content
avatar image
Former Member

EAM IH08 report download

Dear Experts,

while downloading IH08 report for equipment list in excel format with speed sheet the equipment numbers shown in excel format as 1E+15 and last digit of every equipment show 0 actual value is 1 or 2 or 3.

Please reply

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    Nov 08, 2017 at 10:13 AM

    I guess this is more a usage problem of Excel than a SAP question.

    open an empty Excel and just type 1000000000000000 into the first cell, press enter and you see the same happen.

    Just download it uncoverted.

    Then use the Excel data import from text. This brings up the import assistant and when you define your columns, which is the 3rd step, then switch the radio button for the equipment number field from standard to Text.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2017 at 12:31 PM
    -1

    Export as HTML, then import into Excel.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2017 at 02:30 PM
    -1

    Can you try to save in Rich format text which saves in notepad then open file in excel?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2017 at 03:16 PM
    -2

    Please keep apostrophe ' before equipment number

    A1 A2 A3

    ' 100 =A1&A3

    This should work

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2017 at 08:33 AM

    Ganesh,

    Strange - it worked fine for me..

    Does the report have to be run in background?

    PeteA

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Peter,

      this report has been run in background because having much more entries.

      Regards,

      Ganesh

  • Nov 07, 2017 at 10:50 AM

    What do you mean by "with speed sheet"?

    PeteA

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 07, 2017 at 12:09 PM

    Hi i have run IH08 report in background

    Regards,

    Ganesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 08, 2017 at 07:18 AM

    Hi Peter,

    Thanks for reply,

    i have export as HTML and same as imported in excel still in excel showing the same.

    Regards,

    Ganesh

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2017 at 07:28 AM

    Expand the corresponding Column Size in the Excel sheet; you will get it. It is not the problem with SAP. It might be only Excel Issue.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ganesh ,

      Is the Problem is still repeating.

      I guess the only option left is You can use the format as "unconverted" and while saving use the type as "Excel", Just try it once. One more thing can you please check giving as Equipment Number Externally with all Non -Zeros.

      Regards

      Manoj