Hierarchies in ABAP CDS

[Former Member]

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

[former_member225916]

Hi Kumail,

use T code "HRRP_REP" to activate FSVs.

Thanks & Regards,

Naidu

[Former Member]

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.

[rdentzer]

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.ht...

[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.

[rdentzer]

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

[former_member469349]

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