Skip to Content
author's profile photo Former Member
Former Member

Relation between ORDERADM_H, ORDERADM_I, ORDERADM_INDEX etc

Hi,

Can some body please guide me the relationship between various tables of Sales Order creation. Specifically I am asking for help around tables CRMD_ORDERADM_H, CRMD_ORDERADM_I, CRMD_ORDER_INDEX, COMM_PRODUCT etc.

How these are related based on various GUID etc?

Thanksing in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 07:23 PM

    Hi,

    CRMD_ORDERADM_H is the table that contain all header information like object id(transaction number), header guid, transaction type, etc.

    CRMD_ORDERADM_I contains the information about item.

    HEADER attribute in Item contains the header guid.

    PRODUCT attribute in Item is the product guid.

    CRMD_ORDER_INDEX contains the header and item and also partner information

    Thanks,

    Kavitha

    COMM_PRODUCT

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Other interesting tables are CRMD_PARTNER, which has the partner functions, CRMD_SALES and CRMD_SCHEDLIN which contains item quantities, and CRM_JEST (status).

      Some of the sales order tables (CRMD_SALES for instance) are linked to the main ones (CRMD_ORDERADM_H, CRMD_ORDERADM_I) via CRMD_LINK.

      From my experience any reporting involving sales orders, that can be done in R/3 should be done there. CRM's transaction data model, is not very adequate for complicated reporting.

      Message was edited by: João Sousa

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.