cancel
Showing results for 
Search instead for 
Did you mean: 

How to get used InfoPackage name in SAP BW 3.5 in update/ start routine?

Former Member
0 Kudos

Hello Experts,

according to the Infopackage (weekly load ord monthly) the update rule should change.

In BI 7.0 helps the method P_R_REQUEST. Is there any similar for BW 3.5? =Or is there a possiblility to get the request nr in the startroutine with accordant mapping table to InfoPackage?

Best regards,

Stephan Wagner

Accepted Solutions (1)

Accepted Solutions (1)

former_member199691
Active Contributor
0 Kudos

See if you get the request number using table MONITOR or MONITOR_RECNO in the start routine. Once you get the request number, you should get the info package ID from table RSSELDONE.

Regards,

Gaurav

Answers (6)

Answers (6)

Former Member
0 Kudos

Although it's late to answer this question maybe somebody will find it helpful.

One can get the id request in progress and corresponding infopackage technical name using the next code:

DATA: lv_pck TYPE rslogdpid.

   FIELD-SYMBOLS <fs> TYPE any.

   assign ('(<generatedprogramname>)i_requnr') to <fs>.

   SELECT SINGLE logdpid

     FROM rsreqdone

     INTO lv_pck

     WHERE rnr eq <fs>.


where <generatedprogramname> can be found under extras->display activated program in the update rules display.


Regards,

Jorge Aguirre.

Former Member
0 Kudos

I investigated the request ID from rsmonicdp and then the Infopackage ID from rsreqdone.

Former Member
0 Kudos

Hi Experts,

thank you for your answers. Now, I have got the mapping table InfoPackage/ Request-ID.

But, how can I get the actual Request ID in the start routine in BW 3.5?

The tables MONITOR and MONITOR_RECNO don´t store it and they needs to be filled.

MONITOR_RECNO

-

-


MSGID

MSGTY

MSGNO

MSGV1

MSGV2

MSGV3

MSGV4

DETLEVEL

RECNO

MONITOR

-

-


MSGID

MSGTY

MSGNO

MSGV1

MSGV2

MSGV3

MSGV4

DETLEVEL

Best Regards,

Stephan

Former Member
0 Kudos

Hi,

Have you checked table RSMONICDP Contains the request-id number by data target

Regards,

Durgesh.

former_member188080
Active Contributor
0 Kudos

Hi,

Check following thread as well

Also you can check the list in RSMO --- MONITOR -


nEW SELECTION --- fURTHER SELCTION iNFOPACKAGES/DTPS

It will show you the complete list of used IPs.

Thanks and regards

Kiran

Former Member
0 Kudos

Hi,

Check few more tables related to Infopackage,

RSLDPSEL Hardcoded selections in InfoPackages

RSLDPIO Links datasource to infopackages

RSLDPRULE ABAP source code for InfoPackages

RSMONICDP Contains the request-id number by data target

RSPAKPOS List of InfoPackage Groups / InfoPackages

RSSELDONE InfoPackage selection and job program

Regards,

Durgesh.

former_member182470
Active Contributor
0 Kudos

Hi,

You can take Infopackage Id from RSREQDONE table.

Regards,

Suman