Showing posts with label sap-hana-sqlscript. Show all posts
Showing posts with label sap-hana-sqlscript. Show all posts

Friday, 27 October 2017

Simple sql table export in ABAP for HANA

Idea was to play with HANA and to try it’s functionality for educational purposes.

For data extraction I wrote a simple ABAP Report, which extracts selected tables with its data and prepares sql script for import.

Here is a source code (s. attached file).

Here is a screenshot of selection screen.

Sunday, 22 May 2016

Data based on Conditions in a table

All the user conditions are available in the Table: USER_CONDITIONS and these conditions will be applied on the Table: EMPLOYEE. To keep it simple, let us consider two tables with sample data as shown below: