Relationships between CRM tables

[timo_wendt]

Hello CRM-Gurus,

can anyone give me the relationships(as document or picture) between the

following CRM tables :

<b> crmd_orderadm_h

crmd_activity_h

crmd_customer_h

crmd_link

crmd_partner

crmd_srv_osset

crmd_srv_subject

crmd_order_index

scappt

scapptseg</b>

Thanks.

I will reward points.

Best regards

Timo Wendt

[gregorw · Accepted solution]

Hello Timo,

please try the Procedure to get the Table Relationship diagrams as described in .

Regards

Gregor

[timo_wendt · Accepted solution]

Hello Gregor,

the link (

with this description:

Click on Business Solutions and Applications -> MySAP Business Suite -> MySAP CRM -> Solution Library -> CRM powered by Netweaver -> Process Integration -> Business

does not work.

Can you give me another help/link to find the requested relationships ?

Thanks.

Regards.

Timo

[former_member184067]

hi Timo,

i'm not CRM gurus yet, but i know a little about crm table relations

link between crmd_orderadm_h - crmd_link

select *

into <something>

from crmd_orderadm_h as ord

join crmd_link as link

on ord_{guid = link}guid_hi

link between crmd_orderadm_h - crmd_activity_h

select *

into <someting>

from crmd_orderadm_h as ord

join crmd_activity_h as act

on ord_{guid = act}guid

link between crmd_orderadm_h - crmd_customer_h

select *

into <something>

from crmd_orderadm_h as ord

join crmd_customer_h as cust

on ord_{guid = cust}guid

link between crmd_orderadm_h - crmd_partner

select *

into <something>

from crmd_orderadm_h as ord

join crmd_link as link

on ord_{guid = link}guid

and link~objtype_h = '05'

and link~objtype_set = '07'

join crmd_partner as part

on link_{guid_set = part}guid

link between crmd_orderadm_h - crmd_order_index

select *

into <something>

from crmd_orderadm_h as ord

join crmd_order_index as idx

on ord_{guid = idx}header

link between crmd_orderadm_h - crmd_srv_osset - crmd_srv_subject

select *

into <something>

from crmd_orderadm_h as ord

join crmd_link as link

on ord_{guid = link}guid_hi

and link~objtype_hi = '05'

and link~objtype_set = '29'

join crmd_srv_osset as oss

on link_{guid_set = oss}guid

and oss~subject_profile = <your profile>

and oss~profile_type = <your profile type>

join crmd_srv_subject as subj

on oss_{guid = subj}guid

for scappt and scappt seg ( table of apointments things ), i have found the link yet because i have never use it in programming before

if i found the links, i will tell you

please award points if helps

cheers

eddhie

[Former Member]

Timo

try with the tcode SD11 that is the SERM Structured entity relation model

Award if it helps

regards

Carminem

[timo_wendt]

Hi Carmine,

can you tell me the model i have to put into transaction SD11 to the described tables?

Thanks.

Regards.

Timo

[Former Member]

Timo

u shoul search the one that is relevant for you.

In example for orders u've to choose the Data model "CRM_ORD0001" then clicking on CTRL+F3 u'll be able to see the whole datamodel

Hoping it helps

Regards

Carmine

[timo_wendt]

Have anyone further information to this topic.Thanks.

[dsdaraujo]

link between crmd_orderadm_h - crmd_scapptseg

select *

into <something>

from crmd_orderadm_h as ord

join crmd_link as link

on ord_{guid = link}guid_hi

and link~objtype_hi = '05'

and link~objtype_set = '30'

join scapptseg as sca

on link_{guid_set = sca}appl_guid

and sca~appt_type = <your appt_type>

For <your appt_type>, take a look at SPRO -> CRM -> Basic Functions -> Date Management -> Define Date Types, Duration Types and Date Rules -> Date Types.

Regards,

Daniel.