Skip to Content
0

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

Dec 06, 2016 at 02:40 PM

98

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

K Jogeswara Rao Dec 07, 2016 at 04:30 AM
2

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.

Share
10 |10000 characters needed characters left characters exceeded
Edgar Agront Dec 07, 2016 at 04:15 PM
0

Jogeswara:

Thank you for your help.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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?

0
Peter Atkin Dec 08, 2016 at 04:23 PM
0

Edgar,

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

An image may help to show the issue..

PeteA

Share
10 |10000 characters needed characters left characters exceeded
Edgar Agront Dec 08, 2016 at 07:04 PM
0

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.


Share
10 |10000 characters needed characters left characters exceeded
Peter Atkin Dec 09, 2016 at 07:52 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Edgar Agront Dec 15, 2016 at 03:26 PM
0

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.


capture.jpg (80.5 kB)
Share
10 |10000 characters needed characters left characters exceeded