topic Re: ALE data compare in Application Development and Automation Discussions

ALE data compare

Former Member — Mon, 01 Oct 2007 15:33:19 GMT

ALE is set up between local and global box to send Employee data.

Users found out some discrepancies between the data and now we want to verify data between these 2 systems is in sync….

Any suggestion how to address above task…

Re: ALE data compare

Manohar2u — Mon, 01 Oct 2007 15:36:10 GMT

Only way is by comparing PA0000, PA0001 ..... tables, then look at the global system's HRMD* idoc types..

Cheers

Manohar

Re: ALE data compare

Former Member — Mon, 01 Oct 2007 15:42:18 GMT

How to compare these tables...???

Re: ALE data compare

Manohar2u — Mon, 01 Oct 2007 15:57:11 GMT

User scmp tcode to compare if you have valid RFC connections to your target systems.

Re: ALE data compare

Former Member — Mon, 01 Oct 2007 16:01:29 GMT

Thanks for suggestions...

Now challenge is...one system is global and another local.

Global is data source...so we will like to compare data from Global to local..

From Global data, we just want to compare local data...

Example: global is having World Wide employee data and we will like to compare only US employee data..

How to do that..

Re: ALE data compare

Manohar2u — Mon, 01 Oct 2007 16:17:27 GMT

You can run this tcode with selection conditions from either global system or local system...bit hectic...why wont you run PFAL tcode and do a mass send for all employees with all infotypes?

Re: ALE data compare

Former Member — Mon, 01 Oct 2007 16:38:44 GMT

No...PFAL...we can not use…Sorry!!!

We just want to find out data discrepancies for US active employees..

Now for SCMP tcode …challenge is ...

For IT0002...how to restrict to only active US employees..

Any suggestions