Loading data from SAP ERP :- (Delta)

Create data store for HANA DB

Create data store for R3


Steps as SAP ECC6 level

Log on to ECC6

Go to provide 7 – Code RSA file

Select Required Extractor


Again go to RSA6 T-Code

Select Recently activated extractor

EDIT and make any changes based on requirement and save it


Steps at Data Services

Import our extractor into SAP Application Data store (Enable CDC Option)

Import our HANA DB table into HANA DB store

Create project

Create job

Create workflow

Create data flow

Drag extractor

Take query transformation

Drag our HANA DB Table

Connect extractor of query transformation

Connect HANA DB table & Query transformation

MAP the fields of extractions & table

RUN the job

Execute the job

These core tutorials will help you to learn the Delta Project Creation in SAP Hana. For an in-depth understanding and 

practical experience, explore Online SAP HANA



Loading data from dynamic files to SAP HANA

Create data store for HANA DB

Import out Required our Target area

Bulk loading from source table by using data services



Data services first loads the data into a staging table and then it application the operation codes

(INSERT, UPDATE, and DELETE) to update the target table.

With Bulk – load option selected in the table editor, any one of the following conditions triggers the staging mechanism

The data flow contains a Map – CDC operation transform

Y the data flow contains a map – operation trans form that outputs update or DELETE rows

Y the data flow contains a table – comparison trans for

Y the auto correct load option in the target table editor is set to yes



Template tables

For template tables, select the appropriate table type for your SAP HANA target

Y column store (default)

Y Row store

Target options bulk loader options load pre-load post – load  Triggers pre-load commands post –load commands

Rows per commit :

Delete data from table before loading :

Drop and re-create table :





Generate column comparison No .of loaders                    compare by name 1

Error handling use overview flow NO

File name Not Applicable

File format Not Applicable

Update control use input keys NO

Update key columns NO

Update auto correct load NO


All Table

When bulk loading in enabled, you have the following options:-

Models specify the mode for loading data to the target table

Append :adds new records to table (default)

Truncate : deletes all existing records in table then adds new records

Commit size – the maximize no. of rows loaded to the staying and target tables before saving the date

Column store (default commit size is 10,000)

Y Row store (default commit size is   1,000)

Y update Method – specify how the input rows are applied to the target table

Y update issues an UPDATE to the target table (default for column store tables)

Y DELETE – INSERT : issues a delete to the largest table for date that matches the old data in the staying table, then issues an INSERT with the new data (default for Row store tables)

Do not delete –insert if the update rows do not contain data for all columns in the target table been at a  services will replace missing data with NuLLS

Target options bulk loader load triggers pre – load commands post load commands co

Bulk loader

Mode : Appeared

Commit side:

Update method:


Dynamic flat (FF) file selection

Using valuable:-  We can extract the file dynamically we can use the variable go to workbook    Untitled   new  Untitled   Format name :


It is used mostly enter the File Name :

File name so it cant import data than we will enter the fields name and data type and size

Field name                          Data type                           Size

Cost-contce-id                  voucher                                     4

Pres                                                                                         15

A variable is a job specific (Group of WF and DF)

Select JobUntitled go to tools  Untitled  create variables

We select global variable

Now we can use the “script writing “ the lode script are using in the DF & WF

Script in always inside a job (or) data flow , WF is a group of DF

We can place the script inside DF and corner DF

Script is not a reposing object “it is a reusable object”

For an Indepth knowledge on SAP HANA, click on below