Skip to Content
Author's profile photo Former Member

Custom Hierarchy Extraction in SAP BW 7.3 (Part1)

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.

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Chard,

      Pls check my latest articles

      http://scn.sap.com/docs/DOC-30686

      http://scn.sap.com/docs/DOC-30698

      Hope it helps.

      Bindu

      Author's profile photo Former Member
      Former Member

      Hi Bindu,

      When I view Part 3 in the link below the images do not show up.  Looks like there is a problem with the Capture__.JPG links. 

      http://scn.sap.com/docs/DOC-30698

      Do you have a copy of that article somewhere with the links? 

      jim@bdsbi.com

      Thanks,

      Jim Johnson

      Author's profile photo Former Member
      Former Member

      Hi Bindu,

      Great work..really made things easy for me.

      regards

      Rajeev

      Author's profile photo KONKA SREENIVASULU
      KONKA SREENIVASULU

      Hi Bindu Priya,

      Best Explanation 🙂

      Regards

      Sreeni

      Author's profile photo KONKA SREENIVASULU
      KONKA SREENIVASULU

      Hi Priya,

      Could you please provide the link for extraction of the hierarchy to BW

      Regards,

      Sreeni