Processing the Data Transfer Process in SAP HANA

If your BW runs on a SAP HANA database, it is possible or necessary in certain cases to process the data transfer process (DTP) with processing type SAP HANA Execution.

When processing the data transfer process in SAP HANA, the following applies:

The data transfer process can be processed with processing type SAP HANA Execution if the data transfer process check finds that all transformations can be executed in SAP HANA. In this case, you can select the processing type in the data transfer process maintenance screen.
The data transfer process must be processed with processing type SAP HANA Execution if you are using SQL script procedures in one of the transformations for the data transfer process. In this case, the processing type is preset in the data transfer process maintenance screen.
The data transfer process cannot be processed with processing type SAP HANA Execution if you are using an ABAP routine in one of the transformations for the data transfer process. In this case, a processing type that can be executed on the ABAP server is preset in the data transfer process maintenance screen.

Note If you have a path in which one transformation contains an ABAP routine and another transfomation contains SQL script procedures, you cannot define a data transfer process for this path. In this case, the transformations have to be changed in such a way that either the ABAP routine or the SQL script procedures can be used, but not both.

Prerequisites for Using the Processing Type

In order to use processing type SAP HANA Execution, the following prerequisites have to be met in the DTP:

Error handling is deactivated.
There are no requests in the DTP error stack.
If the target of the DTP is a DataStore object: On the Update tab page, No Subsequent Processing without Master Data is not selected. / On the Update tab page, Subsequent Processing without Master Data is selected.
If the target of the DTP is an open hub destination: The destination is a database table or a third-party tool.
If the source of the DTP is a DataStore object: On the Extraction tab page, the following parameters are not set:
- Key Date for Master Data
- Currency Translation
- Delta initialization extraction from Active Table (with Archive)
If the source of the DTP is a DataSource: The Do Not Extract from the PSA flag has not been set.

Note During execution in SAP HANA, the list for the semantic grouping is ignored, meaning that the data is not extracted and posted in semantic groups. -> The Semantic Grouping button disappears, but the settings are still saved (if the user returns to ABAP mode)

Parallel extraction: Every parallel batch process executes a script for a DP in the reques; the flag is selected by default if you select HANA Exec.

Parallelization of Processing

If you implement SAP Hinweis 1935460 Information published on SAP site , the requests are processed in parallel processes, meaning that a parallel process is derived from the main process for each data package. This parallel process extracts and processes the data. On the Extraction tab page, the Parallel Extraction field is selected.

Note Für DTPs that would use processing type Extraction and Processing Parallel Except for Delta Init. for processing in the ABAP server, the following applies if using processing type SAP HANA Execution: The Parallel Extraction on the Extraction tab page is selected, and full requests or delta initialization requests are extracted and processed in parallel from the active table.

Effects of changes to the transformation

For an active DTP with processing type SAP HANA Execution, changes to the transformation have the following effects:

If execution in SAP HANA is not supported any more after the transformation changes, the system changes the processing type of the DTP to a suitable processing type in the ABAP server and reactivates the DTP.
If the transformation is inactive, the system sets the DTP to inactive too.
In most other cases, the DTP remains active.
If changes to transformations cause the error stack to change, the system reactivates the DTP.

If execution is possible in SAP HANA after the transformation changes (or meets another prerequisite in the DTP, such as deactivating error handling), processing type SAP HANA Execution is not automatically set in the DTP and needs to be set by the user instead.