cancel
Showing results for 
Search instead for 
Did you mean: 

Blank records in Infoset Query

madhukarbhat
Explorer
0 Kudos

Hi,

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.

Thanks,

Madhukar

Accepted Solutions (1)

Accepted Solutions (1)

madhukarbhat
Explorer
0 Kudos

Hi All,

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.

Thanks,

Madhukar

Answers (1)

Answers (1)

former_member182377
Active Contributor
0 Kudos

Hi Madhu,

Can you please share the screenshot.. Have you selected output field as well in infoset . that could be the issue?

Thanks

Sriram