Reply: 1

Auto translated

Include calculated fields in global hierarchies

Hello everyone,

Global hierarchies via cost elements are basically relatively easy to create using the Global Hierarchies app. How should I proceed if I want to include calculated fields in this hierarchy?

For example, if I call up the PC reports via the W0079 app and activate a cost element hierarchy, I would like to display calculated fields in the hierarchy. Is that possible?

Kind regards

You must be logged in to post a reply.

Login now

1 Answers

  • BETA
    ChatBot
    Automated answer
    This reply was automagically generated by our Espressi A.I. Think of it as a one-off attempt to instantly solve your problem. It will not respond to further replies.

    Hello, the integration of calculated fields directly in global hierarchies via the standard apps in SAP, such as the app for global hierarchies, is typically not possible directly. Global hierarchies are primarily used to define and visualize the structural organization of dimensions such as cost elements, profit centers, etc. For the specific use case of integrating calculated fields into reports or hierarchies, you should rather use reporting tools and data warehouse functions that support such dynamics. SAP offers various options for this, depending on which SAP version and which system (e.g. S/4HANA, SAP BW) you are using ### SAP S/4HANA In SAP S/4HANA, for example, you can use CDS (Core Data Services) views to define calculated fields and use them in your reports. CDS views allow you to define powerful queries and calculations that are executed directly on the database. ### SAP BW/4HANA In an SAP BW/4HANA system, for example, you could use BW queries to define calculated key figures that can then be used in reports or in a BW reporting tool such as SAP Analysis for Office. ### Implementation in PC reports If you want to use calculated fields specifically in the app for PC reports (such as the W0079), you should consider whether you can adapt the report definition to integrate these fields. This could potentially be done by creating a custom report or through enhancements in the reporting app ### Practical approach 1 Define the calculated fields: Depending on your system environment, use CDS views, ABAP code or BW queries to define the logic of your calculated fields 2. Integrate the fields into your reports: Use the appropriate reporting tools or enhancement options of your SAP apps to make these calculated fields visible 3. Test and validate: Make sure the calculated fields work correctly and deliver the expected results Hope this helps! If you need more specific details or guidance, it might be helpful to provide more detailed information about your specific SAP environment and requirements.

    Need more help from our chatbot? Click here and visit our AI SAP Helper on the SAP learning platform et.training.1

    1. log in with your Espresso Tutorials account. Digital subscription or trial access required.