Employee "Change on" Infotype Field

[Former Member]

Hello experts:

I would like to hear some advice from anyone who had a spec similar to this:

Our client needs to send a xml file through an interface. This interface should send the first time all their employees, but the next time should only send those employees records whom change in some particular fields.

Ok, I already aware of the "Change On" field that every Infotype has. But the downsize of using this field is that any information that change on the infotype will modify this field. This is not working for me because I only need to send for example a record change only the HOME PHONE number.

Saying that, if a user change any information on the Infotype 6 (Address) then the field "Change On" will change. So that's the reason I can't use that field.

I was thinking in do some kind of comparison from the last data sent or the new one, but I think this can affect the performance.

I would appreciate all the ideas or suggestion that you can bring to this post.

Thanks in advance,

Carlos Lerzundy

Message was edited by:

Carlos Lerzundy

[Former Member · Accepted solution]

when is this interface triggered ?

i work on a simlar interface between people soft and SAP which would update all the employee master and the organization structural relationships for the first time during the day and then updates only the changes subsequently in the later runs ..

but this interface runs about 4 times in a day updatind information .

so i do a compare between the initial feed and the subsequent feed that i get from peoplesoft.

may be you can use the same logic in your program to read and compare the XML file and then pick up only the changes

Hope this helps

KP

[Former Member · Accepted solution]

Krishna:

The interface should be triggered at least 2 twice a week. I was thinking the same way you did (comparing feeds) but I'm not sure if this is the best way in a performance stand point.

[Former Member · Accepted solution]

Thats the way we are doing from the past couple of years and haven't really had any performance issues.

[Former Member]

Carlos:

I understand that ANY change to the record will cause the AEDTM field to change and that change may not have anything to do with the field that you want to track, however I don't see any way except to check for a change to the IT(s) the field(s) you want track is on and then when you get a hit compare the field(s) on the current record to the fields on the previous record to see if it changed.

[Former Member]

Carlos,

Depending on the number of Infotypes you are wanting to track changes on and how much action your system has in a given day, it might not be as much of a performance hog as you think. I have a couple of interfaces that are similar to this and on a system with about 60,000 employees and 7 years worth of data they don't run long.

You would probably want to do a SELECT on AEDTM and then either do another SELECT or a LOOP through all the records for a given Infotype comparing current to previous.

[Former Member]

Richard..

The problem is that every change in a infotype will be recorded in that field (AEDTM), if I only want to keep track of 1 field, I can't use this one because if other field of the same infotype is modified, then that will modify the AEDTM field..

Do you understand what I mean?

BTW, thanks for your reply.

[Former Member]

Hi,

You can configure only the fields you want to track the changes in the table T585B. What this will do is, it will capture the changes made in the table in the cluster. You can retrieve the data from cluster and send it.Hope this answers you query.

Regards,

Bala

[Former Member]

Balaji:

How do you do that configuration?

[Former Member]

Goto SM30 enter v_t585b.

You get the table. Enter the infotype and the field you want to be captured.Something like this.

0000 Actions 00 MASSG

0000 Actions 00 MASSN

0000 Actions 00 STAT1

0000 Actions 00 STAT2

0000 Actions 00 STAT3

After this ask your ABAPer to code it in such a way they read the data from the audit log RPUAUD00

[Former Member]

Balaji:

Your approach resemble in some way what I'm looking for. I'm the abaper for this spec, so I review the RPUAUD00 and I saw that every little change is on that log. So I can say that I may look for this code as a reference to search all the fields I intend to evaluate.

But, the part I don't get yet is about the table configuration. What is that table for? and what relationship has with the RPUAUD00 program?

Thanks in advance for your suggestion.