Extracting Daily Changes from HR Infotypes
A D V E R T I S E M E N T
Subject: HR: Extracting Daily Changes from HR Infotypes
I am looking for recommendations for extracting daily changes from HR and
Payroll Infotypes to populate outbound interfaces. We will have approximately
300,000 employees active and inactive implemented in our system. We are
currently reviewing a strategy to extract records based on the Updated Date from
the header portion of an infotype. Our concern is performance. The Updated Date
field is not part of the primary infotype key. We have considered putting a
secondary index of that field to help with performance.
Another strategy is to use the audit function to create log entries each time
fields have been changed on an infotype. Has anyone used this functionality?
Has anyone implemented HR with at least 100,000 employees? How did you tackle
this issue? What types of performance problems were encountered? Which
strategy is the most efficient?
Any information you could provide would be helpful.
We are running SAP Version 3.1G, on SUN Hardware with Solaris Operating system
over an Oracle database residing in UNIX.
Subject: RE: HR: Extracting Daily Changes from HR Infotypes
I have used the audit functionality in a couple of implementations, It
sounds like you can use for your requirements. here is what you need to do:
1. You need to configure three tables, T585A, T585B, and T585C (if you use
SM31, enter table name, do customizing, it'll take to the place in the IMG
in 3.0 versions)
2. you need to run the report RPUAUD00
There are some issues you need to think about before configuring the audit
1. You have to analyze what you need to audit, do not audit all fields on
an infotype, and by no means audit all infotypes.
2. Depending on how much you want to audit, the log report could be
extremely big, hence putting a strain in the performance of your system
3. Frequency of the report