RFC Function Module to fetch Table data

[former_member233553]

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.

[Sandra_Rossi]

1 Lakh = India word for 100.000 in international numeric system

[weberpat]

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

[former_member233553]

Hey Patrick

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

[kiran_k8]

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.