on 05-21-2006 11:54 AM
Hi all,
I am new to CRM. I know the table CRMD_LINK is very useful especially for connecting two kinds of objects.
And I think the GUID_SET and GUID_HI must be the objects' GUID, and OBJECTTYPE_SET and OBJECTTYPE_HI should be their corresponding types.
But could anybody explain me the detail?
For example if I want to connect CRMD_PARTNER to CRM_JEST how could I know that CRMD_PARTNERGUID = CRMD_LINKGUIDSET, but not CRMD_PARTNERGUID=CRMD_LINK~GUID_HI. Is there any potential ruls.
Maybe it is a stupid question. But I just don't know.
By the way, if I try to get this kind of infomation, is there any useful documents to recommend? My Email: chenmarco@gmail.com
Thanks and Best Regards,
Marco
Hi Marco,
The table CRMD_LINK has 4 fields.
The first field GUID_HI always contains the GUID of the ORDERADM_H (05) object type or ORDERADM_I (06) object type. The object type corresponds to the value in the third field OBJTYPE_HI.
The second field GUID_SET contains the GUID of the object type specified in the fourth field OBJTYPE_SET.
The description of the values of the object type could be found in the table CRMC_OBJECTS.
Have a look at the table CRMC_OBJECTS.
Let me know if this helps!
Jash.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Jash,
you mean the objecttype_hi could only be '05' or '06'?
And I am reading some exsiting codes, there is a fragment:
<b>SELECT DISTINCT
e~guid
e~object_id
e~description
c~stat
d~priority
e~created_at
e~changed_at
a~partner_no
a~partner_fct
FROM ( ( ( crmd_partner AS a
INNER JOIN crmd_link AS b
ON aguid = bguid_set )
INNER JOIN crm_jest AS c
ON bguid_hi = cobjnr )
INNER JOIN crmd_activity_h AS d
ON bguid_hi = dguid )
INNER JOIN crmd_orderadm_h AS e
ON bguid_hi = eguid
INTO CORRESPONDING FIELDS OF TABLE lt_seltab
WHERE b~objtype_hi = '05'
AND b~objtype_set = '07'
AND c~stat LIKE 'E%'
AND e~process_type = gc_process_type-sr_serv_order
AND c~inact = ''
AND ( a~partner_fct = ls_bpfct-partner_fct
OR a~partner_fct = ls_c_bpfct-partner_fct )
.</b>
I wonder how could CRMD_ORDERADM_Hguid CRMD_ACTIVITY_Hguid and CRM_JEST~objnr are identical.
Does it mean that the three tables describe the same object's different faces?
Thanks very much and Best Regards,
Marco
Hi Marco,
Please go through the table CRMC_OBJECTS (Business Transaction - Component Type) for more information on Object Types for different Business Sub Objects. For Admin Header and Admin Item you can use CRMC_OBJECTS~Kind = 'A' or 'B'. 'E' refers to Set Type. GUIDs in CRMD_ORDERADM_H, CRMD_ACTIVITY_H and CRM_JEST are same and they give different kinds of data for a business transaction.
Hope this helps.
Thanks.
Ajay Kiran
User | Count |
---|---|
7 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.