EAM IH08 report download

[Former Member]

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

[Former Member]

Ok will take care

[JL23 · Accepted solution]

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.

[Former Member · Accepted solution]

Hi,

I checked with given solution but while saving in excel getting same problem.

Regards,

Ganesh

[JL23 · Accepted solution]

You must have done a mistake then as Excel only converts a number this way but does not do it for a text.

Can you attach your text download here then I will try it with the file and show it with Video how it is done

[Former Member · Accepted solution]

equi.txt

Hi please find attached.

Regards,

Ganesh

[JL23 · Accepted solution]

As promised, here is the video: https://youtu.be/rpmMMObRL-M

Excel is in German language, but everything what I show is in the same place in an English language version too.

The one thing that I did with the keyboard was to enter a vertical stroke for field separation

[Former Member · Accepted solution]

Hi,Jurgen L,

Excellent you tube link.now its worked ok.

Thanks a lot.

Regards,

Ganesh

[former_member459198]

Please keep apostrophe ' before equipment number

A1 A2 A3

' 100 =A1&A3

This should work

[former_member459198]

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

[manoj_kalluri]

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.

[Former Member]

Hi Manoj,

i have check with all even i expand this last digit of every equipment number shown zero value,instead of 1 or 2 or any.

Regards,

Ganesh

[manoj_kalluri]

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

[peter_atkin]

Ganesh,

Strange - it worked fine for me..

Does the report have to be run in background?

PeteA

[Former Member]

Hi Peter,

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

Regards,

Ganesh

[Former Member]

Hi Peter,

Thanks for reply,

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

Regards,

Ganesh

[peter_atkin]

Export as HTML, then import into Excel.

[Former Member]

Hi i have run IH08 report in background

Regards,

Ganesh

[peter_atkin]

What do you mean by "with speed sheet"?

PeteA