Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Indexing on R/3 Tables

BW experts,

I am loading data from 2lis_o1_s261(Delivery) from SAP 3.1i R/3. Well when I send a data request from BW, the querying of the S261 Table is taking about 2 hrs for 150,000 records on an average. Is this a good performance?

(Compared to what you all seen before?)

Well FYI. it is just the query run time in R/3 but my upload job on BW runs fast(15 mins max).

Also this table S261 on R/3 is not indexed. So do you experts have any comments on this.

Thanks

Ashwin

Former Member
Former Member replied

Hi,

Performance wise it is not good, because it is taking long time. Is there any exits in that datasource?. And also it is depends on any routiens and formulals in BW trasfer rules and Update rules.See any short dumps in ST22 and also see the job log in SM37.If there is any other programs are working on that tables at that time also it will take time.

Thanks

Reddy

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question