Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

Former Member

‎01-13-2009 9:33 AM

0 Kudos

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.

4 REPLIES 4

Former Member

‎01-13-2009 9:37 AM

0 Kudos

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.

sujeet2918
Active Contributor

‎01-13-2009 9:50 AM

0 Kudos

hello Pawan,

have you written any code in your query?

regards,

sujeet

Former Member
In response to sujeet2918

‎01-13-2009 3:47 PM

0 Kudos

hi all

thanks very much for ur help ,

i got the problem , actually in table joining conditions data is comming like this .

tushar_shukla
Active Participant

‎01-13-2009 11:12 AM

0 Kudos

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