To track SSN changes/updates.

[former_member27665]

Hi experts,

Without depending on PA change logs , is there any way to capture changes/updates in PA0002.PERID (SSN) ?

Appreciate your suggestions.

Thanks & Regards

lal

[Former Member]

Not that I am aware of.  Guess you could always dig through SE16N or check into utilizing Ad Hoc Query or maybe just get with an ABAP developer to see if they can write you a fairly straight forward utility.

[former_member27665]

Thanks @Scott Sinai.

I believe PA0002 keeps historical data (like type-2 SCD).

eg : In case if an update happens to PA0002.PERID for an employee, the existing record will get updated with ENDDA=12.31.9999 or a new record will get created ?

Please comment.

[Former Member]

Hopefully a new record is created with new validity dates as your screen shot shows as it would be tough to track changes if the original records is overwritten with a new value.

Keeping historical records if possible, even if incorrect, is always best practice in my opinion.

Hope this helps!

[former_member27665]

Thanks for your response Scott,

Will update our reporting logic to capture the SSN changes in PA0002 using above method.

[former_member27665]

And how we can make sure that PA0002  stores historical data ?

[ShrutiJoshi]

Hi Devilal

You would have to enable data logging in the technical settings.

[former_member27665]

Thanks @Shruti.