Skip to Content

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

How to avoid the records from doubling?


I have a very simple scenario.

In table 1 I have records displaying account numbers and the dates in which these accounts were contacted. There are multiple records for the same account number as there must of been multiple contacts.

Acct1   7-25-2012

Acct1   7-26-2012

Acct2 .......  and so on

In table 2 I have data related to the sales lines for the whole month of July.

With my current selection the sales lines records are doubled or tripled etc. based on the number of times the same record exists in table 1.

How do I refine the selection criteria to look at the table 1 and display records from table 2 only once?

Both tables are joined by the Account# field.

Any help would be greatly appreciated!

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