Skip to Content
0
Former Member
Jan 01, 2009 at 02:32 AM

exclude Materials with only 1 PO count

10 Views

Hello experts,

I have a multiprovider with 5 DSOs corresponding to 5 Logical SOurce systems.

All DSOs have a similar structure..like .....

Logical Source System, PO number , PO item, Material, quantity, price..........

In a query I wish to compare prices of a material for all logical source systems.

To reduce the number of rows,

I wish to exclude those materials which have just one PO across all 5 logical source systems.

Can you tell me how to exclude such rows with just 1 count?

Regards

Surekha