What is GUID in SAP CRM ?

As we learnt in SAP SD Training, a Transaction is uniquely idenfied in the database using a Transaction Number / Document Number. In SAP CRM this uniqueness is not driven by the document number, but by SAP GUID. An SAP GUID is a unique field generated by SAP which will essentially guarantee a big unique alpha-numeric numer that can act as a primary key for the database tables.

As you can see from the basic ORDER table – CRMD_ORDERADM_H, there are two leads with the same Lead Number of #476, but what differentiates the table rows is the GUID. GUIDs are created using the FM – GUID_CREATE.

What intrigues the folks from the core SAP ECC system is that over there there is no concept of GUID, whereas in SAP CRM this becomes the primary key. This was necessitated by a number of problems – Mostly related to the fact that CRM is generally not a master data system and also the fact that CRM is essentially built to interact with mobile clients as well which are not necessarily connected to the server. Let’s consider the following scenarios.

1. A mobile order (say Txn Type – ZTA) was taken by a field rep on his laptop and the laptop generated an order # 1234. This number was generated without consulting the Server and might not reflect the current number range scenarios for the Txn type ZTA. Now what happens when the fields sales rep connects to the server at the end of his day and tries to sync the data ? If the Order # was the only primary key, obviously you are in trouble – especially since its the primary field. So SAP CRM came up with the concept of GUID which uniquely identifes the transaction in the system no matter what.

2. Also, it is not always the case that all transactions need to be created in SAP CRM. For example, regular sales orders can be created in SAP SD whereas Service Orders, leads and opportunities could be created in SAP CRM. Since data needs to be synchronized between the two systems – this could lead to potential issues. Although there are mitigatory mechanisms for situations like this ( Like creating leading systems, making number ranges external in receiving system etc ) SAP has to plan for its own contingencies and GUID is the key for it.

For more on full-fledged functional SAP CRM Training on other modules of SAP Training, please click on the respective links.

8 Responses to “What is GUID in SAP CRM ?”

  1. 12 volt battery charger walmart October 2, 2014 at 1:44 am #

    Hi there it’s me, I am also visiting this site regularly, this web page
    is actually pleasant and the people are actually sharing
    good thoughts.

    my page :: 12 volt battery charger walmart

  2. mincir vite September 29, 2014 at 6:39 am #

    This is very interesting, You’re a very skilled blogger.
    I’ve joined your feed and look forward to seeking more of your great post.

    Also, I’ve shared your website in my social networks!

  3. Emilio September 24, 2014 at 11:53 pm #

    Attractive section of content. I just stumbled upon your blog
    and in accession capital to assert that I get actually enjoyed account your blog posts.
    Anyway I’ll be subscribing to your augment and even I achievement you access consistently
    fast.

  4. Mamie September 21, 2014 at 2:31 pm #

    You need to take part in a contest for one of the greatest websites online.
    I’m going to highly recommend this web site!

  5. Dakota August 31, 2014 at 9:59 am #

    Useful info. Lucky me I found your site by accident, and I’m shocked why this twist of
    fate did not came about earlier! I bookmarked it.

  6. http://Www.emberarts.org August 24, 2014 at 1:30 pm #

    If you’re looking too start taking up street photography, this article iss for you.

    When you wear Banksy T-shirts, you are bound to leave an impression on others mind.
    There is a groovy but shott oundtrack and some spraying noises to accompany your adventure.

    Feel free tto surf to my homepage :: wall art – http://Www.emberarts.org -

  7. schwinn easy steer tricycle August 5, 2014 at 7:43 pm #

    I got this website from my pal who told me on the topic of this web page and now this time I am visiting this web page and reading very informative
    content here.

  8. cruz de los milagros July 4, 2012 at 2:56 am #

    A notable share, I recently given this particular onto the colleague who had been doing somewhat analysis in this particular. And he believe it or not bought people breakfast because I came across it meant for him.. smile. So well then, i\\\\\\\’ll reword who: Thnx for your treat! But that\\\\\\\’s the reason Thnkx regarding spending the time to explain this, I believe strongly about that and enjoy reading more within this topic. When possible, as you then become expertise, do you mind updating your site with more details? It is definitely highly great for me. Big thumb up for this blog place!

Leave a Reply