SAP QUERY double display

[Former Member]

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

[Former Member]

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

[vinod_vemuru2]

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.

[Former Member]

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