SQVI - Quick Viewer - Avoid Duplicates

[Former Member]

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

[Former Member]

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?

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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