topic Re: What is the difference between select and select via function normal/rfc in Application Development and Automation Discussions

What is the difference between select and select via function normal/rfc

Former Member — Thu, 03 Apr 2008 13:00:23 GMT

what is better ?

Re: What is the difference between select and select via function normal/rfc

Former Member — Thu, 03 Apr 2008 23:25:41 GMT

Hi Eliram,

None is better, none is worse. It depends on your programming style.

Use it how you prefer,

Heinz

Re: What is the difference between select and select via function normal/rfc

Former Member — Fri, 04 Apr 2008 05:49:07 GMT

Hi do you men to say select using function module ? A function module is a reusable piece of code - so if you are using some common data extraction across different programs you can put the same select inside a function module and call it from different programs.

If you want to get data from some other SAP system (say from a R/3 server wants to get some CRM data from the CRM system) you have to use RFC function module.

-Regrads

Ashim

Re: What is the difference between select and select via function normal/rfc

Former Member — Sat, 05 Apr 2008 14:27:31 GMT

Hi,

It depends on yr reqmt.

Incase of fewer records, SELECT is better because of the foll reasons.

1) it hits dbtab only once for few records

2) using fm, it's a reusable code, which will result in so many other lines of code are also a part of it.

If you're not sure of the number of records even tentatively, use GET RUNTIME statement to find the execution time of both these SELECT and FMs and go accordingly.

Reward if found helpful.

Thanks,

Vaishnavi.