topic Re: SQVI - Quick Viewer - Avoid Duplicates in Application Development and Automation Discussions

SQVI - Quick Viewer - Avoid Duplicates

Former Member — Mon, 02 Nov 2009 21:04:16 GMT

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 — Tue, 03 Nov 2009 15:16:00 GMT

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 — Tue, 03 Nov 2009 15:19:09 GMT

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 — Tue, 03 Nov 2009 15:26:52 GMT

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

Former Member — Tue, 03 Nov 2009 15:31:03 GMT

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 — Tue, 03 Nov 2009 15:35:53 GMT

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

Former Member — Tue, 03 Nov 2009 15:58:26 GMT

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