HR Compare employees on 2 different boxes

[Former Member]

Greetings.

I have a requirement where I have to compare all employees on 1 box against the employees on a different box based on company code.

HR has it's own box.

The other modules FI, MM, SD etc...sit on another box.

There's an interface that sends IDOCs from HR box to other box with employee updates on a daily basis to ensure both boxes are in sync.

They want to be sure that in fact they are in sync by running this report.

The info types I need to compare are 0000, 0001, 0002, 0006, 0009, 0017, 0105.

They want to compare ALL the fields in each infotype.

My approach is the following:

1. Select all employees for a company code from other box and store in a table

2. Store the infotypes I need in another table

3. Create an RFC on the HR box that I will call 1 time

Send all the employees, infotypes, and company code

4. The RFC will send the Current Employees from the HR box to the Other box

5. I'll loop through each employee and compare ALL the fields per infotype

6. Any discrepancies, I'll list on the report

The most employees we have is about 7000.

Do you see any issues with this approach, such as performance or anything else?

Can I just do a straight:

IF PA0001_otherbox = PA0001_from_hrbox

or do I have to compare field by field?

with best regards....

[Former Member]

hi you can compare, and make sure the hr box and other box fields are same

[Former Member]

Was this OK solution...

I also have same task to do...

[Former Member]

This is what I'm going to do.

1. Create an RFC destination from Other Box to HR box

2. Create an RFC Function on the HR box

Create Program on Other box that will do the following:

- Extract all employee's specified info types by company code

- Call the RFC Function on HR box to retrieve the info types by passing Company code, optional PERNR, and tables to store the info types

- loop through Other box info types and compare to HR info types

- any discrepancies would be saved in a table

- first I would compare just the record

i.e. IF OTHER_INFO_TYPE_0000 <> HR_INFO_TYPE_000

Then compare all the fields within the info type to find the discrepancy and save it

- report out table with the differences

- done

[rainer_hbenthal]

> Can I just do a straight:

> IF PA0001_otherbox = PA0001_from_hrbox

> or do I have to compare field by field?

This is dangerous when one system is a unicode system and the other is not. In a long term you are more on the save side comparing component by component prevents you from doing this when one system is upgraded to unicode.

[Former Member]

The HR box is ECC 5.0 and Other box is ECC 6.0.

You can compare PA0001_other = PA0001_hr; however if they don't match then you have to compare field by field.

I'm not too familiar with unicode, so I'm not sure how to answer that question.