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


Introduction to the SAP HANA smart data access linked database feature

SAP HANA, SAP QM, SAP MM, SAP, SAP BI, SAP CRM

Introduction to the SAP HANA smart data access linked database feature The linked database feature was introduced with SAP HANA 2.0 SPS 01, and greatly simplifies the workflow for accessing remote data sources. With the new linked database feature users can directly access remote tables and views without having to manually define virtual tables. The […]

Continue reading