SAP BLOG Profit center / cost center hierarchy in standard SAP table

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,925
Tepki puanı
7
Puanları
6
General background –

As we know, profit center / cost center hierarchy are maintained in sets in SAP. In order to view the profit / cost centers within a hierarchy, we need to go to the setleaf / setheader tables. However there is no complete view of a hierarchy in one standard table. This problem is now solved in HANA where you can activate the standard hierarchy and load into a table. This blog will explain how that can be done.

Activate and load hierarchy –

Lets take cost center hierarchy as an example.

The hierarchy will be activated and loaded in table SETHANAHIER0101 (for cost center hierarchy). Initially this table will be blank

In order to populate the hierarchy in the table, below mentioned steps shall be followed.

  • Go to transaction code HDBC
  • Click on Hierarchies

capture-2.png


  • Select cost center groups and click on the + button on the right hand side

2-6.png


  • All the controlling areas will be displayed. Select the controlling area used by your company and click on edit

3-4.png


  • Then click on new entries in below screen

4-5.png


  • Mention the cost center hierarchy name as highlighted below and select ‘Load and Activate’ from drop down list. Then save it

5-6.png


  • Go out and select ‘Background’ when below pop up appears

6-6.png


  • Check in SM37 the job completion status. Normally it takes only a few seconds.
  • Once successfully completed, the hierarchy will be populated in the table SETHANAHIER0101.

7-4.png


  • Similarly for other objects below are the tables

8-5.png


  • Same procedure as mentioned above can be followed for profit center groups, cost element groups, order groups, accounts groups.
  • The HANA table has following important fields
Column #Column namePurpose
1Set classPC group, CC group, account group etc.
2Org. unitControlling area
3Set nameHierarchy name
4NodeTotal number of nodes. It starts from -1 till the last number of node is reached
5NodePreceding node number under which a particular node is there in hierarchy
6LevelLevel in the hierarchy

Hope this blog is useful. Questions / comments are welcome!



Kind Regards

Aman Goel

Okumaya devam et...
 
Üst