Skip to Content

Topic:

The purpose of these articles is to

  • Create a custom hierarchy in R/3
  • Create a Generic Hierarchy data source for the hierarchy created above in R/3
  • Load hierarchies in BW 7.3 using this Generic data source and hierarchy transformation

System:

SAP BI 7.3, ECC 6.0

Step by Procedure to Create a Custom Hierarchy in ECC:

Lets take example of Company code. We want to see company code hierarchy in reports. Assume there is no standard hierarchy available for company code in ECC. Below steps show how to create a SET Hierarchy for company code in ECC.

Goto t-code GS01, give the set name as the hierarchy name (top most node) you want to see and the Table as T001. Then click on Hierarchy maintenance which will ask for the field on which you want to create the set. Choose BUKRS since we want to create hierarchy for Company code. Then press enter.

Capture1.JPG    Capture2.JPG

You see the hierarchy maintenance screen where in enter the description for heirarchy header.

Capture3.JPG

Place the cursor on CC and click on ‘Lower Level’ to create nodes below CC. Example nodes as CC1, CC2 and CC3 along with their descriptions.

Now we want to assign company code values to the nodes CC1, CC2 and CC3.

Place the cursor on CC1 and click on ‘Value/Interval’.

And enter the company codes which should belong to the node CC1. Repeat the steps for nodes CC2 and CC3 and Save the Set.

The t-codes GS02 can be used to change the set hierarchy.

GS03 for displaying the hierarchy and GS04 for deleting the set hierarchy,.

Finally the created hierarchy looks like this.

Capture4.JPG

Now the hierarchy is ready in ECC. How to extract this hierarchy to BW will be shown in my next documents.

Hope this document helps.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Richard Duena Vinas

    Hi Bindu, do you have the succeeding parts for this already? I’m interested in these two –

    • Create a Generic Hierarchy data source for the hierarchy created above in R/3
    • Load hierarchies in BW 7.3 using this Generic data source and hierarchy transformation

    Thanks!

    Regards, Chard

    (0) 

Leave a Reply