Which has a better perf, BAPI_AR_ACC_GETOPENITEMS or SELECT INTO TABLE?

[Former Member]

hi guys,

The program has BAPI_AR_ACC_GETOPENITEMS wrapped into a customized bapi. It take much time to execute. I was thinking if it would be better if I would just get the data directly from BSAD and BSID. SInce in the callin the FM will pass in table BKPF. Do you think it is better not to use this FM and retrieve the data from the table instead?

Points will be given...Thanks!

[Former Member]

hi guys,

The program has BAPI_AR_ACC_GETOPENITEMS wrapped into a customized bapi. It take much time to execute. I was thinking if it would be better if I would just get the data directly from BSAD and BSID. SInce in the callin the FM will pass in table BKPF. Do you think it is better not to use this FM and retrieve the data from the table instead?

Points will be given...Thanks!

[Former Member]

There is always some extra overhead when calling FMs. So from a performance standpoint it may make sense to SELECT directly from the tables.

But the FM overhead will be extremely small and you have the advantage of using standard SAP functionality to meet your requirements.

On the other hand the FM is doing extra database reads that you may not really need.

Do some testing - if the performance hit is small, stick with the BAPI.

Rob

[Former Member]

Hi,

It is better to use the select into table than using the FM's if you donot require the other logic present in the FM apart from fetching the entries from the database.

Regards,

Ranjani.