RFC_READ_TABLE performance

[Former Member]

All,

I'm using this standard FM RFC_READ_TABLE to access data from several tables in another SAP system.

I have to call this function module 4 times one each for VBAK, LIKP, LTAK and MKPF tables.

I would like to know if there would be any performance issues if this FM is called several times for different tables.

Please help.

Meghna

[HermannGahm]

Hi,

if you do one call per table it depends on the data volume that has to be read from each table

and how this tables are accessed in the remote system (where clause and indexes).

Setup a SQL Trace in the remote system to see how the tables are accessed.

The transfer time of the rfc depends mainly on the data volume in this case.

Kind regards,

Hermann

[Former Member]

Meghna,

The RFC_READ_TABLE FM will not cause performance issue just for using multiple times. It is very important how you set the selection filters in the FM parameters. Set this parameter considering primary & secondary index while calling RFC for each table. This will keep source system performance good. Remember, RFC performance degrades exponentially with increase in data volume. So ensure minimum data is returned. This will ensure good RFC call performance.

BR,

SB.

[former_member251078]

RFC tables are high volatile tables. So you need to rebuild the indexes corresponding to RFC tables. Also if you are using Oracle as backend system, there are seperate statistics provided for these tables, these should be take care to improve the performance.

Yours Sincerely

Dileep

[HermannGahm]

Hi Dileep,

>

> RFC tables are high volatile tables. ...
> Dileep

While this is right for RFC status tables like e.g. ARFCSTATE and others, the OP asked

> for VBAK, LIKP, LTAK and MKPF tables

and these are not volatile...

Kind regards,

Hermann

[Former Member]

Hi Megha ,

I would suggest to create you own remote FM with desired functionality and fetch the data of all four tables in one call.

Select data from these tables based on your conditions , this will reduce the data fetched each time.

It should give you some improvement in performance.