Scenario:
This article will show how you can access the runtime information of a 'Data Transfer Process' and which data is available.
The runtime information of a 'Data Transfer Process' (DTP) is available in the 'Start, End and Rule' routine. For example, this information could be used to determine the target of the DTP to implement logical partitioned InfoCubes or datastore objects. This function is available with SAP NetWeaver BI SP10.
Please refer to OSS note #979607 for further information.
Available fields and corresponding data types:
| Description |
Technical name |
Data type |
| Request ID (INT4) |
R_REQUID |
RSBKREQUID |
| Technical name of the DTP / DTP ID: |
R_DTP |
RSBKDTPNM |
| Text/Description of the DTP |
R_DTPTEXT |
RSBKDTPTEXT |
| Lines read from the source |
R_LINES_READ |
SYTABIX |
| Lines transferred from the source |
R_LINES_TRANSFERRED |
SYTABIX |
| Request ID (length 30) |
R_REQUID30 |
RSREQUID |
| DTP Selections for Source |
R_TH_RANGE |
RSBK_TH_RANGE |
| DTP State
0 New
1 Executable
2 Processed Successfully
3 Processed with Errors
4 Deleted
5 Active
6 Processed, with Warnings
7 Further Processing Started
8 Processed Further
9 Deletion Started
A Further Processing Terminated
|
R_TSTATE |
RSBKTSTATE |
| Time Stamp END of the DTP / is usually empty |
R_TSTMP_FINISH |
RSTIMESTMP |
|
Time Stamp Start of the DTP /
UTC Time Stamp in Short Form
(YYYYMMDDhhmmss)
|
R_TSTMP_START |
RSTIMESTMP |
| User name executed the DTP |
R_UNAME |
SYUNAME |
|
Update mode
(F) Full
(D) Delta
(I) Initial Non-Cumulative
for Non-Cumulative Values
|
R_UPDMODE |
SBKUPDMODE |
User-Defined Processing Status for a DTP Request
See "State" / RTSTATE for state types
|
I_USTATE |
RSBKUSTATE |
| Source object (eg. Data Source name) |
R_SRC |
RSBKSRCNM |
| Source type (eg. DTASRC for DataSource) |
R_SRCTP |
RSBKSRCTP |
| Target type (eg. cube for InfoCube) |
R_TGTTP |
RSBKTGTTP |
| Logical Source System name |
R_LOGSYS |
RSSLOGSYS |
| Data Source from the Source System |
R_DATASOURCE |
RSOLTPSOURCER |
| DataSource segments |
R_T_PSA |
RSDS_T_RSDSSEG |
| New or old DataSource is used |
I_USE_NEW_DS |
RS_BOOL |
A simple implementation example:
data:
* Target InfoProvider
I_TGT type RSBKTGTNM.
* get target
CALL METHOD P_R_REQUEST->get_TGT
RECEIVING
R_TGT = I_TGT.
Result:
The above fields are available during the runtime of the DTP (transformation).
In this example the result would be "SALES13".
For example, see the field "TGT" in the screenshot of the debugger session:
Michael Hoerisch is a member of the SAP NetWeaver Regional Implementation Group (RIG) since 2001, with a focus on Enterprise Data Warehousing and customer solutions.
This content is reposted from the SAP Developer Network.
Copyright 2007, SAP Developer Network
SAP Developer Network (SDN) is an active online community where ABAP, Java, .NET, and other cutting-edge technologies converge to form a resource and collaboration channel for SAP developers, consultants, integrators, and business analysts. SDN hosts a technical library, expert blogs, exclusive downloads and code samples, an extensive eLearning catalog, and active, moderated discussion forums. SDN membership is free.
Want to read more from this author? Click here to read Michael Hoerisch's Weblog. Click here to read more about Business Intelligence (BI) on the SDN.
