Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Import Transport History and Export Excel

I would like to export my STMS Transport History into an Excel format.

The return code doesn't appear when i'm a using spreadsheet format (it's gif image).

I have tried to export with HTML format and find/replace

<img src='s_s_ledg.gif'> by 0

<img src='s_s_ledy.gif'> by 4

<img src='s_s_ledr.gif'> by 8

Then i convert this file into a XLS file. It is working but it is a bit long.

I have seen that some administrators using tpalog table but this isn't match with STMS Transport (i have more entries in TPALOG).

I would like to know if you have a tool, a script or a tip to have my transport history in Excel quickly.

Thank you for your response.

Tags:
Former Member
Former Member replied

For easy solution read below

  1. Save the import history with RTF format
  2. Open the RTF file , select “Web Layout Format(bottom right , 3rd Icon)” , so that you can see the whole table (see below)

3. Copy the whole table in excel sheet , you should be able to see some text under RC column (as seen below)

4. 5D mean Yellow , 5B means green and 5C means red

5. Now use this formula to alter the content in next column  =IF(F2="5B","0",IF(F2="5D","4",IF(F2="5C","8")))

Points.. If it helps !!

Victor

2 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question