guid

[Former Member]

Hi friends,

I am new to CRM.I found in somany tables a field like guid like what is the guid?

Can any body send me some documentation on fundamentals of CRM and list of some important tables that are freequently used.

I am sure of reward points.

Thanks in Advance..

[KaushalShah · Accepted solution]

GUIDs are system generated unique keys which identifies CRM objects (campaigns, sales documents, business partners, products etc.). CRM & MSA works on GUIDs. Most of the table relationships are defined on GUIDs.

Important CRM tables:

COMM_PRODUCT : Products

CRMC_T077D : customer account groups

CRMD_ORDERADM_H (for header) CRMD_ORDERADM_I (Item data)

CRMD_ORDERADM_H Business Transactions CRM

CRMD_ACTIVITY_H Activity

CRMD_OPPORT_H Opportunity

BUTOO : Customer details

BUT001 BP: General data II

BUT100 BP: Roles

BUT150 BP relationship: Attribute table (test

different

BUT_HIER_TREE Business Partner Group Hierarchy

CDBC_T_PRODUCTID Mapping: Product Id

CDBD_ORGMAN Business transaction - organizational unit -

set

COMC_PRODUCT General Product Settings

COMC_R3_FIELDS Assignment of R/3 material master fields to

CFOP

COMM_CATEGORY Category

COMM_CFGMAT Basic Data for Materials

COMM_HIERARCHY Category Hierarchy

COMP_TYPES Hierarchy Tool: Comparison Type Check

Table

CRMC_CPRICPROC Customer Pricing Procedures

SMOKVBEZ15 Assignment employees to positions

Hope this helps.

Regards,

Kaushal

[Former Member · Accepted solution]

Hi all,

Thans for info.i have given the reward points.

[Former Member]

Hi Friends,

In which table i can get the ship to party and bill to party addresses?..how can i distinguish between ship-to-party and bill-to-party? becz..there may be same numbers and different addresses..i there must be some key..

if so where cani find that?

Can any body give me any suggessions on this

Thanks in Advance.

[KaushalShah]

In CRM Online, you can assign more than one roles to a bueinss partner. A BP can be ship-to, sold-to, bill-to, payer etc.

Address details are common for different roles of a BP. You can distinguish between ship-to address & bill-to address of the same BP by identifying a particular address as billto or shipto.

Once you've set the address in BP transaction, you can check entries for the BP in table BUT021, where field ADR_KIND will show you which kind of address is this.

Hope this helps.

Regards,

Kaushal

[Former Member]

Hi,

Thank you very much.

[Former Member]

Hi,

Some of the BP numbers which i want i could't found in BUT021 table.

Can you please tell me when this table will be updated?

Thanks

[KaushalShah]

Only when atleast one of the address is identified as billto or shipto or anything else, a BP will have an entry in this table. Otherwise not.

Regards,

Kaushal

[Former Member]

Hi Jak,

GUID is an internal code which is automatically assigned by CRM application in order to identificate objects or so. It's a unique code. This field always belongs to the key table.

Hope this helps

Regards

Javier