Model RDL

Model RDL is a data model function that allows you to access SAP HANA-optimized Results Data types of the Financial Products subledger datamodel.

Key Features

Header

Header fields are important to be filled correctly in order to connect to an existing and activated data model. To perform this, you have to define the connection type, results data area and the result type.

You must also define the view type, either “Application” or “Integration”. For Application View, the field names format is /BA1/* and for Integration View, the fields names format is BA1_*.

Fields

While on edit mode, choose the Synchronize button. The system then displays a popup window allowing you to exclude fields by setting the Exclude checkbox to marked (checked). All excluded fields will not be considered during processing in SAP Profitability and Performance Management.

Simple Reading Mechanism, Selection using Fixed Value Model RDL (for example View, Join)

SAP Profitability and Performance Management reads data records from a specific Result Type through active and generated SQL or HANA Views. The system automatically consumes all data records written in the HANA view.

In order to filter results with fixed selection, you have to create an SAP Profitability and Performance Management processing function such as the View or Join function on top of the Model RDL.

To perform this, follow below steps:

  1. Create a processing function such as View with the Model RDL as the input function.

  2. Select this View function and on the right side of the screen and choose Edit.

  3. Add a selection by choosing the Selection button and provide a selection criteria, for example SOURCESYSTEM = XX01.

  4. Once fully set, activate the View function – this function then must be used as input during processing instead of using the Model RDL function directly.

Dynamic Reading Mechanism, Selection using Parameter or Field Model RDL (Join)

SAP Profitability and Performance Management reads data records from a specific result type through active and generated SQL or HANA Views. Automatically the system will consume all data records written in the HANA view.

In order to filter results with dynamic selection, you have to create a SAP Profitability and Performance Management Join function on top of the Model RDL.

To perform this, follow bellow steps:

  1. Create a Join function.

  2. Select this join function. On the right side of the screen, choose Edit.

  3. Go to the Rules tab and add a rule type “FROM” with the Model RDL as its input.

  4. Add a selection by going to the Complex Selection of the rule and use below format to select 
    WHERE SOURCESYSTEM = I_LEGAL_PARAM

  5. Once fully set, activate the join function – it then must be used as the input during processing instead of using the Model RDL function directly.

Reading while using Parallelization Model RDL (View, Join)

In order to have a more optimal parallelization setup while consuming data from RDL, you can use a SAP Profitability and Performance Management processing function such as View or Join function on top with a Package Selection entry.

To perform this, follow below steps:

  1. Create a processing function such as View with the Model RDL as the input function.

  2. On the left side of the screen choose Edit.

  3. Choose Function Attributes button (button on the left of the Activation button).

  4. On the Advanced tab under Package Selection, add at least one field that must be selected to avoid reading all data from the table.

  5. Once fully set, activate the View function – it then must be used as the input during processing instead of using the Model RDL function directly.

Writing Mechanism

SAP Profitability and Performance Management writes data records to a specific RDL result type using a Writer function with a configured Output function pointing to a Model RDL. This model RDL function must then be configured to point to a specific Result Data Area and Result Type.

For additional information refer to Writer.

Procedure

Function Access

Follow the steps below to access the Model RDL function:

  1. In the client where SAP Profitability and Performance Management is installed, choose Start of the navigation pathSAP Menu Next navigation step Profitability and Performance Management Next navigation step Modeling Next navigation step Start My EnvironmentsEnd of the navigation path.

  2. The Environment screen appears in a separate browser window. Choose an existing environment and continue. Within the environment, you can set up the newly added function.

Function Configuration

Follow the steps below to configure the Model RDL function:

  1. In edit mode, configure the following required fields in the header. For more information about the header, see the Key Features section above.

    • Connection Type: Choose either “Physical” or “Logical”.
    • Result Data Area
    • Result Type
    • View Type: Choose either “Application” or “Integration”.

  2. Choose Synchronize on the Fields tab.

  3. The Sync Model Fields dialog appears showing the fields to be imported.

  4. Choose the fields to be added, then choose OK.

  5. Choose Save and then choose Activate.

Related Information

  • For more information about common aspects of SAP Profitability and Performance Management functions, see Concepts for Key Users.

  • For more information on how to add and remove functions in SAP Profitability and Performance Management environments, see Function Hierarchy.