<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi Brad,
<br>U have to write recursive function module to find out the top-level
org unit.
<p>Tables which is using the relationship is HRP1000 and HRP1001
<p>HRP1000 is for creating the structure and HRP1001 is for relationship
to the object
<p>If u need any further detail let me know
<br>Thanks
<br>Rakesh
<br>
<br>
<p>"Schroeter, Brad" wrote:
<blockquote TYPE=CITE>
<p><font face="Arial"><font size=-1>I've got an org structure like this:</font></font>
<br><font face="Arial"><font size=-1>Org unit 50000000 (top-level)</font></font>
<br><font face="Arial"><font size=-1>|__Org unit 50000001</font></font>
<br><font face="Arial"><font size=-1>|__Org unit 50000002</font></font>
<br><font face="Arial"><font size=-1>|__Org unit 50000003</font></font>
<p><font face="Arial"><font size=-1>Let's say I'm currently using org unit
50000000, I'm in a custom method and I want to find if it's the top-level?
Is there a database select statement to one of the HRP* tables or a function
module that will give me the info?</font></font>
<p><font face="Arial"><font size=-1>Thanks,</font></font>
<br><font face="Arial"><font size=-1>Brad</font></font></blockquote>
</html>