Skip to Content

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

Urgent: InfoSet Query Problem

Hi:

I have a question related to the InfoSet issue I have been experiencing.

I have a SD ODS which has e.g Material, Cal Year/Month and Sales Qty, Sales Amt. I have another ODS which contains BOM (Bill Of Material Data) consists of Material, Components and Qty for each component. I created an InfoSet by using material as join field between this. When I created a query it shows report as shown below.

Material Component Sales Qty Sales Amt BOM Qty

111 AAA 1000 500 50

111 BBB 1000 500 20

111 CCC 1000 500 10

It means It keeps sales Qty for each component so at aggregated level my sales qty and amt is 3000 and 1500 resp. Which is not correct. What can I do in order for Sales Qty & Sales Amt not to repeat. Any help will be appreciated.

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