Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP QUERY double display

Go to solution
Former Member

‎04-13-2010 2:18 PM

0 Kudos

Hi,

I have created a SAP Query with 3 tables AUFK, COEP and PA0001.

The selection contains the orderno. from AUFK (=base table), company code, year and period from COEP.

The display contains orderno. personnelno., name, quantity hours and costs, document no etc.

In the display I get the records 3 times. Where is the mistake? Or can I hide the double records? If yes, how?

Thanks a lot.

Best regards

Vela

1 ACCEPTED SOLUTION

Go to solution
vinod_vemuru2
Active Contributor

‎04-13-2010 2:26 PM

0 Kudos

Hi,

Welcome to SCN!!!.

Actually, you are not getting double records. One of the key fields of the table might be different. Just try to select all the key fields of all the tables into output display and see the difference.

Thanks,

Vinod.

2 REPLIES 2

Go to solution
vinod_vemuru2
Active Contributor

‎04-13-2010 2:26 PM

0 Kudos

Hi,

Welcome to SCN!!!.

Actually, you are not getting double records. One of the key fields of the table might be different. Just try to select all the key fields of all the tables into output display and see the difference.

Thanks,

Vinod.

Go to solution
Former Member
In response to vinod_vemuru2

‎04-13-2010 4:19 PM

0 Kudos

Hi Vinod.

thank you.

The record was three times in table PA0001, because all changes are also listed there.

I have changed the selction.

Regards,

Vela