Skip to Content
author's profile photo Former Member
Former Member

ABAP Querry report ,same records are repeating in output report.

hi guruz,

I have one abap querry report.

in output its showing same records are repating .

i debug the programm also which is system generated programm using cursor and all.

where i can see that how is appending in output table,means any tcodes are there.?

please guide me .

warm regards.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 09:37 AM

    Goto SQ01 & check the query & what are the fields are getting pulled.

    You can check the infoset in SQ02 & here you can check the join condiions mentioned.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 13, 2009 at 09:50 AM

    hello Pawan,

    have you written any code in your query?

    regards,

    sujeet

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 13, 2009 at 11:12 AM

    Hi Pawan,

    Possible reason: Primary key fields of table are not included in output fields of query .

    Take a simple example of a query based on Inner join of VBAK and VBAP tables .

    Selection screen : VBELN

    Output fields: VBELN ,ERNAM, MATNR , NETWR..

    Now if POSNR is not included as Output field ; this may result in repetition of records .

    So try to take all primary key fields of tables or make them mandatory parameter on selection screen.

    Hope this may help you. Do let me know if you have any doubt.

    Regards,

    Tushar

    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.