Create a value help (for input parameter / variable) in HANA Calculation view
Input parameters and Variables are two diferent mecanism that HANA provide us to get interaction with final users.
In some cases, we need to include an input parameters / Variables with value help with the propose of provide more information when user have to choose an input value.
In this post I’m goint to explain the steps to create a custom value help and some tips that you have to take in mind to get start with this topic.
To learn more about input parameters and variables check this post out: Input parameters and variables in SAP HANA modeling
Assumptions
I’m going to assume readers has HANA envairoment with SAP ECC tables replicates (like SAP ECC on HANA, or SAP ECC – SLT – HANA)
We use HANA 2.0 SP01 with Eclipse Neon (4.6.3) to do this tutorial
Problem phase:
Requirement
Customer needs a report where he can identify how many materials are there by material type.
Analysis
We know that this basic information of materials are in MARA table, so we need to develop a HANA view (Calculation view), count materials by material type and add material type value help as an input parameter.
Solution phase:
Create calculation view
We created a calculation view called CV_001_MATERIAL_BY_MATTYPE
Here we need to add MARA table as a projection and select MANDT, MATNR, and MTART fields
After that we need to creat a counter, so open Agregartion and add all fields to output
Now in the output section, create a new counter (by material) in calculated colums
Now before create an input parameter we need to have a value help HANA view, so, lets go to create it.
Create calculation view for value help
CV_0002_MATTYPE_VALUE_HELP
Here we need to perform a text join with T134 (Material typs) and T134T (Material type text)
Now it is an importat step, we need to add in semantics, a label colum info for material type field
With this our Value help view is ready, so activate it (Dont forget add a measure field, like counter, to activate the view)
Implement input parameter with custom value help view
In CV_001_MATERIAL_BY_MATTYPE‘s semantics choose Parameter/Variable tab and create an input parameter
- Name: I_MaterialType
- Label: Material type
- Parameter type: Column
- View/table for value help: use CV_0002_MATTYPE_VALUE_HELP
- Reference column: choose MTART field
Finally we need to add a filter with this parameter, so open MARA projection and apply a filter in MTART field
Thats it, if we use the data preview, we can see that the value help is working fine
by choosing ZSER material type we can see there is 11 materials created with this type
What about variables?
Is the same process, just choose variables insted input parameter and apply the same steps
Conclusion
The value help functionality is very important to take in mind when you are creating any kind of reports. This could be usefull when users are trying to find the correct input value to run our reports, and we need to be able to provide this tools to ensure our reports are, intuitives and easy to use