Problme in Using RFC_READ_TABLE

[Former Member]

Hello

I am calling FM RFC_READ_TABLE.In that in the otions structure I need to pass the date range. So I am passing the date reange like AS4DATE >= '01/01/2008' and AS4DATE <= '13/01/2008'.But its not returning any values although the table E070 contain values for these date ranges.If I only pass one date (i.e.AS4DATE >= '01/01/2008' then it gives the results properly.

Kindly suggest.

Regards

Davinder Singh

[Former Member]

Hello

I am calling FM RFC_READ_TABLE.In that in the otions structure I need to pass the date range. So I am passing the date reange like AS4DATE >= '01/01/2008' and AS4DATE <= '13/01/2008'.But its not returning any values although the table E070 contain values for these date ranges.If I only pass one date (i.e.AS4DATE >= '01/01/2008' then it gives the results properly.

Kindly suggest.

Regards

Davinder Singh

[Former Member]

Your date needs to be in the format yyyymmdd.

[Former Member]

Hi Martin

Its working fine when I changed the date format.But if I give the date range along with another selecton criteria it doenot give any result for e.g. in E070 table I have to restrict the entries by TRKORR and AS4DATE(Date). So I have given in the options like this:

TRKORR EQ 'GLDK967876' AND

AS4DATE >= 20080101 AND

AS4DATE <= 20080113.

Now the above code doenot work.

If I write like this beow then it works.

TRKORR EQ 'GLDK967876' AND

AS4DATE >= 20080101.

Could you please advise.

Regards

Davinder Singh

[Former Member]

Hi Davinder,

I have experienced you problem when I have integrated our SAP ECC to our legacy system built using Microsoft .NET simply enclosed the date in yyyyMMdd format inside a single quote.

Please see this:

TRKORR EQ 'GLDK967876' AND

AS4DATE >= '20080101' AND

AS4DATE <= '20080101'

This worked for me. Before, I was having a hard time determining why the date range is not working.

Regards,

Jkyle