Code Issue

[Former Member]

Please use a meaningful subject in future

There has been a confusion regarding the performance for fetching the data...

There are two ways to fetch the data that have been suggested to me :-

a) Using for all entries if the data is to be fetched using non-key fields or inner joins if data is fetched using key fields in where clause.

b) Using standard Function modules to fetch data, which means no joins no queries, but these FM obviously use select statements in their code and morever in most of them they use select single * that means all fields are selected not according to program need. And as its using select single , i have to use FM for every field i need to fetch that too inside a loop based on some values . That means multiple FM's in a single loop ( eventually resulting in multiple single * in loop).

<<text removed>>

Thanks

Vijeta

Edited by: vijetasap on Jun 26, 2009 7:40 AM

Edited by: Matt on Jun 26, 2009 8:05 AM - don't say it's "urg".

[Former Member]

Hi,

Go gor for all entries option

[Former Member]

Hi,

I think for all entries is better than using mutliple FMs.

One thing u can do that write sample program using for all entries & 2-3 FMs, then u can check with SE30 which is going to be better.

Thanks & Regards,

Anagha Deshmukh

[Former Member]

So What are the tables involved ?

If you can do it with For all entries no need for FM as it is selecting only one row.

Regards

Karthik D

[rainer_hbenthal]

Go for join instead of for all entries. In most cases this is possible. For all entries will end up in several select statements internally deoending on size of entry table and configuration of the database.

[matt]

Please use a meaningful subject in future

Moved to the performance forum...

[Former Member]

you must be more specific, what standard FMs are you talking about.

Usually there is reason why there are standard FMs and you should use them, maybe you just don't known that there is also one for multiple rows.

Siegfried

[Former Member]

For examole to get the customer name based on the customer number from billing data VBRK.

FM used is WB2_READ_CUSTOMER_NAME which uses select single * in it......

As i have multiple billing documents to display in ALV selected on certain criteria.

For reading customer name shall i use for all entries or call This FM in loop.

[Former Member]

I prefer to build my own SELECTS based on the requireemnts. This gives me more control. An added bonus, is that I learn more about how the application works technically.

Rob