Skip to Content
author's profile photo Former Member
Former Member

Compare data between 2 Query tranforms

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2011 at 03:51 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.