Question Re: RFC Function Module to fetch Table data in Technology Q&A

RFC Function Module to fetch Table data

former_member233553 — Wed, 20 Sep 2017 13:29:47 GMT

Hi Team,

We are using RFC_READ_TABLE Function module to fetch reference data from LAGP (Storage Bin data) table, but the issue is in destination server, there are more ther 1 Lakh data, but we are only able to fetch 1.23k data by this function module, please help me out, if anything is missing out.

Regards

Kumar.

Re: RFC Function Module to fetch Table data

weberpat — Wed, 20 Sep 2017 14:25:24 GMT

Hi Kumar,

RFC_READ_TABLE has many limitations and shortcomings and you should never use it in a productive scenario. However, I don't recall that a restriction of the number of rows that can be returned is one of them. Are you getting any errors?

In any case, it's a good practice to download data in slices when dealing with this type of volume. Have you tried restricting the result to say 1000 rows and using the rowskip parameter to fetch the data in multiple iterations?

Regards,

Patrick

Re: RFC Function Module to fetch Table data

RaymondGiuseppi — Wed, 20 Sep 2017 14:32:55 GMT

First read 382318 - FAQ|Function module RFC_READ_TABLE, then (at your own risk) you can look for parameters ROWSKIPS and ROWCOUNT and multiple call of the FM...)

But what is the actual business requirement to extract the whole table?

Re: RFC Function Module to fetch Table data

Sandra_Rossi — Wed, 20 Sep 2017 17:05:28 GMT

1 Lakh = India word for 100.000 in international numeric system

Re: RFC Function Module to fetch Table data

former_member233553 — Wed, 20 Sep 2017 17:17:39 GMT

Hey Patrick

Once I put 2300 in rowcount parameter it is giving 1123 records and it is fixed for all time.

Re: RFC Function Module to fetch Table data

former_member233553 — Wed, 20 Sep 2017 17:33:25 GMT

Hey Raymond,

Actually we want to sync up LAGP storage bin data from one system to another, we have written a custom program for this function, inside the program we are calling the FM.

Re: RFC Function Module to fetch Table data

NTeunckens — Wed, 20 Sep 2017 19:24:47 GMT

Please check the following references on how to experiment with "RFC_READ_TABLE" :

SAP-KBA 1752954 : link
Working around limitations of TableReader / RFC_READ_TABLE Symptoms : link

Re: RFC Function Module to fetch Table data

former_member233553 — Thu, 21 Sep 2017 05:46:58 GMT

Hi Nic,

Thanks a lot for your quick help, I have created the custom FM but once I am running this FM system is throwing runtime error CALL_FUNCTION_Not_found, and in your link lastly mentioned is some think like that,
tr = s.GetTableReader("some_table")

 tr.Option("tablereader.transportcall") = "ZRFC_READ_TABLE"
 tr.Read(0,0)
Where I need to add this thing.
Also output is giving differently for different tables.

Regards
Kumar.

Re: RFC Function Module to fetch Table data

RaymondGiuseppi — Thu, 21 Sep 2017 06:29:03 GMT

Didn't you find any less ressource intensive solution, like some delta load or a standard/custom tool like an Idoc/change pointer solution, even considering some implicit enhancements in function group L01S which contains the L_LAGP* update FMs?

Re: RFC Function Module to fetch Table data

Sandra_Rossi — Thu, 21 Sep 2017 07:04:36 GMT

I second @weberpat in that by default RFC_READ_TABLE returns all rows of the logged-in client. So, if it doesn't return the rows you expect, then it means that you don't log in the right system/client.

Re: RFC Function Module to fetch Table data

NTeunckens — Thu, 21 Sep 2017 14:46:13 GMT

The RFC "Z_AW_RFC_READ_TABLE" is not always provided / installed straight away (it is part of "SAP Data Services"). Please verify if SAP-BASIS is able to obtain this RFC-code as is mentioned in some other posts (link, link).

They should be able to 'install' this additional RFC.

Alternatively, some people also suggest making use of RFC "/BODS/RFC_READ_TABLE" ...

Re: RFC Function Module to fetch Table data

former_member233553 — Mon, 25 Sep 2017 04:44:37 GMT

Hi Nic,

Thanks a lot we are trying to do same, will let you inform.

Regards

Kumar.

Re: RFC Function Module to fetch Table data

former_member233553 — Mon, 25 Sep 2017 10:05:16 GMT

Thanks Nic,

We have done, BASIS has installed it.

Re: RFC Function Module to fetch Table data

NTeunckens — Mon, 25 Sep 2017 10:11:36 GMT

Great (you have some willing / fast BASIS people) ...

Hopefully this can set you on the path to a solution.

Please Close the Question if this has actually answered your Query.

Re: RFC Function Module to fetch Table data

kiran_k8 — Mon, 25 Sep 2017 10:30:47 GMT

Kumar,

Read many threads, stating that using this FM in PRD is not advisable and will not be consistent as it is not released for Customer usage.

Btw did you tried Open Cursor/Fetch Cursor/Close Cursor methodology while writing the select query of this table ?

K.Kiran.