Import Transport History and Export Excel

[Former Member]

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.

[Former Member · Accepted solution]

For easy solution read below

1. Save the import history with RTF format
2. Open the RTF file , select “Web Layout Format(bottom right , 3^rd 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

[former_member233991]

For RTF export, you can implement the SAP Note :

2266845 - RTF download: Adjustment of colors and icons as graphics

[Former Member]

Hi March,

According to me you can get this done in 2 ways.

• Tcode: STMS_IMPORT --> Import history (Ctrl+F7).
• Export the llist using Right click --> Right click --> Save to PC file --> HTML format.
• Than open the file in Excel and now...
• First according to the ICON in RC Column change the cell value to RC0 or you can color it GREEN with some manual step (Image: HTML_Import_history).
• You can either keep the icon generated from SAP or you can delete them using below macro

               ActiveSheet.Shapes.SelectAll

               Selection.Delete

OR

• Export the llist using Right click --> Right click --> Save to PC file --> RICH TEXT format.
• open the File in Word copy the list and paste it in EXCEL,
• Now in excel write a macro to replace the cell content of RC column to desire value/color, etc. (Image: RTF_Import_history)
• Here I have used Conditional formating from Home menu in EXCEL
• You can also write a macro in excel to automate this..

          Sub ChangeColor()

          lRow = Range("C" & Rows.Count).End(xlUp).Row

          Set MR = Range("C2:C" & lRow)

               For Each cell In MR

                    If cell.Value = "AAAA" Then cell.Interior.ColorIndex = 10

                    If cell.Value = "BBBB" Then cell.Interior.ColorIndex = 3

              Next

          End Sub

You can then use the same excel sheet again and again...

Hope this is what you're looking for.....

Regards,

Prithviraj.

[Former Member]

Go to System >List > Save Local File and select spreadsheet as below:Hope it has helped out.

[Former Member]

I'm not sure you have understood my problem.

I know how to export in Excel but the problem is the RC doesn't appear. Do the test.

I don't want to have a picture or a "W", I want a return code :0, 4 or 8.

Is anybody can help me ?

Thank you

[former_member200876]

Dear Marc

after execute Tcode STMS and select the required Server ( DEV / QAS / PRD )

you will see all the transfer requests

from  Edit menu select display More

you will see the following :

every character has a meaning when you click the character , you will see the meaning

2 = Request already imported

W = request waiting for import

etc ...

[former_member200876]

Dear Marc

after execute Tcode STMS and select the required Server ( DEV / QAS / PRD )

you will see all the transfer requests

Right click and choose Save to PC file shift+F8

after this select Spreadsheet

the follow the other steps

Best regards

M. Ezzat

[Former Member]

Hello  M.Ezzat,

We all are following same procedure, but RC values not reflecting.  Please suggst

Thanks

S.BASIS

[Former Member]

Hi,

Why the data is not coming as the gif image is not downloaded .

Try the below steps.

list -> save -> local files

then select the html option.

when it ask you to save it save is as name.MHTML

and then giver enter.

Now you will see that the gif images also get exported now you need to open that file in excel . It might take some time to open the excel as its analysing the file and adjusting it.

Once the file is open save it as save as excel and then your excel is ready.

Thanks

Rishi abrol

[Former Member]

Hello  Rishi,

But converted excel is not editable. Pls suggest

Thanks

S.Basis

[Former Member]

Hi,

Look at table TPALOG with Tx SE16. The import history uses this table...

Also try to filter by the status of RC(Return codes) from Import history and

download it in Excel.

BR,

Prabhakar

[Reagan]

Are you trying to get the data from the STMS - Import history ?

I normally take the data by entering %pc in the transaction code field and then use the option it gives eg: clipboard

Is that what you are looking for ?

Regards

RB

[Former Member]

Yes i try to get the data.

But return code don't appear with %pc transaction.

[Former Member]

Hi Marc,

Please try to save in .HTM format, this one will display color icons of the return code as they appear in STMS import history.

Hope this helps.

Adil

[Former Member]

No Nayeem, read my message again.

I already do what you say but i want an Excel spreadsheet.

Nobody have a script for that ?