Duplicate entries in SQ01

[former_member270032]

Hi,

I was trying to get a Business Partners with active Budget billing plan. But when I used SAP query(Used Table Join - BUT000 & EABP), its showing duplicate entries also.

For example: If i am giving a BP number as selection criteria, its showing multiple entries for the same BP. I checked in table level, there the number of values are less and no duplicate entries.

Please guide me how to avoid this.

thanks

Vipin KV

SAP ISU Functional Consultant

[former_member206650]

hi vipin,

are you using inner join statement and you have joined using the key PARTNER and GPART?

if the problem persist can you try with select query because the data element are different..

hope it helps...

[Astrid_Gambill]

Have you tried filtering the EABP table to get just the active BPP?  you may be getting both old and current plans for the same customer.  Also, a customer may have several plans across multiple accounts.

Cheers

Astrid

[Former Member]

Hi Vipin.

Besides from what Astrid said, it might happen that youre not using all elements of the primary keys when doing the join, which would lead to multiple entries.

You can check the tables EABP and BUT001 for the link criteria. That might give you an answer.

Marko