Wednesday 13 October 2021

How to use HANA Exit in SAP Analytics Report [Selection Screen Default value]

Purpose / Issue –

SAP Analytics reports default value for Fiscal Year and Posting Period as Current Fiscal Year and Posting Period on the selection screen.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
Report Selection Screen Value

Prerequisites –


◉ SAP HANA Composite view [ Bring all the fields and KPI ]
◉ BW query [ On top of Composite Provider]
◉ HANA Exit variable
◉ SAP Badi to populate HANA Exit value

Solution


Step 1 –

◉ Build HANA Composite view with all relevant details as per your business requirement.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
CDS Composite View with all Business Logic

Step 2 –

Build the BEx Query with required selection [ selection Fiscal Year / Period ] using CDS SQL name as Transients Provider.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
In BW Perspective Select New Query tick Check Box to Create Query

BW Query Created on top of Composite Provider

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
BW Query Details

Step 3 –

Create respective selection variable for Fiscal Year and Posting Period in BEx with “Processed By” = HANA Exit.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
Create and Add HANA Exit Variable in BW Query

HANA Exit Variable Details for Fiscal year –

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
HANA Exit for FIscal Year details

For posting Period –

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
Posting Period HANA Exit Variable details

Step 4 –

In SAP GUI open t-code 18 and enter the HAVA BadI “RSROA_VARIABLES_HANA_EXIT” click on Display

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
Use T-code SE19 or SE18 for SAP Badi

Step 5 –

Under Implementations create Enhancement Implementation “ZXX_CL_VARIABLE_HANA”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning

Step 6 –

Inside Enhancement Implementation “ZXX_CL_VARIALBLE_HANA”

Open “IF_RAROS_VAR_HANA_EXIT~PROCESS”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning

Step 7 –

Write the code to populate the FISCAL Year / Posting Period Default value

Save and Activate.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
Source Code Snapshot

Step 8 –

To test the CLASS Method open T-code SE24 execute the methods

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning

Follow the steps as highlighted in Yellow

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
Follow the Step by Click

Enter the HANA Exit Variable Name in “I_VNAM”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning

Step 9 –

Now Execute the Report in T-code RSRT [ Web Version] Selection screen Value populated with default Current Fiscal year/ Posting Period.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Career, SAP HANA Preparation, SAP HANA Guides, SAP HANA Learning
BW Report Output After including HANA Exit Variable

No comments:

Post a Comment