Skip to Content
avatar image
Former Member

Relation between Table CRMD_ORDERADM_H and Table DNOD_NOTIF_S

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 04, 2011 at 07:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded