Skip to Content
0
Former Member
Apr 13, 2010 at 10:37 AM

Quantity getting added up in query result from ODS 0SD_O06

30 Views

Dear Friends,

I have loaded 2LIS_13_VDKON in ODS 0SD_O06. Now, the ODS has lets say 4 rows for one invoice and against in each row there is a corresponding invoice quantity (0INV_QTY). Lets say the value in this field 0INV_QTY is 1 for a particular invoice.

so it will look like this:

Invoice || 0INV_QTY ....etc many other coloumns

12345 || 1

12345 || 1

12345 || 1

12345 || 1

When I run the query, the result would be one row for this invoice 12345. The quantity is coming up as 4 instead of 1 as it is getting aggregated.

What to do, so it would come as 1?

I tried exception aggregation - on 0INV_QTY, aggregating on BILL_NUM i.e. invoice # but same result.

Please suggest.

Thanks.