Skip to Content

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

SAP QUERY double display


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


Former Member
Former Member replied


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.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question