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

From which table i can get Customer No, Cust Ref, Contact name

Hi CRM Experts,

I want some fields ie (Customer Number, Customer Reference, Contact Name, Account Manager) from which table i can get this fields according to the Object_id.

Provide any Tables names or Functional Module

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2007 at 01:17 PM

    Hi

    The BUT00* Tables should be a good place to start.

    <b>Reward with points if useful.</b>

    Regards

    Arden

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 22, 2007 at 01:19 PM

    Hello Santu,

    To get this info in the Sales order, following steps ways you can go:

    1. Get Sales Order header GUID from table CRMD_ORDERADM_H, as you have OBJECT_ID.

    2. Get the Sales order details by passing Header GUID to FM CRM_ORDER_READ and the exporting parameter table ET_PARTNER will give the parnter details of the Sales order. Read this ET_PARTNER table with partner function 0000001 i.e. sold to party which is customer number and check the ET_SALES Table where in PO_NUMBER_SOLD field will be refering to customer ref may be item level or header level depends on business,

    3. regarding the Contact name..check what is business requirement whether end customer contact or contact person of the customer.

    Hope it will help,

    Regards,

    Arjun

    <b>Reward points if it helps,</b>

    Add a comment
    10|10000 characters needed characters exceeded

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.