Wednesday, October 12, 2022

Type of Data Transfer Procesess

There are a few types of DTP. A purpose of the DTP or so called Data Transfer Process is to specify how data is transferred between two objects in BW system. It governs from which objects data is extracted (source object) and into which objects the data is stored to (target object.). The data transfer process forms a template for requests. When a request of this type is processed, data is loaded into a target object from a source object.

Technical name of the DTP can have different prefixes as I wrote here. However, in this blog post I discuss the type of the DTP. There are following DTP types recognized by their purpose or a context in which the particular DTP can be used:

 

<blank>      Standard (Can Be Scheduled)

Mostly to run in Process Chains on periodic basis (thus a term scheduled) as loading process. Also can be running manually by the user.

REAL

DTP for Real-Time Data Acquisition, A daemon provides DTPs of this type with new data from a source in regular and frequent intervals.

 

REMT           DTP for Direct Access

Is used to read data from a query directly from a source system using RFC. DTPs for direct access typically access highly current data that has not yet been made available in the BW system by the scheduled load processes.

 

EDTP            Error DTP

The DTP that serve for purposes of error handling of another DTP. The other DTP is called standard DTP. Error DTP has the standard DTP specified in table RSBKDTP and column DTP_STANDARD. In addition, the standard DTP is specified in column SRC in the same table.

 

Type of the DTP can be spotted in t-codes like RSDTP:



Technically the type of the DTP is stored in table RSBKDTP and in column DTPTYPE (Type of Data Transfer Process). The column definition refers to data dictionary domain RSBKDTPTYPE.

Apart of column DTP_STANDARD there is one more interesting column in the table RSBKDTP. It is DTP_ORIGINAL column. In most cases the DTP technical ID (column DTP) is equal to the DTP_ORIGINAL. However, when the DTP was copied from the DTP that was transferred from a Business Content the DTP_ORIGINAL carries the ID of the content DTP. In case the DTP_ORIGINAL column is empty there is an ABAP program RSBK_FILL_ORIGINAL_DTP that populates the column. This is needed as the DTP that has no original column maintained may fail to transport across BW systems in a landscape. 


More information:

A little about InfoPackage / DTP prefixes and BW data request's prefixes

2016048 - P34: DTP: Fill Original_DTP if field is empty