topic Re: Group hierarchy level in Application Development and Automation Discussions

Group hierarchy level

Former Member — Tue, 18 Nov 2008 04:45:45 GMT

Hi All,

Is there any table which stores the Group hierarchy level details which get displayed in KSH3.

Thanks in advance,

Rahul.

Re: Group hierarchy level

satsrockford — Tue, 18 Nov 2008 05:01:23 GMT

refer this thread:

hope it helps..

regards

Satish

Re: Group hierarchy level

Former Member — Tue, 18 Nov 2008 05:08:11 GMT

check the below tables:

FMZUGR

FMZUOB

GB903

RWSHEADER

SETNODE

SETLINET

Re: Group hierarchy level

raviprakash — Tue, 18 Nov 2008 05:11:47 GMT


> Hi All,
> Is there any table which stores the Group hierarchy level details which get displayed in KSH3.
> 
> 
> Thanks in advance,
> Rahul.

Hi Rahul,

The table which gives details for the transaction KSH3 is SETHEADER.

Regards,

Ravi.

Re: Group hierarchy level

Former Member — Tue, 18 Nov 2008 05:17:20 GMT

Yes There is Setheader / setheadert table which maitains the highest hierarchy level.

Than Setleaf table for lower hierchy levels.

here it is one example for both queries.

SELECT setname setclass descript FROM setheadert INTO TABLE i_setheadert
        WHERE setclass = '0106' AND setname IN s_setnme AND langu = 'EN'.

SELECT setclass setname valfrom  FROM setleaf INTO TABLE i_setleaf
          FOR ALL ENTRIES IN i_setheadert WHERE  setclass = i_setheadert-setclass
            AND  setname IN s_setnme AND valfrom = p_rprctr .

join both like above queries.

Re: Group hierarchy level

Former Member — Tue, 18 Nov 2008 05:19:59 GMT


> hi
> 
> refer this thread:
> 
> 
> 
> hope it helps..
> 
> 
> regards
> Satish

Wrong link posted.

Re: Group hierarchy level

Former Member — Tue, 18 Nov 2008 16:53:56 GMT

Hi,

Thanks for your reply.

Is there a way where in i wil be able to get these group hierarchy levels using my cost center.

Thanks in advance,

Rahul.

Re: Group hierarchy level

Former Member — Tue, 18 Nov 2008 17:44:43 GMT


> Is there a way where in i wil be able to get these group hierarchy levels using my cost center.

Yes,

First Get highest level hierarchy from SETHEADER table than read SETLEAF for all SETHEADER-SETNAME with SETLEAF-SETNAME and get cost centers in setleaf-valfrom.

Cheers

Re: Group hierarchy level

Former Member — Thu, 27 Nov 2008 06:35:05 GMT

Hi Amith,

I tried your previous method but it dint quite work or may be i am not clear abt it.

This is my scenario I have my cost center group, I will have to fetch the group hierarchy levels for each of the cost centers which belong to this cost center group.

Towards the end i should have my cost center and their corresponding group hierarchy levels.(As we see in KSH3)

Is there any FM or a BAPI for this?

If a query can do it then can u please guide me...

Thanks in Advance,

Rahul

Re: Group hierarchy level

Former Member — Thu, 27 Nov 2008 11:01:06 GMT

Hi All,

Im using BAPI_COSTCENTERGROUP_GETDETAIL.

This gives the list of cost centers in one internal table and the other internal table returned by this

BAPI contains the Group name(Hierarchy name ) and the level.

I need to display the group names against the corresponding Cost center.

For Eg:

Cost center Level1 Level2 Level3

125455555 xyz skhk -

122554568 klljl sads asdsdd

I treid mapping the group name and cost center by passing the Cost center to

SETLEAF-VALFROM table and accordingly fetch the Group names but for few values there are no entries in the table..

Is there any other way of getting this done?

Thanks in Advance,

Rahul

Re: Group hierarchy level

Former Member — Thu, 27 Nov 2008 11:27:40 GMT

Funtion module to have grp hirerchal level cost center is

K_HIERARCHY_TABLES_READ

Regards

Re: Group hierarchy level

Former Member — Thu, 04 Dec 2008 06:52:17 GMT

Hi,

From the function module K_HIERARCHY_TABLES_READ im able to get the following details

1. my cost center and the previous level to which it is attached. (from T_VALUES )

2. All The Group name and their corresponding hierarchy level. (from T_NODE )

As i had mentioned earlier i shld have my cost center and the entire hierarchy lelvel details correspondingly displayed as shown below.

Cost center level1 level2 level3

12312323 XYZ FDD TYQ

12321231 XYZ JDD

11324545 FGR UYT TYT

Is there a way where i wil be able to achieve this?

Please advise.

Thanks in advance,

Rahul

Re: Group hierarchy level

Former Member — Fri, 13 Feb 2009 12:28:45 GMT

Hi ,

How could i get the profit center heirarchy in selection screen ?