SAP QUERY

[former_member213868]

Hi all

I had developed a query and it is for customer credit report ,but when i execute the transaction i get the results duplicated. That means same data is repeted once again for the same customer .

kinldy guide

Baranidharan

[Former Member]

Baranidharan,

In queries, data duplication usually happens when you select data from tables which provide information at different levels for e.g. one table at header level and one at item level. If you need the data from the item level table without duplication then if possible select only from one item by providing item number field on selection table.

For e.g. you want to write a query to find out delivery numbers from sales order numbers using VBFA table by providing only the sale order number then include field VBFA-POSNN in selection screen of query and set the value to 10. This way only one record per sales order will be displayed from VBFA table.

Hope this helps.

Regards,

Amit