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

[Former Member]

what is better ?

[Former Member]

Hi Eliram,

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

Use it how you prefer,

Heinz

[Former Member]

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

[Former Member]

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.