Skip to Content
avatar image
Former Member

Hierarchies in ABAP CDS

Hello Experts,

I am trying to create Hierarchy in CDS view which will be consumed in Analysis for Office report(AFO). (system - S/4 HANA 1610 ). I have below questions on the same.

  • There are standard hierarchy CDS views available for cost center and profit center, etc- But how to use them in AFO report?
  • Standard Hierarchy developed have few Directory tables used(HRRP_NODE, HRRP_DIRECTORY) – How they will be maintained, and how change in hierarchy will reflect in AFO report ?
  • How to build custom Hierarchies?
  • Maintenance of Custom hierarchies and automatic change reflection in AFO report.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 12, 2017 at 02:10 PM

    Hello Kumail,

    • Hierarchy CDS views are used in analytics via the dimension CDS views they relate to. For example, if you use a column for the cost center in your cube view, there has to be a foreign-key association to the cost center dimension view (probably I_CostCenter), to which the hierarchy view is related. Then all queries defined on that cube offer hierarchical capabilities for the cost center, also when used from AFO.
    • The cost center and profit center hierarchies are maintained in the classical way through the set hierarchies. These can be replicated to the new tables.
    • Assume you want to add a customer-specific field. Then you define a dimension CDS view for that field. Depending on the complexity of your hierarchy, you can either use the hierarchy annotations within the dimension view itself, or define a separate CDS hierarchy view that provides the hierarchy nodes and their parent-child relation. Some of the hierarchy nodes are related to the rows of your dimension view. After adding the customer-specific field as well as the foreign key association to an existing or a new cube view, the hierarchy is available in analytics, including AFO.

    Best regards, Ralf

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ralf,

      WE are creating the CDS views on ECC on HANA and i see these tables: hrrp_node as apart of the views :I_CostCenterHierarchyNode but not sure how to fill them.

      I think in S4HANA we can use HRRP_REP but not sure what is the corresponding Tcode in ECC on HANA.

      Regards,

      Rajesh

  • Jan 13, 2017 at 07:29 AM

    Here is a link to the documentation of the cost center/profit center replication:

    http://help.sap.com/saphelp_fiori_sfin_300/helpdata/en/37/6e6156cbb6cf54e10000000a441470/frameset.htm

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Ralf,

      Would you be able to provide more details on how is it created / provided by SAP to use in our views?

      example - I want to use hierarchies(FSVs) in my cube. So which SAP delivered view I should associate to, in my cube view?

      Thanks in advance.

  • avatar image
    Former Member
    Jan 18, 2017 at 01:51 PM

    Thanks Ralf. This is really helpful.

    Would you be able to provide more details on how is it created / provided by SAP to use in our views?

    example - I want to use hierarchies(FSVs) in my cube. So which SAP delivered view I should associate to, in my cube view?

    Thanks in advance.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 11:22 AM

    Hi Kumail,

    use T code "HRRP_REP" to activate FSVs.

    Thanks & Regards,

    Naidu

    Add comment
    10|10000 characters needed characters exceeded