Skip to Content
author's profile photo Former Member
Former Member

Browser Tree not correct

I am retrieving the SAP PM Functional Location Tree and it is mostly correct but there is one functional location which is appearing as a separate tree on the browser applet (screen shots attached). In the output from the transaction I have the following for the item which is appearing as a separate tree

<Row>

<PARENT>0350-WHSE-BUILD -AIR CONDITION</PARENT>

<CHILD>0350-WHSE-AIRCON-COMPUTER ROOM</CHILD>

</Row>

<Row>

<PARENT>0350-WHSE-BUILD -AIR CONDITION</PARENT>

<CHILD>0350-WHSE-AIRCON-CONTROL ROOM</CHILD>

</Row>

<Row>

<PARENT>0350-WHSE-BUILD -AIR CONDITION</PARENT>

<CHILD>0350-WHSE-AIRCON-DISTRIBUTION</CHILD>

</Row>

<Row>

<PARENT>0350-WHSE-BUILD -AIR CONDITION</PARENT>

<CHILD>0350-WHSE-AIRCON-EXPORT OFFICE</CHILD>

</Row>

<Row>

<PARENT>0350-WHSE-BUILD -AIR CONDITION</PARENT>

<CHILD>0350-WHSE-AIRCON-MANAGERS AREA</CHILD>

</Row>

<Row>

<PARENT>0350-WHSE-BUILD -AIR CONDITION</PARENT>

<CHILD>0350-WHSE-AIRCON-OPS OFFICE</CHILD>

</Row>

<Row>

<PARENT>0350-WHSE-BUILD -AIR CONDITION</PARENT>

<CHILD>0350-WHSE-AIRCON-SCHEDULING</CHILD>

</Row>

.

.

<Row>

<PARENT>0350-WHSE-BUILD -FACILITIES</PARENT>

<CHILD>0350-WHSE-BUILD -AIR CONDITION</CHILD>

</Row>

The only difference I can see when comparing to the other items is that the text does not use 0350-WHSE-BUILD for the CHILD elements but I think this should not be relevant? I also attach an excerpt from the query which feeds the Browser. We did find some func locs which were also not integrated into the tree but these were marked as Obsolete in SAP and have now been moved under a new func loc. I cannot see any differences or incorrect data setup for this remaining func loc on SAP. Does the input to the Browser need to be ordered in any way?

I am using MII v12.1.9.108 on SAP ECC 6.0.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 02, 2014 at 03:25 PM

    Please ignore the first attachment (Output from Transaction screen shot.JPG) - this is not the output which gave the results for the second two attachments. These were as a result of sorting the output from BAPI_FUNCLOC_GETLIST in alphabetic order of parent. This means I am getting different results if I sort the information before passing to the Browser? Does this mean that I am seeing this situation because the parent of the func loc which is not being integrated appears after the child elements (because we have not been consisten in the text description for these ones)?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Ponilango P

      Unfortunately there were no unique ids returned from my SAP query so I have modified my MII transaction to export the returned hierarchy to an SQL table and I have created a stored procedure to "walk" the hierarchy and order it correctly for the browser. This has also facilitated a filter to remove some of the hierarchy items which I did not need. This is now working well. Many thanks again for your help. I have set your original answer to Correct Answer - do you know if I need to do anything to close this discussion now?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.