We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-newbies-l] CON2 runs slowly

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by jerry_chen
on Jul 15 at 10:51 PM 		Mark this reply as helpfulMark as helpful
Thank u very much!After applied 1291161,it return good now!

---------------Original Message---------------
From: R. Neal Wilhite
Sent: Thursday, July 15, 2010 11:30 AM
Subject: CON2 runs slowly

> If you applied note 1291161
> Then it created a revision to the coep select.
>
> SELECT SINGLE * FROM coep INTO ls_coep_kl "1291161
> where kokrs = ls_coep_or-kokrs "1291161
> AND objnr = ls_coep_or-uspob "1291161
> AND wrttp = ls_coep_or-wrttp "1291161
> AND versn = con_versn_000 "1291161
> AND parob1 = ls_coep_or-objnr "1291161
> AND belnr = ls_coep_or-belnr "1291161
> AND zlenr = ls_coep_or-zlenr. "1291161
>
> Now make sure that you database statistics are up to date. Otherwise, it will pick an index that will make things worse. If things don't improve. Create an index on
> mandt, kokrs, objnr, wrttp, versn, parob1, belnr, zlenr
> And refresh the statistics on coep...
>
> Let us know how that works.
>
> Neal

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language