Skip to Content
Jan 09, 2008 at 08:48 PM

How to show only current data in report and not all time dependent


Hello all,

I have created a query most of the infoobjects are time dependent. The data is personal and work information of an employee. what i am trying to do is display in the report employee and its work address (like building number, room number). Now the data in my BW system looks like this

Employee To Valid from Room Building

11 02/28/2006 01/01/1000

11 12/31/9999 03/01/2006 4555 HC

Now when I run the report and the data for employee 11 displays in two lines showing the 4555 and HC and also not assigned.

So basically what I am trying to do display data only for current time (current calendar day). I used the Key date and selected the SAP exit current calendar day but still I see two lines in report one for actual data (HC and 4555) and other line with "#" basically not assigned or no data.

Can some help me out in this .