Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying all components for a product with each occurance of that product

Hello all,

I'm using BO6.5 SP4 and have the following problem.

I have 2 queries.

The first one retrieves the customer and products sold.

The second one retrieves the components belonging to the products sold.

Suppose the result of the first query is:

Customer.........._Product_

Cust_1..............Prod_1

Cust_2..............Prod_1

Cust_3..............Prod_1

The result of the second query:

Product........._Component_

Prod_1..........Comp_A

Prod_1..........Comp_B

Prod_1..........Comp_C

Prod_1..........Comp_D

What I would like to see in the report is:

Customer........._Product_........._Component_

Cust_1.............Prod_1..........Comp_A

Cust_1.............Prod_1..........Comp_B

Cust_1.............Prod_1..........Comp_C

Cust_1.............Prod_1..........Comp_D

Cust_2.............Prod_1..........Comp_A

Cust_2.............Prod_1..........Comp_B

Cust_2.............Prod_1..........Comp_C

Cust_2.............Prod_1..........Comp_D

Cust_3.............Prod_1..........Comp_A

Cust_3.............Prod_1..........Comp_B

Cust_3.............Prod_1..........Comp_C

Cust_3.............Prod_1..........Comp_D

But what I get is the following:

Customer........._Product_........._Component_

Cust_1.............Prod_1..........Comp_A

Cust_2.............Prod_1..........Comp_B

Cust_3.............Prod_1..........Comp_C

Cust_3.............Prod_1..........Comp_D

Does anyone have a solution to this problem?

Regards,

Harry

Not what you were looking for? View more on this topic or Ask a question