Skip to Content

Relationship tables between header item and subitem in CRM

Hi Everyone,

I am using an E-commerce application where we have the porduct catalog consisting of header items and sub items.

While creating an order, if the header item has a subitem it displays automatically.How can i know that this subitem should be displayed for this particular header item. I mean to say, I just want to know the CRM tables where the relationship between header item and subitem are maintained?*

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 09, 2009 at 09:04 AM

    Hi Kalyans,

    Check the table CRMD_LINK.

    Check tables by searching CRMD* to get more useful tables.

    Regards,

    Saumya

    Add comment
    10|10000 characters needed characters exceeded

    • Saumya Govil kalyanaviswakanth muppa

      Hi Kalyans,

      For header and item data linkage you can use table CRMD_ORDERADM_H and CRMD_ORDERADM_I.

      CRMD_LINK table is used to check the linkage the order has to other entities like Partners, Subject profile, Activity etc.

      Do let me know if you still face any problem.

      Regards,

      Saumya

  • avatar image
    Former Member
    Jul 09, 2009 at 05:05 PM

    Hi,

    Go through the CRMD_ORDERADM_H and CRMD_ORDERADM_I.

    Pass header guid into CRMD_ORDERADM_I table in the HEADER field you will get corresponding item details.

    If you want ot know sub items related to header pass your CRMD_ORDERADM_H table guid in the CRMD_LINK in guid_hi field you will get corresponding sub items fof your header.

    Regards

    Srinu

    Add comment
    10|10000 characters needed characters exceeded