Traditionally
in SAP BW systems there are the BW request types of two kinds, representing a
request and status management (RSSM):
1. Request ID (e.g. DTPR_59IOI42WSEVCH90JCT5TCKNZZ)
or so called Data Transfer Process
Request. It describes a list with calls that is generated from the template
of a Data Transfer Process (DTP). In addition, there is information how data in
a BW is loaded from a source object to a target object, and which data is transferred
to the target object under these conditions.
Data element that represent the Request ID is RSREQUID and it is CHAR30 data
type. The value can consists of up to 30 characters literal (numbers and
strings).
2. SID (e.g. 395.609) or so called key number of a request is the internal
encryption of the request number that is allocated by the scheduler. The SIDs
are sorted into ascending order. They are used in this maintenance for rolling
up and compressing the InfoCube.
Data element
that represent the SID is RSBKREQUID and it is INT4 data type. The number can
be from interval: -2.147.483.648 to +2.147.483.647
Each
request has both representation Req ID and SID. They can be converted from one
form to another and vice versa. These numbers can be seen in t-code like RSA1
where they represent particular data load. T-code RSRQ (Data Load Monitor for a
Request) allows to enter both type of the request.
The
Req ID and SID that are based on 0REQUID are referred as called classic request and status management.
In
general, all these terms like Request ID, Data Transfer Process (DTP) Request,
SID or key number of a request area
more less synonyms. One may find all these terms mixed.
3.
In BW 7.5 there is a 3rd type of BW request
type available. It is called Process
Transaction Sequence Number (TNS). It has a formal like below:
{2020-05-12
17:18:11 000001 CET} = 20201512151811000001000
Even
t-code RSRQ is extended in BW 7.5 to include this type of the request.
It is based on timestamps. Data element
that represent the SID is RSBMREQUID and it is DEC data type with length of 23
and 9 decimals.
More
over in BW/4HANA
based systems the classic request and status management is not available. It
was replaced by the TNS (0REQTSN) and it is referred as request status and process management (RSPM). It is used not only for loading processes but
also for data staging, distribution, streaming, and planning processes
for InfoObjects, aDSO, and Open Hub Destinations.
Below
is a picture how t-code RSRQ looks like in BW lower than BW 7.5 and in the BW 7.5 or in BW/4HANA.
More
information:
2482164 - BW4SL - Request and Status
Management
2462639 - BW4SL - Interfaces and
Customer-Specific ABAP Development
