cancel
Showing results for 
Search instead for 
Did you mean: 

Data is doubled in the report compared to SAP R/3

Former Member
0 Kudos

Hi,

when we ran the query, Data is doubled in the report compared to SAP R/3. Please help me to know how to analyse the problem to find the root cause.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Do you mean the same data is repeating?

Former Member
0 Kudos

Check the Joins in the query. Frequently, data will appear duplicated by a join because the join keys have multiple records in one (or both) of the two tables being joined. You can get around this in several ways, depending on your needs. Possibilities include: Adding fields used to join the tables; Adding conditions to the table with duplicates to eliminate them; Group the table with duplicates on the fields used in the join; Use SELECT DISTINCT to eliminate duplicates; etc., etc., etc.

HTH,

Carl

Answers (0)