How to see request number in ODS table

[Former Member]

Hello,

I know data last request has some incorrect data (delta , LO).

In order to change it I need to select data by request number. Table /BIC/AXXXXXX00 does not contain request number.

Please tell me how I can select data by request number.

Thanks

[Former Member]

Hi

To find the request, goto the table RSMONICTAB in BW. Enter the request number.It'll give you the date time stamp as to when the request was loaded into BW.

Go back to monitor (RSMON) and filter on the date with the date from the table.

You'll find your request.

This may help u.

Regards

Naalla

[Former Member]

Thanks to all guys .. i have assigned points to all of u !!

thanks and Regards

Rahul

[Former Member]

In Monitoring tab you can check the request number corresponding to your ODS.

Cheers!!!!!!!

[Former Member]

The question was little bit differant.

I want to select data by request. For example, stsrt routine of ODS2 update rules I would like to select data of request number XXX from ODS1.

Select *

From ODS1

Where request number = XXX

[Former Member]

Just right click on ODS1 in InfoProvider tab, and select Manage option, and check for the request number in Reuest Tab.

hope it helps.

Cheers!!!!!!!

Do assign points if you feel answers to your questions are valuable.

[edwin_harpino]

hi,

get the change log table name from that manage ods,

/bic/b000xxx and the field is REQUEST, try

Select *

From /bic/b000xxx

Where REQUEST = XXX

normally xxx = ODSR_xxx

hope this helps.

[edwin_harpino]

hi,

you can get with request no. from ods change log table,

ods->manage->contents->change log.

or it's check with psa.

hope this helps.