key field between Table CRMD_ORDERADM_H and DNOD_NOTIF_S

[Former Member]

Hi,

Pls tell me which is the key field between

Table CRMD_ORDERADM_H and DNOD_NOTIF_S

GUID of CRMD_ORDERADM_H and GUIDH of DNOD_NOTIF_S are almost similar, But with slight variation.

How to convert one to another.

[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]

Hi,

thers no key field b/w these 2 tables.

both the GUID are same and only their namings vary becos of their table accordance