Relating a Specific Execution of an InfoPackage to a Specific Execution of a DTP

[former_member192123]

Dear SAP BW Experts:

I am stuck on something in BW, and I am hoping that one or more of you might have done something similar in the past.

In a nutshell, I need to determine the selection conditions used in an InfoPackage (whether manually entered by hand by a person, or derived from an ABAP routine) for ALL loads currently in a given InfoCube where the data was loaded using a 7.x data flow (i.e., having both an InfoPackage and a DTP)

I am having trouble relating a specific execution of an InfoPackage to a specific execution of a DTP.

I have been investigating tables RSSELDONE and RSBKREQUEST, but I keep getting stuck trying to relate the Request Number from RSSELDONE to a specific record in table RSBKREQUEST.

Here are some complications I need to be able to handle:

1. Daily loads are deleted from the PSA after 7 days, weekly loads after 31 days and monthly loads after 90 days (so not everything that has been loaded to the cube is in the PSA)
2. Even if loads are deleted from the InfoCube, entries remain in table RSSELDONE and RSBKREQUEST. However, it appears that you can identify deleted loads in table RSBKREQUEST using the “USTATE” or “TSTATE” value of “4”
3. More than one InfoPackage could be used with the InfoCube (like, for instance, somebody creates one for manual use, and one with an ABAP routine in it for automated selection)

Any ideas?

Thank you!

[former_member186445 · Accepted solution]

it should be possible comparing the loading date/time of the infopackage and the DTP. Get all the DTP request (with date/time) of a given cube.

for every request (REQ_1) determine the date/time of the previous request (REQ_2) in the cube. Now get all requests in the psa that have been loaded in to the psa between the date/time of the REQ_1 and the date/time of REQ_2.

hope it's clear.