Blank records in Infoset Query
Below is my scenario,
I am having a custom Infotype with Time constraint 2,
I have added this Infotype in the Infoset Query along with IT 0000 Pernr.
Now the data is as below:
IT 0000 start date - 01.01.2014 to 31.12.9999
Custom Infotype start date - 01.01.2012 to 31.12.9999
When I run the Infoset Query for the Employee with IT 0000 -PERNR and Custom Infotype,
I expect only one single row with different columns,
How ever I am getting two different rows, with first row having blank records for IT 0000 and value for Custom Infotype and
second line having IT 0000 value and again Custom Infotype values.
How do I get rid of the first blank line??
Please let me know if I am not clear on this, as I have tried to search entire SCN and could not find an answer for this behavior.
I have found a solution for this on my own,
Apparently we can overcome this issue by using switches in Infoset.
And I have used TIME_DEPENDENCE = 'INDEPENDENT' switch and it is working fine.