cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182350
Active Contributor
0 Kudos

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>

Former Member
0 Kudos

Hi

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

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

Regards

Arden