Functional informations

Before CBS project, the hierarchies used in BW for Funct0 were the FUNCT0 hierarchies.

Now, we have new hierarchies called ZCBS, existing in the different ERPs.
The name of the hierarchies is Controlling area + 'ZCBS'

Example below for Z006CBS:

Hierarchy's loading for Acetow and Rare Earth before

For Acetow and Rare Earth (controlling areas 0001, Z965, 7898 and RTR1), they didn't have the hiearchies in their ERP.
So we used a different way to have the hiearchy's levels.

We used C_FUNCTCC ost Center info object.
In this info object, we had the link between the cost center+of the +4th level of Z013 hierarchy

Then we run the info package to load attributes of the Cost center for the source system involved.

In the start routine of the update roule, BW searchs for the cost center the 4th level of the Z013FUNCT0 hierarchy and determines the other levels

Actual loading of hierarchy

Today, all ZCBS hierarchies are created and managed in the ERP. We don't use C_FUNCTCC anymore.

To load the attributes, we have one transformation (for RCS controlling areas) and one update rule (for the other ERP).

The start routine in the transformation/update rule will search for the controlling area-cost center the different level

The start routines start to load the hierarchy of the controlling area into an internal table.

Then we search the cost center in this hierarchy in order to find the lowest level of the hierarchy.

With this level, we can find the levels above until the highest (level 0), which is ZCBS.

Example for Cost center 7666-2025.
We find the hierarchy's code in the hierarchy's table RSHIEDIR.

Then we load into an internal table from the hierarchy cost center's table for this cost center

We find the level 6 and we obtain a node's code (PARENTID field: 1319)

Then we search this PARENTID value in the same table but in the NODEID field.


We got now the level 5, the lowest level of our hierarchy (in BW it's the level 4) and also a new PARENTID.
The node name (minus the 4 first characters) is the code of the level.
We search the new PARENTID in order to the find the level above and we stop when there's no PARENTID value.
It means we are at the highest level, ZCBS

The texts of the levels are managed in a dedicated hierarchy, the Z013ZCBS.

Frequency of loading

Hierarchies are loaded every working day inside process chain Daily Hierarchies CO 2/2 round 7pm (Paris time)

  • No labels