How to determine request ID (RNR) in start routine

[Former Member]

Hi guys

We have a start routine in the update rules between two ODS'es. The purpose is to collect the entries in ODS1 into matching couples in ODS2 (start and end times). Because we cannot be certain the number of records in a load is smaller than the package size of the system, we loop at the source ODS (ODS1) instead of the data package.

However, we don't want to loop at the entire ODS each time but instead use the selection criteria from the InfoPackage (on CALMONTH).

I know we can see this information in table RSSELDONE, but we need the request ID (RNR). How do we access this ID in the start routine?

Hope you can help, thanks

/Karsten

[Former Member · Accepted solution]

HI,

in that table u have a field called ODSNAME.

It store the ODS containing the request.

Let me know if u need any other info.

Regards,

Dhanya.

[Former Member · Accepted solution]

Hi Dhanya

Great, that did the work. Top marks for you!!!

Cheers

/Karsten

[Former Member]

Hi,

U need to include or rather use the table RSREQDONE and the field name is RNR of dataelement type RSREQUNR.

Here type in the specific request no of ur data target n u will get the request details.

u can use this in ur start routine.

Assign points if this helps.

Regards,

dhanya.

[Former Member]

Hi Dhanya

Thanks for your answer. However, I am not sure if I understand you correctly.

It is the RNR from RSREQDONE I need but how do I find the correct one? I cannot see the target as one of the fields.

Thanks

/Karsten