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
Showing results for 
Search instead for 
Did you mean: 

SQVI - Quick Viewer - Avoid Duplicates

Former Member
0 Kudos

Hi All,

I am running a Quick Viewer and need to display the Count of records for each month.

Now I have 2 records for each Employee.(Say 1 for dental and 1 for medical)

Say I have 5 employees,So I could display the Count as 10 records.

But in Actual I need to display the count as 5 because there are 5 employees.

Since in my dataset 2 records are fetched for each employee,Record count is many a times double the employee count .

Is there anyway we could avoid duplicates in Quick viewer.

Edited by: Kumar B on Nov 3, 2009 9:48 AM

6 REPLIES 6

Former Member
0 Kudos

depends upon the infoset you are creating.

you can put all the unique identifier to your selection screen... and fetch only one record for each employee of that table..

which table are you referring?

0 Kudos

I am using a custom infotype table in HR similar to the IT0167 (health plans).

Problem is few employees have medical and dental,Few have only medical and few Only dental.

Thus making it difficult to get the actual count of employees.

Thank you,

Edited by: Kumar B on Nov 3, 2009 10:19 AM

0 Kudos

there has to have some identifier in that table for those two lines.. right? like line number... posnr ... use that..

0 Kudos

Here we have the Subtype differing say 1MED for medical and 2DEN for dental ,

But if we use this filter with say "Medical",We could not track the employees with only dental records

Edited by: Kumar B on Nov 3, 2009 10:31 AM

0 Kudos

for that query.. generate a abap program.. then edit that.. never tried.. but check..

0 Kudos

We are using the Quick Viewer..and there is no such option available.