topic Re: Performance & Data in Application Development and Automation Discussions

Performance & Data

Former Member — Mon, 21 Aug 2006 15:01:41 GMT

Hi,

i have few questions to share.

1.When you have a select statement with in Loop..Endloop

and a Select and Endselect, which one do you prefer? and Why and which is best on performance wise.

2.What method do you suggest when you have some 10000 records to post to R/3 from legacy Vendor Master/Material Master (Master Data)

Thanks

Seshu

Re: Performance & Data

Former Member — Mon, 21 Aug 2006 15:05:41 GMT

hi Sheshu,

1.When you have a select statement with in Loop..Endloop

and a Select and Endselect, which one do you prefer? and Why and which is best on performance wise

<b>both the methods are not advisable to use speaking in terms of performance related issue ... but among both the methods select statement within loop and endloop is preferable ...</b>

2.What method do you suggest when you have some 10000 records to post to R/3 from legacy Vendor Master/Material Master (Master Data)

Regards,

Santosh

Message was edited by: Santosh Kumar P

Re: Performance & Data

RichHeilman — Mon, 21 Aug 2006 15:05:46 GMT

1) I suggest to always avoid a SELECT ENDSELECT. Why? Because each pass is a hit to the DB, you will want to use INTO TABLE of ITAB instead as it is one rould trip to the DB.

2) I like to use LSMW for standard objects.

Regards,

Rich Heilman

Re: Performance & Data

Former Member — Mon, 21 Aug 2006 15:05:56 GMT

Hi Seshu,

1). Both are not good. Select within a loop will lead to database access for each pass of the loop.

Select endselect is definitelly a no no as its a loop by itself.

Instead using ARRAY table select and using read with binary search is more useful and more efficient. Infact in companies they dont allow both the options mentioned by you in point 1. You will have to change the code.

2).You can use LSMW or CATT or use IDOC with COllect and Process options.

A simple BDC also would be fine at times.

Cheers

If it helps dont forget to reward points.

Re: Performance & Data

Former Member — Mon, 21 Aug 2006 15:06:17 GMT

hi,

we will prepfer select and endselect instead of select in loop-endloop. the select and endselect also act as a loop.

for 10k records use call transaction method.

Re: Performance & Data

Former Member — Mon, 21 Aug 2006 15:06:53 GMT

SELECT/ENDSELECT requires and fetch for each record.

LOOP/ENDLOOP loads everything into an itab, and is much faster.

Try to avoid the first method if you can.

Re: Performance & Data

Former Member — Mon, 21 Aug 2006 15:33:03 GMT

For vendor masters, you can use standard SAP program RFBIKR00. I'm not sure about material masters, but you can look at RM07MMBL. They are both documented.

Rob

Re: Performance & Data

Former Member — Mon, 21 Aug 2006 15:38:03 GMT

Instead of doing select in a loop , use select on the other table using for all entries of previous table key fields. and in the loop endloop use read.

Regards.

Re: Performance & Data

Former Member — Mon, 21 Aug 2006 16:15:09 GMT

> 1.When you have a select statement with in

> Loop..Endloop

> and a Select and Endselect, which one do you prefer?

> and Why and which is best on performance wise.

The best way is to use the SELECT statement with for all entries in itab variation..in the above case. Basically it points to SELECT statement within Loop..Endloop.

> 2.What method do you suggest when you have some 10000

> records to post to R/3 from legacy Vendor

> Master/Material Master (Master Data)

LSMW

Regards

Anurag