Skip to Content
0
Mar 31, 2008 at 04:02 PM

Order Query in SQ01 using Table Joins in CRM

56 Views

Hello Experts,

I am trying to create a query using table joins in SQ01 in CRM because I need a report that will give me all transactions for a selected Business Partner. I am unable to display any results when running my query. I have found other threads which give a list of possible tables to join together, but the fields used in the joins were not described.

The tables I have joined in my query are as follows:

CRMD_ORDERADM_H

CRMD_ORDER_INDEX

CRMD_PARTNER

BUT_000

I have used SE16 to try to search for additional tables to use for linking the Business Partner with a transaction, but I have been unsuccessful.

Would anyone please give advice as how to proceed?

Reward points are available!

Thank you in advance,

David