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