usr02 table buffering..please help

[Former Member]

Hi Experts,

I have come across a situation where in i would need to get all the program which updated usr02 table. The usr02 table buffering option is "switched off" (can't turn it ON as per our business situation).Basically the USR02 table is updated by some program or user but it is not updated in USH02.So when eva i pull out the SUIM report.i am getting inconsistent data. That inconsistent data is making all other consistent tool act weirdly .

So i would like to know , Is there any possibility of getting all the operations(program or manually) on USR02 table even if the table log option is switched off.

If SAP has some existing tool ..the GR8 great but if not also please let me know whether its programmatically possible..

Thanks and Regards,

Tashi

Edited by: Thomas Zloch on May 12, 2011 4:45 PM

[ThomasZloch]

One quick way would be to study the where-used list of table USR02, is there any custom code that is touching it?

Did you look for SAP notes covering such problems?

Thomas

[Former Member]

Hi,

I have checked the where-used list for the USR02 table . It has approximately more than 1000 Z programs touching the table . So it is not feasible . I will be really greatful if you can guide me a way out of this . I need to find which all program or user updated usr02 table. Please help.

regards,

Tashi

[Former Member]

Hi,

we can create custom program for updating data in USH02 . Ask ABAPer help you will get result as well.

Ram.

[Former Member]

Hi Ram,

The situation is ..we have lot of z programs touching USR02 and USH02. One of those z program is updating the USR02 but not USH02 . Now i wanted to see which program or user is the one doing the updation in USR02 but not USH02. The table buffering option of USR02 table is switch off . So i wanted to know whether it is possible to get all the operation done in USR02.

Thanks &regards

tashi

[Former Member]

Hi Tashi,

Ideally you would have to check the code in all the programs that are updating table USR02 and USH02 to idenfity the difference.

Two crude ways that might of some help:

1) Do a where used search on both tables and compare the list of program that get returned, eliminate the common ones and check the others

2) Run program RSRSCAN1, searching string 'update usr02' and 'update ush02' (or insert?) and check the programs.

Regards,

Shyam

[Former Member]

Hi Shyam,

Thanks for the idea !! i want to implement your idea to solve the problem ..however i would want to know how to use "where used list" in abap program as there are lot of programs which uses both the tables . So i want to write a small abap program to give me the list of programs which uses these two tables.

Thanks in Advance

Tashi

[ThomasZloch]

You might not need a program to do this. Table D010B holds table names used in programs. You could find the programs using one table and copy/paste the hit list as an "excluding-selection" for the other table.

Otherwise have a look at function module RS_EU_CROSSREF.

Thomas