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.
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.