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