table to retrieve sales orders per sales area and BP name

[jerome_lim]

hi,

I am looking for tables or reports where I can retrieve business transactions base on per sales area and / or BP's ex. name of the BP's.

the crmd_order_index contains BP number but it contains both header and items of the orders, is it possible to find the total amount of header grouped by BP in SAP Query ?

Thank you.

Benj.

Moderated: Please use the search before posting.

Message was edited by: Andrei Vishnevsky

[Former Member]

You can use Business transaction category as 'BUS2000115' (for Sales Order) along with Sales Area and BP data as input. Remove all the duplicates header guids. This guid set should be passed to crmd_orderadm_h to get the business transactions.

[Former Member]

Hi Jerome,

I think you can use the table CRMD_ORDER_INDEX. Just that records that have same header and item guid are related to header and the ones that have different item guid and header guid are related to item.

Or am I missing something?

Regards,

Niraj