Skip to Content
avatar image
Former Member

CRM Table for Transactional data

Hi experts,

I m looking for a Table in CRM where i'll get all the transaction related data(i.e.All partners, products, status, process types etc) like we have FM CRM_ORDER_READ from this we can get all the tranaction related data.

Thanks to you !!!!

Vivian

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 07, 2009 at 07:04 AM

    Hi Vivian,

    You need to refer different tables for that like:-

    CRMD_CUSTOMER_H

    CRMD_CUSTOMER_I

    CRMD_ORGMAN

    CRMD_ORDER_INDEX

    CRM_JEST

    Regards,

    PePe

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi sree,

      Thanks for u r reply, as per u i can link between CRMD_ORDERADM_H table and CRMD_LINK (Hi guid)with common order guid but when it comes to joining table CRMD_LINK(set guid

      ) and CRMD_PARTNER guid i m not able to get the link which join both table(set guid does not match with any guid in CRMD_PARTNER table)

      Where to relate set guid from CRMD_LINK table ?

      Thanks alot !!!

      Vivan.

  • avatar image
    Former Member
    Apr 07, 2009 at 07:44 AM

    Hi vivian,

    below table should solve ur complete issue:

    CRMDLINK_PARTNER - Partner table

    CRMD_ORDERADM_I - Item level data for Transactional data

    CRM_JEST - Status table

    CRM_ORDERADM_H - Header Transaction table

    CRMD_ORDER_INDEX - Process type, partner, current phase

    Thanks,

    Anu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 08, 2009 at 06:54 AM

    Hi,

    As stated above there is no single table that holds all the transaction data. It is stored in different tables. If there is a requirement to pull all the transaction data, try and use the CRM_ORDER_READ as it provides an efficient way of getting the data.

    Regards,

    Chaitanya

    Add comment
    10|10000 characters needed characters exceeded

    • Vivan,

      The answers above are correct, CRM does not store all the data in one table like ERP. As far as the factsheet the data is stored across several different areas. So you need to tell us what part of the factsheet data you are looking for and you might get an answer.

      In the future please do a search before asking, or make sure your question is more detailed as your original question was too broad for anyone to provide a reasonable answer.

      Thank you,

      Stephen