My Hana view contains records of all order types of RGL (regular) or BLK (bulk) with Order dates.
Requirement at HANA view level-
1 User gives date range ( I think we should use variable -range for this)
example : 01-05-2020 to 31-05-2020
2. User Selects OrderType : RGL (regular) or BLK (bulk)
Result /Output :
If I select RGL then it should retrieve RGL records for the period 01-05-2020 to 31-05-2020
If I select BLK then it should retrieve BLK records for the period 01-05-2020 to 31-05-2020
Please guide me how to achieve this?