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

SQVI Query: Parent-Child company report


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


- 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,


Posts: 1

Joined: Fri Jan 23, 2009 1:38 pm