Group hierarchy level

[Former Member]

Hi All,

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

Thanks in advance,

Rahul.

[Former Member]

Hi All,

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

Thanks in advance,

Rahul.

[satsrockford]

hi

refer this thread:

hope it helps..

regards

Satish

[Former Member]

>

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

Wrong link posted.

[Former Member]

check the below tables:

FMZUGR

FMZUOB

GB903

RWSHEADER

SETNODE

SETLINET

[raviprakash]

>

> 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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

>

> 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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

Funtion module to have grp hirerchal level cost center is

K_HIERARCHY_TABLES_READ

Regards

[Former Member]

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

[Former Member]

Hi ,

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