REG:GUID

[Former Member]

Hello Experts,

                     I am new to crm can any one tell me what is the difference between guid and primary key of a table. For example I am creating a college then do I need to have both college_guid and college_id?Explain me with proper example.

Thanks&Regards,

Ramesh.

[Former Member]

Hi,

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.

The above example may give solution to your question,

  In your case College_Guid will be the primary key, you must not create separate College_ID.

Thanks,

HCL Sparks.

[Former Member]

Hi,

Both GUID and Primary Key are the same.

Go through this link http://scn.sap.com/message/13686324

Regards,

Hcl Innovators

[Former Member]

GUIDs are system generated unique keys which identifies CRM objects (campaigns, sales documents, business partners, products etc.).

Guid is a  Globally Unique Identifier used as primary keys in CRM tables to uniquely identify records.

In your case your college_id itself  is the primary key and it will uniquely identify records in the table. Your college_id is like a guid for your college.

For example, in R/3 customer master data the customer number (KNA1-KUNNR) is the identifier and primary key in all dependent tables (e.g. KNVV).

Regards

HCL ZENITH