Skip to Content
avatar image
Former Member

How to create an Excel table with all functional locations under the same column

I need to create an Excel table with all functional locations, but what I got is a list of F/L in different columns according to their hierarchy. I need all of them under the same column.

Any help is appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Dec 07, 2016 at 04:30 AM

    Your explanation tells that you are trying IH01 output to Excel.

    Instead you try IH06 output, you will get the info properly in Excel columns.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 07, 2016 at 04:15 PM

    Jogeswara:

    Thank you for your help.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Jogeswara:

      I noticed that when I input a list of f/l starting with the parent f/l, and ending with the last subordinate f/l in the selected range, then I got f/l that does not within the range, they somehow are inserted into the column. Any explanation why this happen?

  • Dec 08, 2016 at 04:23 PM

    Edgar,

    I'm assuming you mean in SAP, not Excel??

    An image may help to show the issue..

    PeteA

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2016 at 07:04 PM

    See the attached files, they are in chronological order.

    fl-range.jpg

    fl-range-in-ih06.jpg

    fl-outside-range.jpg

    As you can see there are many FL after running tcode IH09 that does not belong to the range.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 09, 2016 at 07:52 AM

    Edgar,

    They are in the range..

    You have from OB01-00-01 to OB01-00-1011*

    Which means that it covers all of OB01-00-01, OB01-00-02, OB01-00-03, all the way to OB01-00-1011..

    Try a range of OB01-00-01* only.

    PeteA

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 15, 2016 at 03:26 PM

    Peter:

    It may sound strange, but if you look at the attached picture you will find the right picture have F/L which are not part of the F/L on the left picture. I understand the way the structure was created is the cause of having more F/L than the one I originally picked in the left picture.

    Add comment
    10|10000 characters needed characters exceeded