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 Secure Network Communication (SNC) Encryption configuration from SAP Portal to ABAP systems and SAP Gui to ABAP systems

SAP HANA, SAP ERP

Background As per the client request to encrypt the SAP Portal traffic to SAP ABAP systems and SAPGUI encryption to ABAP systems as part of their Infosec policy. Encryption is implemented using the SAP Secure Network Communication (SNC). This document explains about step by step configuration of SNC Encryption on the existing SAP Gui to […]

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


Replicating Data from Oracle to HANA using SAP HANA Web IDE SDI

SAP HANA smart data integration, SAP HANA, SAP Web IDE

Overview SAP Smart Data Integration provides real time, high speed data provisioning, bulk data movement, and federation. Replication task or flowgraph lets you set up batch or real-time data replication and transformation scenarios in an easy-to-use web application. Data Provisioning Agent hosts data provisioning adapters, enables data federation, replication, and transformation scenarios for on-premise or […]

Continue reading


SAP HANA Backup via backint interface. Step-by-step guide for Veritas NetBackup

SAP ERP, SAP HANA

Prerequisites You want config backup via backint interface for your SAP HANA multitenant database. This step-by-step guide provides information about Veritas NetBackup solution N.B .If you want to use other backup tools, for example, EMS Networker, Veeam Plug-in for SAP HANA, Spectrum Protect for Enterprise Resource Planning, etc this guide will be useful for you […]

Continue reading


Material Ledger Mass Loading in BW on HANA

SAP BW/4HANA, BW Data Modeling (WHM), SAP HANA, SAP S/4HANA

ERP transaction CKMLQS has been designed to display the multilevel valuated quantity structure for one material. The aim of the multilevel valuated quantity structure is to provide an overview of the actual quantity structure of the multilevel processes, valuated with the actual prices from the actual costing. I will try explain the steps, how to […]

Continue reading