topic Re: Code Issue in Application Development and Automation Discussions

Code Issue

Former Member — Fri, 26 Jun 2009 05:40:22 GMT

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".

Re: Code Issue

Former Member — Fri, 26 Jun 2009 05:42:37 GMT

Hi,

Go gor for all entries option

Re: Code Issue

Former Member — Fri, 26 Jun 2009 05:47:34 GMT

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

Re: Code Issue

Former Member — Fri, 26 Jun 2009 05:56:04 GMT

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

Re: Code Issue

rainer_hbenthal — Fri, 26 Jun 2009 06:01:31 GMT

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.

Re: Code Issue

matt — Fri, 26 Jun 2009 06:07:34 GMT

Please use a meaningful subject in future

Moved to the performance forum...

Re: Code Issue

Former Member — Fri, 26 Jun 2009 09:01:17 GMT

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

Re: Code Issue

Former Member — Fri, 26 Jun 2009 09:21:10 GMT

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.

Re: Code Issue

Former Member — Fri, 26 Jun 2009 13:07:27 GMT

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