Skip to Content
0
Sep 03, 2011 at 08:24 PM

Query report with duplicate information

39 Views

Hi group,

Our users need a report with following information:

begda/endda/kostl from IT0001

begda/endda/kostl from IT0027

This causes a lot of records when output is for a period.

We then get a lot of lines with repetive values, for 2 reasons:

- Many breaks in IT0001 without KOSTL-change

- Breaks in IT0001 and IT0027 can be on different dates causing a sort of cartesian product.

The infoset switches do not seem to help me, since outputting begda-endda makes the records not uniqe.

Can anyone help me with a way to make output better in query?

(I realize a report could fix this by merging records iin eg. IT0001, but I do not want to do an ABAP report).

Any hints appreciated

I give an example below.

Thanks

/Kirsten

Example

IT0001:

01.08.2007 31.08.2010 1120

01.09.2010 30.09.2010 1120

01.10.2010 30.06.2011 1120

01.07.2011 30.09.2011 1120

01.10.2011 31.12.9999 1120

IT0027:

10.08.2009 09.05.2010 1120

10.05.2010 31.12.9999 1130

Asking for a report on 01.01.2010 - 31.12.9999 (IT1 and IT27) gives a rather unpleasant result:

01.08.2007 31.08.2010 1120 10.08.2009 09.05.2010 1120

01.08.2007 31.08.2010 1120 10.08.2009 09.05.2010 1130

01.08.2007 31.08.2010 1120 10.05.2010 31.12.9999 1130

01.09.2010 30.09.2010 1120 10.05.2010 31.12.9999 1130

01.10.2010 30.06.2011 1120 10.05.2010 31.12.9999 1130

01.07.2011 30.09.2011 1120 10.05.2010 31.12.9999 1130

01.10.2011 31.12.9999 1120 10.05.2010 31.12.9999 1130