Relation between Table CRMD_ORDERADM_H and Table DNOD_NOTIF_S

[Former Member]

Dear Gurus,

I want to get the SAP component for a service desk message from Table DNOD_NOTIF_S (Field:COMP).

From Table CRMD_ORDERADM_H i am getting a field GUID, Where in Table DNOD_NOTIF_S i have a field called GUIDH with different value.

Is there any relationship between these two fields.

or is there any way to convert CRMD_ORDERADM_H-GUID to DNOD_NOTIF_S-GUIDH

Thanks in Advance.

[pbechani]

Hi

The tables CRMD_ORDERADM_H and DNOD_NOTIF are linked together by tables SRRELROLES and CRMD_BINREL.

CRMD_ORDERADM_H-GUID -> SRRELROLES-OBJKEY (get ROLEID from SRRELROLES)

SRRELROLES-ROLEID -> CRMD_BINREL-ROLE_B(get Role_A from CRMD_BINREL )

CRMD_BINREL-ROLE_A -> SRRELROLES-ROLEID(get OBJKEY from SRRELROLES)

SRRELROLES-OBJKEY -> DNOD_NOTIF-GUIDH

Regards,

Prince

[Former Member]

Many thanks for your help in building up the relation.

[Former Member]

Many thanks for your help in building up the relation.