cancel
Showing results for 
Search instead for 
Did you mean: 

how to extract user information from R/3 into BW

Former Member
0 Kudos

Hi, I have a requirement that how to extract end user informantion from R/3 into BW.

For example, I want to know who have logged in R/3 in the last one year , what they have done and what tcode they have used and so on .

I need to extract these information from R/3 and build a query for the IT manager.

Is there andy BI content or datasource I can use?

Thank you!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Anyone konws?

Former Member
0 Kudos

Hi,

i dont know is there any specific table for this. but there are standard tables CDHDR/CDPOS, which will stores all teh changes wiht tcode and user and dat/time details. Create a generic extractor on this.

regards,

Sakthi.

Former Member
0 Kudos

Thanks ,

but these two tables are related to the document changes not logon date and tcode information.

I can find the audit log in SM20, but which table stores these log information?

sven_mader2
Active Contributor
0 Kudos

Hi,

check

- sql trace (ST05),

- the abap code of the program,

- or use se30

User information are saved in the tables usrxxx.

Sven

Former Member
0 Kudos

The audit log is not stored in the table but in the file saved at R/3 server.

How can I extract the log information from r/3 to bw?