sales office wise sales orders

[Former Member]

Hi,

How to find the area or sales office wise sales orders created by users in CRM can anyone give the table name ?

i was checked in CRMD_ORDERADM_H i am not getting...

Regards

MVN

[Former Member]

You will get this information in this table CRMD_ORDER_INDEX

Regards,

Shiva Kumar

[Former Member]

Hi,

Use table CRMD_ORDERADM_H

OBJECT_ID = sales doc

CREATED_BY

Link to get sales office, sales group..

CRMD_ORDERADM_H->GUID to link with table CRMD_ORDER_INDEX->HEADER

CRMD_ORDER_INDEX->OBJECT TYPE = BUS2000115

Fields

SALES_OFFICE

SALES_GROUP

Regards,

Nilesh P.