Compare data between 2 Query tranforms

[Former Member]

Hi,

I need to compare vendor data from ECC and CRM. I have used ABAPFLOWs to get the data into 2 query transforms.I need to compare this data.Could you please let me know which transform should use for the comparison.

Thanks,

Kumar

[Former Member]

You'll probably end-up just comparing your fields in a regular Query transform, assuming you have a shared key to be able to join your CRM to your ERP vendors, but your question is awfully vague. Provide more details to get more help.

Best wishes,

Jeff Prenevost

[Former Member]

Hi Jeff Prenevost ,

My requirement is to compare vendor data between ECC and CRM system. I have imported the LFA1 and ADRC(from ECC) and BUT000 and ADRC(from CRM) into two data stores. I have created a ABAPLFOW for ECC and droped the 2 tables into it and using Query outerjoin I have selected only required fields. I have done the same thing to CRM tables as well.

I have connected the outerjoin query to the datatransport. I have used query transform to get the data from the ABAPFLOWs.

ECC_ABAPFLOW->Query_ecc

CRM_ABAPFLOW->Query_crm

Now I have to compare the data in Query_ecc and Query_crm.

Could you please suggest me how should I go ahead.

Thanks,

Kumar.

[Former Member]

1) What's the vendor key from BUT000? You've got LFA1.LIFNR from the ECC side; what do you have as a key from the CRM side? Do CRM and ECC use the same vendor keys? LFA1.LIFNR = BUT000.?????

2) What data do you want to compare? Do you want to see if the data differs in certain defined pairs of supposedly identical fields? "Compare the data" is too vague.

Best wishes,

Jeff Prenevost

[Former Member]

I am using BUT000.PARTNER as the key in CRM . I will be using condition LFA1.LIFNR = BUT000.PARTNER. I need to compare the address data of vendor in CRM and ECC.

Thanks,

Kumar.

[Former Member]

Well, hopefully SAP uses LIFNR as the key for vendors-as-partners in BUT000.

There's a one-to-zero-or-many relationship between LFA1 and ADRC. Ditto, presumably, from BUT000. Your comparisons can therefore take many forms:

1) Do I have the same number of addresses in the two systems?

2) Do I have the same number of addresses of the same types between the two?

3) Do LIFNR and BUT000 share pointers to the exact same ADRC records? (If so, the addresses are, by default, identical).

If you're called-on to look for matches on things like telephone numbers and street addresses, you might consider Data Quality, if that's available to you; sifting & identifying duplicates and matches in straight ETL or SQL is possible (have written algorithms to do it), but can get awfully tricky. Often, you end-up just dumping all the addresses off to Excel for users to manually identify things via visual inspection.

Best wishes,

Jeff Prenevost

[Former Member]

Hi Jeff,

I will explain my requirement clearly. I need to create a batch job to identify the vendor data difference between MDM,ECC and CRM system.

The end user creates vendor ;XYZ' in MDM system.MDM system sends the vendor data to ECC immediately.This vendor name and address data is replicated to CRM system . Now if the end user changes the vendor 'XYZ' address in MDM and due to interface failure these changes doesn't get updated in ECC system or due to replication failure these changes doesn't get updated in CRM system. The vendor 'XYZ' data across the 3 systems is not the sync. I need to create batch job which captures this vendor 'XYZ' record and gives it in output file. I will run this batch job daily.

Thanks,

Kumar.

[Former Member]

So the MDM record is authoritative. That's great. Two questions:

1) Is it possible that someone will create a new record in MDM, so that, for instance, a given vendor will have four MDM addresses but only 3 ECC addresses?

2) More fundamentally: do each of these three systems use Business Address Services (formerly Central Address Management) tables? I believe you'd need to dig into the table relationships and make that determination, which would drive all the rest of it. If all three systems use BAS, the whole thing might be moot, "interface failures" notwithstanding. Even if not moot, you'd need to know how "vendors" in each of the three perspectives are wired to their addresses to know how to connect and compare the addresses together. I'm afraid I don't know these table relationships offhand, although explorations in the ABAP dictionary should reveal them.

Best wishes,

Jeff Prenevost