Skip to Content
0
Former Member
Jan 27, 2009 at 05:32 PM

SQVI Query: Parent-Child company report

112 Views

Hi Experts,

I am relatively new to SQVI and was wondering if anyone could assist me with the following query. I use CRM v5.0 and want to build a query that returns all child company entities for a single parent BP number - this ideally would also include all addresses assigned to each child. I have experimented with the following CRM tables/fields to return a list of child companies (without addresses) with no success:

BUT000 (Parent)

- CUP (Parent) BP (Business Partner 1)

- 1st Name of Organisation

- 2nd Name of Organisation

BUT051

- Relationship Category (Has Child)

BUT000 Alias (Child)

- Child BP# (Business Partner 2)

- 1st Name of Organisation

- 2nd Name of Organisation

I'm quite sure I'm missing something in terms of tables, fields (or joins) that should be populated before this query will work. My apologies in advance if this is not the correct domain for this question but if you're able to shed any light on this, I would be very grateful.

Many thanks,

Tom

Posts: 1

Joined: Fri Jan 23, 2009 1:38 pm