Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 07, 2014 at 05:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2016 at 12:45 PM

    For RTF export, you can implement the SAP Note :

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2013 at 01:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 19, 2014 at 10:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello  M.Ezzat,

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

      Thanks

      S.BASIS

  • avatar image
    Former Member
    Sep 19, 2014 at 07:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2013 at 01:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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 ?

  • avatar image
    Former Member
    Oct 29, 2013 at 01:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 19, 2014 at 11:19 AM

    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 ...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2014 at 02:07 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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