Skip to Content
1

Hierarchies in ABAP CDS

Jan 10, 2017 at 11:17 AM

1.4k

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Ralf Dentzer
Jan 12, 2017 at 02:10 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0
Ralf Dentzer
Jan 13, 2017 at 07:29 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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.

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

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 31, 2017 at 11:22 AM
0

Hi Kumail,

use T code "HRRP_REP" to activate FSVs.

Thanks & Regards,

Naidu

Share
10 |10000 characters needed characters left characters exceeded