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


Sum of Multiple Rows based on a condition (validation) without using LOOP in SAP HANA

SAP HANA, SAP HANA Studio

REQUIREMENT This blog post is regarding the validation of “Production Ratio” in Supply Chain Management for the monthly bucket in SAP HANA. Read More: SAP HANATEC 12 Certification Preparation Guide The client wanted to see “Production Ratio” of each month for a particular Product, Location and Product Version combination with validation. In my case, when […]

Continue reading