Skip to Content


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


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 13, 2009 at 05:52 PM


    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.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.