Browser Tree not correct

[Former Member]

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.

[Former Member · Accepted solution]

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)?

[ponilango_p · Accepted solution]

Hi Richard,

Using only text nodes for filtering nodes in a iBrowser tree will cause such problems.

As you may know we can use up to 4 XML column values to form an iBrowser tree, for example using

Node Name, Node Id, Parent Node Name & Parent Node Id as the display columns.

With this you will have an option to sort/filter the functional locations by their unique ids - (External object ids or other unique object Ids associated can be put to use).

Even then the hierarchy of the nodes may depend upon the sequence of creation which determines these Ids. You may have to use some custom logic to organize the nodes as desired.

Best of luck on your trials.

With regards,

Ponilango P

[Former Member · Accepted solution]

Ponilango P

Many thanks for your helpful reply. I will try and use some custom logic as you suggest.

Cheers

Richard.

[Former Member · Accepted solution]

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?