Need some help on CRM tables which have the details of the order created

[Former Member]

Hi,

Can anyone help me in knowing the tables which stores the information of an order . I need to find the status, priority, category and the partner functions of a particular order. Is there any table which stores all these data.

Thanks & Regards,

Anuradha.P

[Former Member · Accepted solution]

Hi Anuradha,

basically you link partner function of an order with view:

CRMV_LINKPARTNER.

In this view you can find :

Guid of an order coming from CRMD_ORDERADM_H

Guid of BP coming from BUT000,

and <b>partner function</b> stored in field PARTNER_FCT.

For sold-to-party you have to select 00000001.

Concerning priority and category I suggest you investigating with "where used list", tool in which tables the data element is used.

Then start from CRMD_ORDERADM_H or CRMD_ORDERADM_I , and with the guid go to CRMD_LINK.

Extract the proper Guid set and try going into the table/s you select, previuosly.

Regards,

AndreA

<b></b>

[Former Member · Accepted solution]

Hi Anuradha,

for status you can use table CRM_JEST.

Here you can find the history of the status of your order.

Regards,

AndreA

[Former Member · Accepted solution]

Thanks a lot Andrea for your answers.......

Anuradha.P

[Former Member · Accepted solution]

Hello Anuradha,

Can you mail me to crm500 (middleware ) document . I know u.

Please send me the docmentation.

gskraju.crm@gmail.com

Regadrs

Satish