Replication setup using HANA cockpit 2.0 and testing Active/Active Read Enable

SAP HANA, Replication with cockpit, HANA Replication

To manage system replication between two SAP HANA systems, you must first enable system replication on the primary system and then register the secondary system. The following section provides an overview of the aspects you need to consider in order to manage system replication between two systems. Disclaimer: Understanding the document will require basic understanding […]

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


IoT in SAP HANA Cloud Platform & Microsoft Azure

SAP Cloud Platform Portal, FIN (Finance), MAN Production Planning (PP), MM (Materials Management)

Business Vision: With a little opinion based on both architectures proposals and with the real experience in integration paradigm: Avoiding the confusion about: How do you determine that you are implementing a “IoT concept” and not just another “integration point of view”, The investment evaluation: is not just to talk about “resources and talent”, it […]

Continue reading


Removing invalid and non-printable characters in HANA based BW transformation

SAP BW/4HANA, HANA SQLScript

Most customers know the problem that invalid characters can be found in data records. Data load or DSO activation for char type InfoObjects can fail due to permitted or non-printable characters in BW. There exist several solutions for this problem. Some customer uses function module calls in ABAP transformations for example RSKC_CHAVL_OF_IOBJ_CHECK or RSKC_ALLOWED_CHAR_GET. Other […]

Continue reading


Playing with HANA parameters

The purpose of this blog was to share two end to end examples of passing parameters within HANA and using placeholders in SELECT statements. I have created two scenarios: HANA Table –> Table Function (with parameters) –> Calculation View (with parameters) HANA Table –> Calculation View (with parameters) –> Procedure (with parameters) The biggest lesson […]

Continue reading