Looking forward for the next available value in a table without using LEAD or LAG function or LOOPING in SAP HANA

SAP HANA, BW SAP HANA Modeling Tools (Eclipse), SAP HANA Studio

REQUIREMENT This blog is regarding the calculation of “Production Ratio” in Supply Chain Management for the monthly bucket in SAP HANA. The client wanted to see, Production Ratio of a year for each month for a particular Product, Location and Product Version combination. In my case Production Ration was calculated as (Quantity / Total Quantity […]

Continue reading


SAP HANA Based Transformations (Processing transformations in HANA) aka ABAP Based Database Procedure (AMDP)

SAP BW/4HANA, BW (SAP Business Warehouse), BW SAP HANA Data Warehousing, BW SAP HANA Modeling Tools (Eclipse)

SAP HANA Based Transformations (New way of writing Routines) As majority of us has worked on SAP BW and have written ABAP routines in transformations in BW to derive the business logic, we often noticed the performance issue while loading the data into DSO, Info cube or master data info object. Also Read: SAP BW […]

Continue reading


Passing multi-value input parameter from Calculation View to Table Function in SAP HANA – step by step guide

SAP HANA Studio, SAP BW/4HANA, SAP HANA, BW SAP HANA Modeling Tools (Eclipse)

Introduction I demonstrated how to create Table Functions (TF) in SAP HANA XS Classic. One of the TF disadvantage, which I mentioned there was the fact, that they are not supporting multi-value input parameters – and this is official: Personally I think this is quite a big limitation, because when some functionality cannot be covered […]

Continue reading


How To Create AMDP With Parameters In ABAP Modular Perspective In SAP HANA

BW SAP HANA Modeling Tools (Eclipse)

What are AMDPs… ABAP Managed Database Procedures are a new feature in AS ABAP allowing developers to write database procedures directly in ABAP. You can think of a Database Procedure as a function stored and executed in the database. The implementation language varies from one database system to another. In SAP HANA it is SQL […]

Continue reading